January 24, 2014 at 8:07 am
HI,
I have to migrate 15 MSSql server 2008 R2 database residing on VM to Physical machine of same version of SQL Server..
I have prepared a procedre..
1. Backup of both system and User defined databases.
2. Backup of logins by executing a script.
3. restore/attach to physical machine, the one detached database(system+user) from VM.
4. Execute the login query(Script) on physical VM
If I detach and attach triggers and procedures will all exist.
Can you please explain me if any steps are missing..
Thanks
Praneeth
January 24, 2014 at 9:07 am
why are you backing up the system databases?
will the disk drives\paths be the same between the machines?
Will the new server have the same name and IP address, will the SQL Server service on the VM use the same account as the SQL Server service on the new server?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 24, 2014 at 9:13 am
Ip is different and running on same service account
January 24, 2014 at 9:19 am
Perry Whittle (1/24/2014)
why are you backing up the system databases?will the disk drives\paths be the same between the machines?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply