Transaction Log

Question

Post reply

Transaction Log

Garutyunyan

SSCrazy

Points: 2629
More actions
August 30, 2002 at 9:53 am

#158940

Hi, I have the main transaction log file on a disk that's running low on space, so what I did was create a second log file on a new drive. I restricted file growth on the original log file. When the original log file reaches its limit, does the second transaction log pick up after that?
I've worked with multiple data files, but never in an environment where I had more than one log file, and I'm kind of iffy about it. Can someone assure me that I'm on the right track, and if not, what are the disadvantages to having more than one log file.
Thanks in advance

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Garutyunyan SSCrazy Points: 2629 More actions · Answer 1

That's what I think too, but I wanted to make sure. Let's see what the experts say about this topic.

Thanks

Garutyunyan SSCrazy Points: 2629 More actions · Answer 2

By the way, I took out the second log file. Instead, I'm going to detach the database, copy the file(s) to the hard disk with more room, then attach it. That's what we've decided here...