topic Re: Polyserve & moving System SQL 2005 databases in Storage Software

Polyserve & moving System SQL 2005 databases

Lisa Paxton — Thu, 23 Jul 2009 14:22:31 GMT

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

Re: Polyserve & moving System SQL 2005 databases

Robert_Walton — Wed, 19 Aug 2009 15:05:55 GMT

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.

Re: Polyserve & moving System SQL 2005 databases

Tammy Lawson — Mon, 19 Oct 2009 13:09:33 GMT

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.

Re: Polyserve & moving System SQL 2005 databases

Dan Tyndale — Tue, 20 Oct 2009 16:04:34 GMT

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