by Behlul
31. March 2010 10:22
USE [master]
GO
ALTER DATABASE [Visitor] MODIFY FILE ( NAME = N'Visitor_log', MAXSIZE = UNLIMITED)
GO
by Behlul
31. March 2010 10:09
USE VisitorLog
GO
DBCC SHRINKFILE('VisitorLog_log', 1)
BACKUP LOG VisitorLog WITH TRUNCATE_ONLY
DBCC SHRINKFILE('VisitorLog_log', 1)
GO
DBCC SHRINKDATABASE (VisitorLog, 0);
Subscribe