how to reduce the DataBase bak file

Posted by Cnagasa under Sql Server on 12/9/2011 | Points: 10 | Views : 3011 | Status : [Member] | Replies : 3

Hello Everyone,

I have facing one problem,
How to reduce the database Bak File

Regard's
Sudarshan.C

sudarshan.c

Reply | Reply with Attachment

Posted by: Sksingh on: 12/9/2011 [Member] Starter | Points: 25

0	Hi, Perform shrink operation before taking backup. DBCC SHRINKDATABASE (UserDB, 10); The following example decreases the size of the data and log files in the UserDB user database to allow for 10 percent free space in the database. Follow link http://msdn.microsoft.com/en-us/library/ms190488(v=sql.90).aspx Regards, Sunil Cnagasa, if this helps please login to Mark As Answer. \| Alert Moderator

Hi,

Perform shrink operation before taking backup.

DBCC SHRINKDATABASE (UserDB, 10);

The following example decreases the size of the data and log files in the UserDB user database to allow for 10 percent free space in the database.

Follow link http://msdn.microsoft.com/en-us/library/ms190488(v=sql.90).aspx

Regards,
Sunil

Cnagasa, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: satender2008-12857 on: 12/9/2011 [Member] Starter | Points: 25

0	Sir, You are great !!!!!! I want to be your student Regards, Satender Cnagasa, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Sksingh on: 12/9/2011 [Member] Starter | Points: 25

0	Thanks Satender.. Most welcome... Regards, Sunil Cnagasa, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts