resend - transfer database to a new server

Sorry, I'm sending this again because I think it must be buried under week
old posts that no one will see. If I'm wrong please let me know.
I was able to successfully back up all the databases like master, model,
msdb, northwind, etc. I was also able to backup the four databases belonging
to the application. Restoring is not going as well. I first tried to restore
master, figuring that it is required first to inform SQL of the other
databases to come. It asked my to restart SQL in some single user mode which
I did. I then restored master. Now I can't start SQL. In the old computer
the databases were on E: and in the new they are on C:. So when I try to
start I get errors like this:
2006-07-11 09:31:36.34 spid10 FCB::Open failed: Could not open device
e:\Program Files\Microsoft SQL Server\MSSQL\data\northwnd.mdf for virtual
device number (VDN) 1.
2006-07-11 09:31:36.34 spid10 Device activation error. The physical file
name 'e:\Program Files\Microsoft SQL Server\MSSQL\data\northwnd.mdf' may be
incorrect.
2006-07-11 09:31:36.34 spid8 Starting up database 'syntrg'.
2006-07-11 09:31:36.34 spid10 Device activation error. The physical file
name 'e:\Program Files\Microsoft SQL Server\MSSQL\data\northwnd.ldf' may be
incorrect.
2006-07-11 09:31:36.34 spid8 udopen: Operating system error 3(The system
cannot find the path specified.) during the creation/opening of physical
device e:\Program Files\Microsoft SQL Server\MSSQL\data\syntrg.mdf.
2006-07-11 09:31:36.34 spid8 FCB::Open failed: Could not open device
e:\Program Files\Microsoft SQL Server\MSSQL\data\syntrg.mdf for virtual
device number (VDN) 1.
How can I recover (if I have to uninstall and reinstall I will) and what is
the correct sequence for restoring the databases?
Thanks.
"Ben Nevarez" <bnevarez@.sjm.com> wrote in message
news:B3DBFC04-0A32-4B7D-94FD-13C3B2173EB8@.microsoft.com...[vbcol=seagreen]
> Hi Bill,
> You have two easy choices:
> 1) Do a backup and restore the database on the other server
> 2) Detach the database and attach it on the other server
> On both cases you can look into the SQL Server documentation on how to
> accomplis these tasks, this is Books Online, located on Programs /
> Microsoft
> SQL Server / Books Online.
> Since you have a new server not used yet you will have enough time to test
> until you feel confortable with the procedure and test it.
> Be sure both SQL Server instalations are the same version including
> service
> packs and hotfixes.
> Finally you should apply a proper backup and restore procedure.
> Hope this helps,
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "Bill Brehm >" wrote:
>Bill
RESTORE the database WITH MOVE option (for more details please refer to the
BOL)
"Bill Brehm >" <<don't want any spam> wrote in message
news:ugDaDaXpGHA.4988@.TK2MSFTNGP04.phx.gbl...
> Sorry, I'm sending this again because I think it must be buried under week
> old posts that no one will see. If I'm wrong please let me know.
> I was able to successfully back up all the databases like master, model,
> msdb, northwind, etc. I was also able to backup the four databases
> belonging
> to the application. Restoring is not going as well. I first tried to
> restore
> master, figuring that it is required first to inform SQL of the other
> databases to come. It asked my to restart SQL in some single user mode
> which
> I did. I then restored master. Now I can't start SQL. In the old computer
> the databases were on E: and in the new they are on C:. So when I try to
> start I get errors like this:
> 2006-07-11 09:31:36.34 spid10 FCB::Open failed: Could not open device
> e:\Program Files\Microsoft SQL Server\MSSQL\data\northwnd.mdf for virtual
> device number (VDN) 1.
> 2006-07-11 09:31:36.34 spid10 Device activation error. The physical
> file
> name 'e:\Program Files\Microsoft SQL Server\MSSQL\data\northwnd.mdf' may
> be
> incorrect.
> 2006-07-11 09:31:36.34 spid8 Starting up database 'syntrg'.
> 2006-07-11 09:31:36.34 spid10 Device activation error. The physical
> file
> name 'e:\Program Files\Microsoft SQL Server\MSSQL\data\northwnd.ldf' may
> be
> incorrect.
> 2006-07-11 09:31:36.34 spid8 udopen: Operating system error 3(The
> system
> cannot find the path specified.) during the creation/opening of physical
> device e:\Program Files\Microsoft SQL Server\MSSQL\data\syntrg.mdf.
> 2006-07-11 09:31:36.34 spid8 FCB::Open failed: Could not open device
> e:\Program Files\Microsoft SQL Server\MSSQL\data\syntrg.mdf for virtual
> device number (VDN) 1.
> How can I recover (if I have to uninstall and reinstall I will) and what
> is
> the correct sequence for restoring the databases?
> Thanks.
>
> "Ben Nevarez" <bnevarez@.sjm.com> wrote in message
> news:B3DBFC04-0A32-4B7D-94FD-13C3B2173EB8@.microsoft.com...
>
>|||Bill Brehm < wrote:
> Sorry, I'm sending this again because I think it must be buried under week
> old posts that no one will see. If I'm wrong please let me know.
> I was able to successfully back up all the databases like master, model,
> msdb, northwind, etc. I was also able to backup the four databases belongi
ng
> to the application. Restoring is not going as well. I first tried to resto
re
> master, figuring that it is required first to inform SQL of the other
> databases to come. It asked my to restart SQL in some single user mode whi
ch
> I did. I then restored master. Now I can't start SQL. In the old computer
> the databases were on E: and in the new they are on C:. So when I try to
> start I get errors like this:
> 2006-07-11 09:31:36.34 spid10 FCB::Open failed: Could not open device
> e:\Program Files\Microsoft SQL Server\MSSQL\data\northwnd.mdf for virtual
> device number (VDN) 1.
> 2006-07-11 09:31:36.34 spid10 Device activation error. The physical fil
e
> name 'e:\Program Files\Microsoft SQL Server\MSSQL\data\northwnd.mdf' may b
e
> incorrect.
> 2006-07-11 09:31:36.34 spid8 Starting up database 'syntrg'.
> 2006-07-11 09:31:36.34 spid10 Device activation error. The physical fil
e
> name 'e:\Program Files\Microsoft SQL Server\MSSQL\data\northwnd.ldf' may b
e
> incorrect.
> 2006-07-11 09:31:36.34 spid8 udopen: Operating system error 3(The syst
em
> cannot find the path specified.) during the creation/opening of physical
> device e:\Program Files\Microsoft SQL Server\MSSQL\data\syntrg.mdf.
> 2006-07-11 09:31:36.34 spid8 FCB::Open failed: Could not open device
> e:\Program Files\Microsoft SQL Server\MSSQL\data\syntrg.mdf for virtual
> device number (VDN) 1.
> How can I recover (if I have to uninstall and reinstall I will) and what i
s
> the correct sequence for restoring the databases?
> Thanks.
>
> "Ben Nevarez" <bnevarez@.sjm.com> wrote in message
> news:B3DBFC04-0A32-4B7D-94FD-13C3B2173EB8@.microsoft.com...
>
>
>
Hi
Take a look at this article -
http://support.microsoft.com/defaul...kb;en-us;224071
This might help get up and running again.
Additionally you should look at this link which tells you how to move
the databases - http://support.microsoft.com/kb/314546/en-us
Regards
Steen Schlter Persson
Databaseadministrator / Systemadministrator|||Bill
Here are a few more articles that might help.
http://support.microsoft.com/?id=221465 Using WITH MOVE in a Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission Issues
When a Database Is Moved Between SQL Servers
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles for
SQL Server
Regards
John
"Steen Persson (DK)" wrote:

> Bill Brehm < wrote:
> Hi
> Take a look at this article -
> http://support.microsoft.com/defaul...kb;en-us;224071
> This might help get up and running again.
> Additionally you should look at this link which tells you how to move
> the databases - http://support.microsoft.com/kb/314546/en-us
>
> --
> Regards
> Steen Schlüter Persson
> Databaseadministrator / Systemadministrator
>