September 30, 2008 at 8:45 am
Can some one tell me in what order optimization, integrity,transaction logs, complete back go for userdb and system db and do I set them up in the Maintance jobs or schedule jobs?Thank you
September 30, 2008 at 9:15 am
I prefer integrity before database backup, as there's no point in backing up a corrupt database.
Log backups shouldn't go in the same maint plan, as you need to run them a lot more often than full backups. I'd suggest every hour or so, to keep the transaction log under control.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 30, 2008 at 9:33 am
So for the system db and user db it is the same order right?
Optimization,Integrity,Full back up one maintance plan for system and the same plan for user db right?
Transaction logs should be two seperate jobs one for system, one for user right? Thank you
September 30, 2008 at 9:50 am
yulichka (9/30/2008)
Transaction logs should be two seperate jobs one for system, one for user right? Thank you
Most (if not all) of the system databases are in simple recovery model and hence don't need log backups. The only one that may be in full is MSDB.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 30, 2008 at 10:06 am
Thank you
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply