October 5, 2012 at 8:02 am
Can we add secondary datafile with out restoring the log backup with move cmd to the secondary server?
If yes , how ?
October 5, 2012 at 8:33 am
For an add file to be seamless you need to ensure the paths on both instances match
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 5, 2012 at 8:59 am
ramyours2003 (10/5/2012)
Can we add secondary datafile with out restoring the log backup with move cmd to the secondary server?If yes , how ?
No.
Perry Whittle (10/5/2012)
For an add file to be seamless you need to ensure the paths on both instances match
That's correct if you want minimal overhead but you can manually move files if you have different drives.
When used with RESTORE LOG, the MOVE option can be used only to relocate files that were added during the interval covered by the log being restored. For example, if the log backup contains an add file operation for file file23, this file may be relocated using the MOVE option on RESTORE LOG.
October 5, 2012 at 9:30 am
MysteryJimbo (10/5/2012)
That's correct if you want minimal overhead but you can manually move files if you have different drives.
Yes, but if you read the post the user wants to know how without using the move command 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply