Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sdamlo027
Starting Member
1 Post |
 Posted - 2009-10-29 : 15:23:32
|
| Hello, We are going through are back-up procedures and are cleaning them up. Right now we have a sub-plan for almost each task (backup database, Shrink Database, Check database Integrity). What we want to do is create one or two sub plans. My question is: is there a preferred order of when to the run the task? Should we shrink the database first then back it up, or should we rebuild and reorganize the index first? Thank you |
|
|
|
|
|
Order for Maintenance Tasks