USE [Customer]
GO
SELECT *
FROM sysfiles
WHERE name LIKE '%LOG%'
GO
DBCC SHRINKFILE (Customer_Log, 1)
GO
BACKUP LOG Customer WITH NO_LOG
GO
DBCC SHRINKFILE (Customer_Log, 1)
GO
BACKUP LOG Customer WITH TRUNCATE_ONLY
go
DBCC SHRINKFILE (Customer_Log, 1)
GO
Monday, September 20, 2010
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment