I have been assigned the task of DBA for our company's
payroll system running on SQL server 2k. My question is
this - In the maintenance plan, database backups,
transaction backups, etc...under properties it is backing
up 'master', everything is fine. However, our database
is 'WFT' shouldn't the database be set to WFT instead
of 'master'? Or does master contain all databases? I just
want to be sure we are getting the proper backup. Also
the job has the No Truncate command which causes the
event 17055. Can this command be omitted and everything
still be OK?
Thanks in advance.
DarrylThe link here should help you
http://msdn.microsoft.com/library/d...>
_03_378k.asp
I suggest making 2 maintenance plans. I would do one for your System
Databases and select All System Databases in the wizard. Then do another
for All User Databases. For Backups I also have the wizard put all backups
in their own subdirectories. This makes viewing easier and you can easily
see what is going on.
Jeff Duncan
MCDBA, MCSE+I
"Darryl" <anonymous@.discussions.microsoft.com> wrote in message
news:824801c431db$326c6560$a001280a@.phx.gbl...
> I have been assigned the task of DBA for our company's
> payroll system running on SQL server 2k. My question is
> this - In the maintenance plan, database backups,
> transaction backups, etc...under properties it is backing
> up 'master', everything is fine. However, our database
> is 'WFT' shouldn't the database be set to WFT instead
> of 'master'? Or does master contain all databases? I just
> want to be sure we are getting the proper backup. Also
> the job has the No Truncate command which causes the
> event 17055. Can this command be omitted and everything
> still be OK?
> Thanks in advance.
> Darryl|||in addition to the answers you have been given, might I suggest you ask your
company to put a little investment into training for you (I am assuming that
a payroll system is quite important?!)
--
Br,
Mark Broadbent
mcdba , mcse+i
=============
"Darryl" <anonymous@.discussions.microsoft.com> wrote in message
news:824801c431db$326c6560$a001280a@.phx.gbl...
> I have been assigned the task of DBA for our company's
> payroll system running on SQL server 2k. My question is
> this - In the maintenance plan, database backups,
> transaction backups, etc...under properties it is backing
> up 'master', everything is fine. However, our database
> is 'WFT' shouldn't the database be set to WFT instead
> of 'master'? Or does master contain all databases? I just
> want to be sure we are getting the proper backup. Also
> the job has the No Truncate command which causes the
> event 17055. Can this command be omitted and everything
> still be OK?
> Thanks in advance.
> Darryl
