asked
Moving SQL 2008 databases to SQL 2012
Hi, How will I go about moving databases I have on SQL Server 2008 to SQL server 2012? I know I can do backup and restore but where do i backup the file if target is a new server...for example once I backup a database how do I restore it in the target server as the pathway of the backup will be on source server?
You have some options on where the backup can be located for the restore to be successful. I usually copy the backup to the (new) destination server and restore it from there. This is usually faster due to the file already being on the Sql Server you are restoring the database and you don't have to rely on the speed of the network to perform the restore. So, in your case, you would want to change the backup location for the restore syntax to the destination server after it is copied there.
You can simply copy your database from one to another by performing steps in following blog: [
http://www.sqlserverlogexplorer.com/copy-table-one-database-another-database/][1] [1]:
http://www.sqlserverlogexplorer.com/copy-table-one-database-another-database/
19 People are following this question.
