March 3, 2010 at 10:37 am
Is it possible to add a second transaction log file to a database?
If so, what is the impact for when one file grows to capacity, does the second one then start growing?
Is it possible to remove the second one at a later date?
Thanks,
John
March 3, 2010 at 11:00 am
JohnnyDBA (3/3/2010)
Is it possible to add a second transaction log file to a database?
yes, but logs are sequential write so unless you have run out of space on disk no point.
If so, what is the impact for when one file grows to capacity, does the second one then start growing?
yes.
Is it possible to remove the second one at a later date?
yes, backup the log to truncate it, run dbcc shrinkfile with emptyfile option, then run alter database remove file option. you may need to backup log more than once to empty out second log file
---------------------------------------------------------------------
March 3, 2010 at 11:05 am
Regarding deleting log file, please refer to below links.
http://technet.microsoft.com/en-us/library/ms191433(SQL.90).aspx
http://technet.microsoft.com/en-us/library/ms189253(SQL.90).aspx
http://technet.microsoft.com/en-us/library/ms175574(SQL.90).aspx
M&M
March 3, 2010 at 11:06 am
Great info, thanks guys!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply