Are they set as simple mode? If so you cannot do a log backup. You would
need to go to into Enterprise Manager, right click on the database, go to
properties, options tab and set the recovery mode to full or bulk-logged in
order to perform log backups (I would recommend full).
-----Original Message-----
From: Zelli Brian
[mailto:mssqldba-ezmlmshield-x95497460.[Email address protected]
Sent: Wednesday, March 30, 2005 10:09 AM
To: LazyDBA Discussion
Subject: system t-log errors out
I set up a job to backup the transaction logs of the master, model, and msdb
databases. It errors but I can't see why. I've looked in the logs. Also
when I add the transaction logs to the full backup, it errors. Still can't
find why. Do I not need to back them up or won't the system let me or do I
have to do each individually?
ciao,
Brian
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]
MS Sql Server LazyDBA home page