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 - 2003-06-18 : 07:38:31
|
| Mel writes "Hi! I'm a new database administrator using SQL server 7.0 running on a Windows NT 4 server. I have a problem concerning two transaction log files, which I cannot remove or at least shrink. They already grew to 4 GB and I'm running out of disk space. I tried to look at the Microsoft knowledge base article #Q256650 as referenced in one of your articles but it's just too complicated for me. Is there an easier way? Please help me." |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-06-18 : 11:56:19
|
| Backup the database firstSet the recovery model to simple then try to shrink.If that still fails use sp_detach, delete the log file then sp_attach or sp_attach_single_file.This will create a new log.==========================================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. |
 |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2003-06-19 : 00:16:36
|
| The article referenced is not complicated. Just copy the TSQL code from the article, change the lines it tells you to change (With your DB Name etc..) and run it.It is very simple. Nigel, there are no recovery models in 7.0. Also, I wouldn't suggest deleting the log file (Particularlty to a novice). It can only lead to trouble.-Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-06-19 : 04:21:09
|
| For 7.0, there is truncate log on checkpoint option which is similar to SIMPLE recovery model. This option should be selected if you don't care about the ability to restore to a point in time.Tara |
|
|
|
|
|
|
Removing multiple transaction logs