Job Step Set up

I am creating a job within Enterprise Manager on SQL 2K to backup a database called Messaging. In creating the step, on the General tab there are four fields: Step name, Type, Database, Command.
My Command is:
BACKUP DATABASE Messaging TO Messaging20050114 WITH NOINIT , NOUNLOAD , NAME = N'Messaging Full Backup', NOSKIP , STATS = 10, NOFORMAT
In relation to the above command, do I select Messaging from the database drop down list?
In relation to the above command, if Master is selected from the database drop down list, what is backed up, Master or Messaging?
Message posted via http://www.sqlmonster.com
You can select messaging if you want but you do not have to. This listbox
just tells the SQL Server job agent which database to execute the T-SQL
within. Since you are telling SQL Server to backup the messaging database
("BACKUP DATABASE Messaging") you do not have to select the database.
Either way the messaging database will be backed up.
Personally I would leave the database listbox set to master.
Keith
"Robert Richards via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:0feb5d1e2fea4bc386ad965ac4d66991@.SQLMonster.c om...
> I am creating a job within Enterprise Manager on SQL 2K to backup a
database called Messaging. In creating the step, on the General tab there
are four fields: Step name, Type, Database, Command.
> My Command is:
> BACKUP DATABASE Messaging TO Messaging20050114 WITH NOINIT , NOUNLOAD ,
NAME = N'Messaging Full Backup', NOSKIP , STATS = 10, NOFORMAT
> In relation to the above command, do I select Messaging from the database
drop down list?
> In relation to the above command, if Master is selected from the database
drop down list, what is backed up, Master or Messaging?
> --
> Message posted via http://www.sqlmonster.com