restore db to different machine

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

QuyNguyen - 05 Jun 2009 00:21 GMT

Hi,
I have a question. How to move data basefrom one PCto another PC. I tried
to backup database the from machine1. then copy to local drive of machine 2
then restore it to machine 2. It fails. It fails. why?
Thank you for your help.

Reply to this Message

Andrea Montanari - 05 Jun 2009 10:48 GMT

hi,

> Hi,
> I have a question. How to move data basefrom one PCto another PC. I
> tried to backup database the from machine1. then copy to local drive
> of machine 2 then restore it to machine 2. It fails. It fails. why?
> Thank you for your help.

what is the exception(s) you are reported with?
as long as the size of the database to be restored is not superior to 2gb
you should be able to perform the task..
after that, you have to probably fix the ownership of the database to a
valid local login and fix orphaned database users belonging to standard SQL
Server logins using sp_change_users_login system stored procedure..
regards

Signature

Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz
DbaMgr2k ver 0.21.1 - DbaMgr ver 0.65.1 and further SQL Tools
http://www.hotelsole.com - http://www.hotelsolericcione.de
--------- remove DMO to reply

Reply to this Message

Richard Mueller [MVP] - 08 Jun 2009 00:55 GMT

> Hi,
> I have a question. How to move data basefrom one PCto another PC. I tried
> to backup database the from machine1. then copy to local drive of machine
> 2 then restore it to machine 2. It fails. It fails. why?
> Thank you for your help.

I do this all the time with no problems. Do you get an error message?

Signature

Richard Mueller
MVP Directory Services
Hilltop Lab - http://www.rlmueller.net
--

Reply to this Message