|
|
|
|
|
Syntax for Shrinking SQL Server database mdf and log file |
|
Posted by
Moderator1
on
12/26/2007 8:26:24 AM |
630
Views |
|
|
|
|
|
|
|
Try the following code through your Query Analyser to shrink the database.
backup log <database_name> with truncate_only
use <database_name>
dbcc SHRINKFILE (<database_name_Log>,2)
dbcc ShrinkDatabase (<database_name>, 2)
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|