Switch to new server, create database, and right click on Database, select restore database, select from device and choose file.
Next click on Options and select Overwrite the existing database (WITH REPLACE) -- you are done!
Tuesday, March 18, 2014
Quick Backup & Restore of SQL Database to New Server
Open SQL Server Management Server on old server, right click on task, choose backup, select full, choose Destination "Disk", add, name file.
Switch to new server, create database, and right click on Database, select restore database, select from device and choose file.
Next click on Options and select Overwrite the existing database (WITH REPLACE) -- you are done!
Switch to new server, create database, and right click on Database, select restore database, select from device and choose file.
Next click on Options and select Overwrite the existing database (WITH REPLACE) -- you are done!
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment