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 |
|
bmacampos
Starting Member
2 Posts |
 Posted - 2007-08-09 : 07:33:43
|
| Hi All,I have on production database, that have two Transation Logs, one of them have 120Gb of size. Do you know if is possible to delete one log file and reduce the size to the other?I'm using the SQL server 2000.Thanks a lot, RegardsBruno Campos |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-08-09 : 07:55:25
|
| Have a look at shrink in enterprise manager.==========================================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. |
 |
|
|
bmacampos
Starting Member
2 Posts |
Posted - 2007-08-09 : 09:33:20
|
| Yes but did not work.Is not possible to delete a Transation Log File?What are the standard procedures delete it?Thanks a lot |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-09 : 23:29:09
|
| You can't delete it, do log backup then shrink it. You should backup log periodically if the db is not in simple recovery mode. |
|
|
|
nr
SQLTeam MVY
12543 Posts |
|
|
|
|
|
Transation Log growing unexpectedly