Re: Question about recovery log

2004-03-26 Thread Roger Deschner
. Thanks! -Original Message- From: Prather, Wanda [mailto:[EMAIL PROTECTED] Sent: Thursday, March 25, 2004 3:01 PM To: [EMAIL PROTECTED] Subject: Re: Question about recovery log I believe you are correct. But why do you have a requirement to have only 1 log file? The log is written

Re: Question about recovery log

2004-03-26 Thread Miller, Ryan
PROTECTED] Subject: Re: Question about recovery log 1. Never make it larger than 12GB! Someday, your log will fill up, and you've got to have room under the 13gb limit to be able to add an emergency extent, otherwise you'll find yourself dug in so deep you can't dig out. 2. You will find

Question about recovery log

2004-03-25 Thread Thach, Kevin G
I'm confused about how I should go about changing the configuration of my recovery log. I'm hoping someone can point me in the right direction. I currently have eight, 1GB log volumes, and I'm wanting to replace these with a single 13GB volume. Normally, I would just create and define the new

Re: Question about recovery log

2004-03-25 Thread Davidson, Becky
Define the new and add it and then delete the old. Don't forget to mirror. -Original Message- From: Thach, Kevin G [mailto:[EMAIL PROTECTED] Sent: Thursday, March 25, 2004 1:42 PM To: [EMAIL PROTECTED] Subject: Question about recovery log I'm confused about how I should go about

Re: Question about recovery log

2004-03-25 Thread Thach, Kevin G
: Thursday, March 25, 2004 2:50 PM To: [EMAIL PROTECTED] Subject: Re: Question about recovery log Define the new and add it and then delete the old. Don't forget to mirror. -Original Message- From: Thach, Kevin G [mailto:[EMAIL PROTECTED] Sent: Thursday, March 25, 2004 1:42 PM To: [EMAIL PROTECTED

Re: Question about recovery log

2004-03-25 Thread Prather, Wanda
, March 25, 2004 2:57 PM To: [EMAIL PROTECTED] Subject: Re: Question about recovery log That's what I do with my DB, but by defining the new log volume and adding it, I will be over the 13GB limit until I've removed all the old volumes. Will TSM let me do that? I guess I could try it and see

Re: Question about recovery log

2004-03-25 Thread Thach, Kevin G
To: [EMAIL PROTECTED] Subject: Re: Question about recovery log I believe you are correct. But why do you have a requirement to have only 1 log file? The log is written sequentially, so I don't see that it would hurt you to have two 6.5 GB logs, instead of one 13GB log... -Original Message