I always forget how to dump a transaction log on SQL server. Here is the answer:-
BACKUP LOG {DatabaseName} WITH NO_LOG
GO
DBCC SHRINKDATABASE ({DatabaseName}, 0)
GO
DBCC SQLPERF(logspace)
GO
Wednesday, February 21, 2007
Subscribe to:
Posts (Atom)