April 9, 2010 at 10:01 am
I saw the statement in link below on the importance of keeping file layout in principal and mirror servers the same; are there any other considerations for keeping layout the same and under what circumstances is statement below an issue?
http://searchsqlserver.techtarget.com/tip/Database-mirroring-factors-to-consider-before-setup
The disk layout should be the same. If you do an alter database statement to add a file to a filegroup and this file path refers to a non-existent path of the mirror, the mirror will fail.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
April 13, 2010 at 4:39 am
hi,
it's also nice to have the datafiles on the same place when you have to do a restore 😉
you know what i mean if you setup your mirror database the first time 🙂
April 15, 2010 at 1:56 pm
I personally have never had any trouble with different file layouts between the principal and mirrored server, but if you are adding an additional data or log file it would break the mirror if the same file layout was not there on both the principal and mirrored server. If you are not going to be adding additional files I don't see a problem having different file layouts.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply