Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
TRansaction Logs
- Thread starter Gagsy
- Start date
Backup the Transaction Logs. That's the best way.
That will cause the logs to shrink (not immediately though). If you must shrink them immediately, run DBCC SHRINKFILE. Or BACKUP LOG dbname WITH TRUNCATE_ONLY. Warning: TRUNCATE_ONLY gets rid of the log data and you can not restore the log. You must immediately do a full backup after that command.
-SQLBill
BOL=Books OnLine=Microsoft SQL Server's HELP
Installed as part of the Client Tools
Found at Start>Programs>Microsoft SQL Server>Books OnLine
Posting advice: FAQ481-4875
That will cause the logs to shrink (not immediately though). If you must shrink them immediately, run DBCC SHRINKFILE. Or BACKUP LOG dbname WITH TRUNCATE_ONLY. Warning: TRUNCATE_ONLY gets rid of the log data and you can not restore the log. You must immediately do a full backup after that command.
-SQLBill
BOL=Books OnLine=Microsoft SQL Server's HELP
Installed as part of the Client Tools
Found at Start>Programs>Microsoft SQL Server>Books OnLine
Posting advice: FAQ481-4875
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question