Unsolved
This post is more than 5 years old
2 Posts
0
559
September 20th, 2007 12:00
SQL Server master database
Hello,
we are running EMC Autostart with MS SQL server in the "passive / active" mode. We installed our user database on the mirrored drive. Do anybody know, if the system databases, especially master.mdf must be installed on the mirrored drive, too?
Thanks in advance.
we are running EMC Autostart with MS SQL server in the "passive / active" mode. We installed our user database on the mirrored drive. Do anybody know, if the system databases, especially master.mdf must be installed on the mirrored drive, too?
Thanks in advance.
0 events found
No Events found!


Ryan9
45 Posts
1
September 20th, 2007 12:00
In the Master DB there are references to the server name but because of the script mentioned above, they do not need to be changed.
The reason I say to put the master on the mirrored drive is so you don't have to manage the database on each server. Say you add a SQL user account to serverA and the master is NOT being mirrored. If you wanted serverB to have the same users and settings as serverA you would then have to MANUALLY make those changes to serverB as well.
So when I do SQL module installs here is what I typically do:
Install SQL to non-mirrored drive
Put all DB's on mirrored drive
Make sure all drive letters are the same for all parts of the SQL install.
FYI, I've done dozens of these over the past 3 years without issue.
That being said, if you want to leave the master on a non-mirrored drive you can do that as well. You can then simply attach the application databases on the target and things should still work. However, any changes to the local SQL installation that will affect Master must be done on both sides.
Does that help?
kovac1
2 Posts
0
September 20th, 2007 14:00
If so i think there i have no choice - Master must be replicated.