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 |
|
dhw
Constraint Violating Yak Guru
332 Posts |
 Posted - 2009-03-26 : 12:50:20
|
| Hi -I am setting up a monthly maintenance plan and I was wondering if it matters whether the Shrink operation occurs before or after a Full database backup. This is on a database that has Simple recovery model...but gets alot of inserts/deletes throughout the month as part of bulk load operations.My initial thought was that if I ran the Shrink operation before the backup...then my backup files would be smaller in size.Thanks - Will |
|
|
tripodal
Constraint Violating Yak Guru
259 Posts |
Posted - 2009-03-26 : 14:29:15
|
| The SQL backup will contain only the database, performing a direct file-copy of the mdb/ldb would also copy the freespace.Shrinking the database is not necessary in most situations, and will cause a lost of performance when the server expands it again later.SQL Manages and reuses the unallocated space in the database file. |
 |
|
|
|
|
|
Sequence for Backup and Shrink