March 23, 2006 at 1:09 pm
I am tring to backup the tansaction logs of a DB in Enterprise Manager and when I select Backup under Management and backup a database, I am unable to select the transaction logs as a choice. Is there a reason why it is grayed out.
March 23, 2006 at 3:34 pm
Is the database set to the Simple recovery model?
Greg
Greg
March 23, 2006 at 6:22 pm
Which database? Some system databases cannot have the log backed up. Master is one. It is always in SIMPLE mode.
-SQLBill
March 24, 2006 at 10:18 am
It is a user defined database not one of the system DB's
March 24, 2006 at 10:38 am
Yes the database is set to Simple recovery model. Should it be set to full and will this cause me any problems if I change it to full?
March 24, 2006 at 11:06 am
It won't cause any problems, except the Log file could grow larger. You will have to do log backups on a regular basis.
-SQLBill
March 24, 2006 at 12:18 pm
Thanks that fixed my issue.
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply