Hi,

I have some SQL Server 2008 64-bit
I use the following maintance plans,
could you give me some advice or something I missed:

db SYSTEM:
CheckDB Sun 1:00
ReorgIndex Sun 2:00
UpdateStats Sun 3:00
CleanHist Sun 4:00
BackupFull Sat 23:00
Maint (BAK, TRN, all db) Sun 5:00

db USER:
CheckDB Sun 1:00
RebuildIndex Sun 2:00
UpdateStats Mon-Sat 1:00
BackupFull Sat 23:00
BackupDiff Mon-Sun 23:00
BackupLog Mon-Sun 22:00

Thanks in advance

bob123 (bob123 (AT) gmail (DOT) com) writes:
I don't know what recovery needs you have, but backing up the transaction
log once a day seems to be a bit too seldom to me.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

Thanks,
I will backup log every hour now ...

"Erland Sommarskog" <esquel (AT) sommarskog (DOT) se> a écrit dans le message de news:
Xns9D11A53E820A5Yazorman (AT) 127 (DOT) 0.0.1...