My blog about green energy, offshore wind farms, C, C++, C#, web, programming, electronics, Raspberry Pi/Pico, 3D printing, networking, structured cabling and any other nonsense I fancy writing down.
Wednesday, February 21, 2007
SQL 2005 Dump Transaction Log
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
No comments:
Post a Comment