how to reduce the DataBase bak file

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

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

Regard's
Sudarshan.C

sudarshan.c


Responses

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

Up
0
Down
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

Up
0
Down
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

Up
0
Down
Thanks Satender..
Most welcome...

Regards,
Sunil

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

Login to post response