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.