Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-10-02 : 07:48:10
|
| Luba writes "The transaction log in one of the databases has maxed out the hard drive space. It is currently 45Gb, and nothing else will run on the server. How can I truncate, shrink or delete this log?Thanx." |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-10-02 : 08:22:28
|
| Don't allow things to grow to fill a disk - put a max size on them and monitor the situation.Normally just detach the database delete the log file then attach single file (sp_dettach_db, sp_attach_single_file_db) - but you won't be able to do that unless you can recover the database.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-10-02 : 08:41:06
|
| INF: Shrinking the Transaction Log in SQL Server 2000 with DBCC SHRINKFILE[url]http://support.microsoft.com/default.aspx?scid=kb;en-us;Q272318[/url]INF: How to Shrink the SQL Server 7.0 Transaction Log[url]http://support.microsoft.com/default.aspx?scid=kb;en-us;Q256650[/url]INF: Causes of SQL Transaction Log Filling Up[url]http://support.microsoft.com/default.aspx?scid=kb;en-us;Q110139[/url]INFO: Reasons Why SQL Transaction Log Is Not Being Truncated[url]http://support.microsoft.com/default.aspx?scid=kb;en-us;Q62866[/url]HTHJasper Smith |
|
|
|
|
|
|
truncating transaction log