Solved

use .bak to move database to another server

Posted on 2013-11-02
3
341 Views
Last Modified: 2013-11-02
I used to do this a lot and for some reason it is not working this time.

I have sql server 2012 and I am trying to migrate a database to another machine not on my network.  In previous version, I would have simply backed up the database and restored it on the new instance of sql.  This does not seem to be working.  What is the easiest way to complete this transaction?

Thanks,
0
Comment
Question by:gwarcher
  • 2
3 Comments
 
LVL 4

Accepted Solution

by:
ShareD_Point earned 500 total points
ID: 39619243
Hi,

1. Move the backup file to a folder (say C:\SQLBackup) of the remote Machine
2. Use the below statement to restore the database
   
      RESTORE DATABASE YourDBName FROM DISK = N'C:\SQLBackup\Demo.bak';

Even after following this approach, if the issue still persists, let us know what is the error you are getting.

Hope this helps
0
 

Author Comment

by:gwarcher
ID: 39619317
the error reads 'the backup set holds a backup of a database other than the existing 'dbase name' database.

If I delete the empty database of the same name it throws multiple errors.
0
 

Author Closing Comment

by:gwarcher
ID: 39619450
worked as a text query, but not using the wizard.
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
I have a large data set and a SSIS package. How can I load this file in multi threading?
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question