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 |
|
mitul_z
Starting Member
2 Posts |
 Posted - 2003-12-27 : 07:09:58
|
| Hi:How can I delete Transaction logs for a particular Database in MS SQL Server 2000. Please help me on this.RegardsM Z |
|
|
Nazim
A custom title
1408 Posts |
Posted - 2003-12-27 : 07:23:42
|
| why do you want to do this??? .still, herez the command.dump transaction databasename with no_log-------------------------What lies behind you and what lies ahead of you are small matters compared to what lies within you.-Ralph Waldo Emerson |
 |
|
|
mitul_z
Starting Member
2 Posts |
Posted - 2003-12-28 : 08:30:58
|
| Thanks for your prompt reply,I wanted to delete this logs to free up the space from the harddisk as it is occupying a lot of them. Please let me know if this the safest way to do it...like this will not corrupt the existing SQL data. Thanks for your replyRegardsM Z |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2003-12-28 : 09:59:28
|
| Look at shrinking them. Don't delete them.Think about it this way, if your bank rang you up and told you that you had $x in your account, but they deleted all the transactions that you had made. And you just had to take their word for it, how would you feel ?That is how your database will feel if you delete it's logs.Damian |
|
|
|
|
|
|
Delete Transaction Logs