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 |
|
NewJerseyKing
Starting Member
2 Posts |
 Posted - 2006-01-08 : 15:36:17
|
I hope someone can help.I have accidently when messing about with a SQL Server database, created a second transaction log on a different drive of the server. I thought that the second log would be empty, but it seems to have created a replication of the original transaction log (both are 7GB in size). Noting my mistake, I decided to try and delete the second transaction log. Unfortunately I received a message to say that the file was currently in use (Access violation), so I couldn't complete a delete.I am now quite worried what the second transaction log must be doing? I really want to get rid of it so that the SQL database only uses the original log. I realise that the transaction log is a crucial cog of SQL databases. In hindsight, I probably shouldn't mess around with stuff that I'm not 100% clued up on.  What can I do? help?  |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2006-01-08 : 17:15:53
|
| Dupe, see here instead:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=59951 |
 |
|
|
|
|
|
Second Transaction Log