|
|
posted on March 06, 2010 06:17
Script to shrink the DNN log file.
use inetDNN_DATABASENAME
GO
BACKUP LOG inetDNN_DATABASENAME WITH TRUNCATE_ONLY
GO
DBCC SHRINKFILE (inetDNN_DATABASENAME_log, 1)
GO
DBCC SHRINKFILE (inetDNN_DATABASENAME, 1)
GO
exec sp_helpfile
There are currently no comments, be the first to post one!