runal_jagtap (1/24/2013)
Sunday no one wotks on the Databasewill perfom the below activity..
1) Full Backup - Using manitenencae plan
2) Transaction Log Backup - Using manitenencae plan
3) Truncate Logs (this grows up to GB every day :angry: )
4) Update Statistics & then Rebuild Indexes - Using manitenencae plan
Please suggest
I suggest you reconsider that set of operations.
Please read through this - Managing Transaction Logs[/url]
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