January 14, 2011 at 12:37 am
Hi everybody ,
This is paritosh i m trying to minimize size of my database back up file have size 8GB, so that i need to shrink database file from 8 GB size to comparable less size in MB , for that purpose i use Shrink DB utility of MS sql server 2005 Enterprise edition , but it does't decrease the size of DB fields.
i tried also DBCC commands , and shrink wizards.
Please give your valuable suggestion .
thanks & regard's
Paritosh
January 14, 2011 at 12:47 am
Shrink doesn't compress the database. It just releases unused space to the file system. It also will not change the size of a backup, as backups only contain the data in the database, not the free space in the database.
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
January 15, 2011 at 8:57 am
If all you need to do is shrink the backup file, look into the backup utilites that provide compression - or use a compression tool on the backup file (e.g. winziip, rar, 7zip, etc...).
Redgate has a couple of tools available, as well as Quest and Idera. You should review them and determine which one has the best features for your organization.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply