Viewing 3 posts - 1 through 3 (of 3 total)
quote:I Have use dbcc shrinkfile command on this mant times with no success. What else can I do?
quote:
August 22, 2003 at 3:05 am #470940
August 22, 2003 at 3:05 am
#470940
To shrink a log file,
you should call sp_dboption
before using DBCC shrinkfile
(see the script below)
It's usually enough.
/*
shrink a log file
WARNING: change the database name and the logical name of the log...
August 20, 2003 at 5:13 am
#470558
Hi !
WARNING: change the database name and the logical name of the log file.
database: MyDB
log file: MyDB_Log
*/
USE master
go
EXEC sp_dboption 'MyDB', 'trunc. log on chkpt.', 'TRUE'
USE MyDB
DBCC...
June 19, 2003 at 5:46 am
#462080