1. backup log {Database} with truncate_only
2. backup database {Database} to disk='c:\Program files\MS SQL\...
3. use {Database}
dbcc shrinkfile ({LogFileName}, {SizeToShrinkTo})
[where Database is db that you want to shrink; {LogFileName} is your db log file name (not the Logfile names); {SizeToShrinkTo} can be any size you want 100
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment