Polyserve & moving System SQL 2005 databases

[Lisa Paxton]

Hi,

DOes anyoe knwo what the process is to move SQL 2005 System database in an HP Polyserve environment. In a normal SQL environment without Polyserve is very straight forward but I am having realy problems with Polyserve. Any help would be appreciated, documentation etc

Thanks
Lisa

[Robert_Walton]

Lisa,

Is the instance/database already in Polyserve?
If not then use MXMIGRATE to move an instance and database into the Matrix.
If it is then you may have to disable the current Vitual instance and recreate one with a different virtual data root. If none of these answers address your problem then let me know.

[Tammy Lawson]

Below are the steps/scripts I follow. I commented out specific manual steps you may need to complete in order. Please change the paths to your database location paths.

**NOTE - the SQL Configuration Manager doesn't always stop/start services correctly. I have found that just stopping/starting the services via Control Panel or via the Management Studio is best.

[Dan Tyndale]

SQL Move

Moving System Databases
http://msdn.microsoft.com/en-us/library/ms345408.aspx

Microsoft SQL Server 2005 - Moving the Model Database Using Detach and Attach
http://support.microsoft.com/kb/224071

You put the files in the shared location in 3.6 and revirtualize it should work
The problem there is if you have replication, log shipping, mirroring.
Those services have to be removed or the server will not revirtualize because it cannot change the @@servername