Thursday, September 10, 2009

Shrink the DataBase

Try the following code through your Query Analyser to shrink the database.

backup log with truncate_only
use database_name
dbcc SHRINKFILE (database_name_Log,2)
dbcc ShrinkDatabase (database_name, 2)

No comments:

Post a Comment