Moving Database from VM to Physical server

Question

Moving Database from VM to Physical server

dcph

Valued Member

Points: 56
More actions
July 7, 2017 at 10:10 am

#343454

What is the best way to move a database form a VM to a physical server.
1) Backup existing database on old server, copy backup files to new server, then restore database on new server.or
2) Use the "Copy Database Wizard"? https://docs.microsoft.com/en-us/sql/relational-databases/databases/use-the-copy-database-wizard
After we finish, we want to shut down the old SQL server VM and configure the new physical server with the same name and ip address as the old SQL server VM. Are there any issues associated with doing this?
Thanks for responses in advance.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

ryanbesko Ten Centuries Points: 1364 More actions · Answer 1

dcph - Friday, July 7, 2017 10:10 AM
What is the best way to move a database form a VM to a physical server.
1) Backup existing database on old server, copy backup files to new server, then restore database on new server.or
2) Use the "Copy Database Wizard"? https://docs.microsoft.com/en-us/sql/relational-databases/databases/use-the-copy-database-wizard
After we finish, we want to shut down the old SQL server VM and configure the new physical server with the same name and ip address as the old SQL server VM. Are there any issues associated with doing this?
Thanks for responses in advance.

Another option is to detach the database on the old instance, move the data and log files to a drive the new instance server process has rights to, and re-attach on the new instance.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 2

dcph - Friday, July 7, 2017 10:10 AM
What is the best way to move a database form a VM to a physical server.
1) Backup existing database on old server, copy backup files to new server, then restore database on new server.

Yes.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Perry Whittle SSC Guru Points: 234013 More actions · Answer 3

dcph - Friday, July 7, 2017 10:10 AM
What is the best way to move a database form a VM to a physical server.
1) Backup existing database on old server, copy backup files to new server, then restore database on new server.or
2) Use the "Copy Database Wizard"? https://docs.microsoft.com/en-us/sql/relational-databases/databases/use-the-copy-database-wizard
After we finish, we want to shut down the old SQL server VM and configure the new physical server with the same name and ip address as the old SQL server VM. Are there any issues associated with doing this?
Thanks for responses in advance.

Either backup the database, copy the backup file(s), then restore or take the database offline, copy the physical database files, then attach on the new server.
Depending on the size of the database the latter can be quicker, the restore allows you to leave the database in a recovering state to apply further backups.
You'll need to test and decide what it is you require

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

dcph Valued Member Points: 56 More actions · Answer 4

Thank you everyone for your replies. I believe we will be using the backup and restore method.