This was quick (but very dirty):
- Set Recovery mode to "Simple" in DB Properties > Options.
- Ran a CHECKPOINT command in Query Analyser
- Ran a DBCC SHRINKDATABASE(
) command in Query Analyser
21 Nov 2005
Physically Shrinking An SQL Server 2000 DB's Transaction Log File
Had a big old transaction log (LDF) file that I wanted to cut down to size after backup.
This was quick (but very dirty):
This was quick (but very dirty):
Subscribe to:
Post Comments (Atom)
If I helped you out today, you can buy me a beer below. Cheers!
No comments:
Post a Comment
Comments are very welcome but are moderated to prevent spam.