August 20, 2012 at 9:24 am
If I want to added second transaction log to a mirrored database (doing it from Principle side).
Do I have to:
1. First break the mirror
2. Add 2nd Transaction Log somewhere (another drive like I:\ or etc)
3. Rebuild the mirror
Thanks!
August 20, 2012 at 9:42 am
Add it to the principal and ensure that the file path exists on the mirror.
Why are you adding a second log file?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 20, 2012 at 11:38 am
GilaMonster (8/20/2012)
Add it to the principal and ensure that the file path exists on the mirror.Why are you adding a second log file?
For training (curiosity) reasons on my VM.
August 20, 2012 at 11:40 am
both instances on the same VM?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 20, 2012 at 1:29 pm
Perry Whittle (8/20/2012)
both instances on the same VM?
No two vms sorry.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply