Select size of database files before
shrink
|
SELECT Name
AS Logical_Name,(size*8)/1024
SizeMB
FROM
sys.master_files
WHERE
DB_NAME(database_id)
= 'MyDB'
GO |
Truncate the log by changing the database recovery model to SIMPLE.
|
ALTER
DATABASE MyDB
SET
RECOVERY SIMPLE
WITH NO_WAIT;
GO |
Shrink the truncated log file to 1 MB.
|
DBCC
SHRINKFILE(MyDB_log,
1);
GO |
Reset the database recovery model.
|
ALTER
DATABASE MyDB
SET
RECOVERY FULL
WITH NO_WAIT;
GO |
Select size of database files After shrink
|
SELECT Name
AS Logical_Name,
(size*8)/1024
SizeMB FROM
sys.master_files
WHERE
DB_NAME(database_id)
= 'MyDB'
GO |