To shrink the file size I use the following script:
Use DBName
Go
exec sp_dboption DBName, ‘trunc. log on chkpt.’, true
checkpoint
DBCC SHRINKFILE (N’DBNameFileName, 0);
exec sp_dboption DBName, ‘trunc. log on chkpt.’, false
To shrink the file size I use the following script:
Use DBName
Go
exec sp_dboption DBName, ‘trunc. log on chkpt.’, true
checkpoint
DBCC SHRINKFILE (N’DBNameFileName, 0);
exec sp_dboption DBName, ‘trunc. log on chkpt.’, false
No one has commented yet.
No trackbacks yet.