Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Peter99
Constraint Violating Yak Guru
498 Posts |
 Posted - 2012-08-14 : 11:38:05
|
| Hi,I am moving sql server instance from cluster to vm. I already installed sql server, restored user databases, moved logins, jobs etc. I have one question for cutover. I will take last transactin log backup of the databases and restore on vm. After that I have two options:1. stop sql server instance (services) on clusteror2. take resource group (cluster admin) offline.Then test application with new server and leave it there. Original instance on cluster should not be available. What is best approach or any other suggestion used during cutover?Thanks |
|
|
komkrit
Yak Posting Veteran
60 Posts |
Posted - 2012-08-14 : 13:40:15
|
| Set single user mode to prevent connection from application.Then back up tail of transaction log to restore on new server.The last, offline cluster group to prevent failover between node.Do not forget to move another object such as SSIS Package, Maintenance Plan, Full-Text catalog, aware using of replication, mirror, the setting should be also moved.Symmetric Key and Certificate should be considered to backup if used.- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -Komkrit YensirikulCurrently be a DBA in worldwide hotel reservation. Experienced in top leading banking environment. |
 |
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2012-08-14 : 15:27:41
|
| Does anyone have experience of using cname or dns alias for sql server named instances?we want to create cname for sql server instances on cluster to vm. instance name will be same, computer name will change. Say cname from old/instance to new/instance.Thanks |
|
|
|
|
|
|
migration