October 6, 2005 at 2:50 am
I have always worked in a stand-alone environment and have used the methods of moving the system databases described on this site to keep a separation between the system databases, database log files and user databases.
I believe the process for moving these databases in a clustered environment is considerably different but I don't know how. Can anyone shed some light on this?
October 6, 2005 at 1:03 pm
I work in a active/passive environment with stand-alone warm backups/logshipping.
I haven't done anything different between each environment.
Fortunately both environments share the exact same partition setup.
i've transfered master between both...moved physical files with no problems.
October 7, 2005 at 4:24 am
It would depend on the initial configuration. At some point i read a recommendation for sql clustering which stated you should put the system databases on a local disk of each node.
If you really did that, you would have to backup the system databases, switch nodes, and restore them on each signficant change - which is crap.
If you put the system databases on disks shared by all nodes like the user databases you can treat them as if it was a single server...
Of course if you change the path to master or tempdb you will have to set the path in the registry of the passive node too for it to be able to start sql server...
karl
Best regards
karl
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply