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
Subscribe to:
Post Comments (Atom)
skip to main |
skip to sidebar
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.
About Me
- Andrew Jones
- My technical blog about programming, networking and who knows what else.
No comments:
Post a Comment