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...
>
> 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:
>
>> I don't know anything about SQL server.
>>
>> We have one old PC running Windows NT and SQL server. I think it's a
>> standard edition. It is serving an accounting application. I want to move
>> to
>> a newer server before the old one goes bad (as it's already starting to
>> do).
>> The new server runs Windows 2000 Server. I have already installed SQL
>> server
>> (enterprise edition) on the new server.
>>
>> So how do I go about moving the database over? I have browsed the
>> newsgroup
>> here and seen articles about backing up and restoring. But I don't even
>> know
>> how to do a proper backup and the articles don't say. (In the past I have
>> been backing up by stopping the SQL server and backing up the entire
>> directory including the database files. I figured that was a reasonably
>> safe
>> way to backup even though I would have no idea yet how to restore from
>> that.)
>>
>> I will be able to kick everyone off the system and stop the SQL server if
>> necessary. If fact if it makes the task quicker and easier I would prefer
>> that.
>>
>> Thanks...
>>
>>
>>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...
>> 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:
>> I don't know anything about SQL server.
>> We have one old PC running Windows NT and SQL server. I think it's a
>> standard edition. It is serving an accounting application. I want to
>> move
>> to
>> a newer server before the old one goes bad (as it's already starting to
>> do).
>> The new server runs Windows 2000 Server. I have already installed SQL
>> server
>> (enterprise edition) on the new server.
>> So how do I go about moving the database over? I have browsed the
>> newsgroup
>> here and seen articles about backing up and restoring. But I don't even
>> know
>> how to do a proper backup and the articles don't say. (In the past I
>> have
>> been backing up by stopping the SQL server and backing up the entire
>> directory including the database files. I figured that was a reasonably
>> safe
>> way to backup even though I would have no idea yet how to restore from
>> that.)
>> I will be able to kick everyone off the system and stop the SQL server
>> if
>> necessary. If fact if it makes the task quicker and easier I would
>> prefer
>> that.
>> Thanks...
>>
>
>|||This is a multi-part message in MIME format.
--080404050103090909090207
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
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 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...
>> 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:
>>
>> I don't know anything about SQL server.
>> We have one old PC running Windows NT and SQL server. I think it's a
>> standard edition. It is serving an accounting application. I want to move
>> to
>> a newer server before the old one goes bad (as it's already starting to
>> do).
>> The new server runs Windows 2000 Server. I have already installed SQL
>> server
>> (enterprise edition) on the new server.
>> So how do I go about moving the database over? I have browsed the
>> newsgroup
>> here and seen articles about backing up and restoring. But I don't even
>> know
>> how to do a proper backup and the articles don't say. (In the past I have
>> been backing up by stopping the SQL server and backing up the entire
>> directory including the database files. I figured that was a reasonably
>> safe
>> way to backup even though I would have no idea yet how to restore from
>> that.)
>> I will be able to kick everyone off the system and stop the SQL server if
>> necessary. If fact if it makes the task quicker and easier I would prefer
>> that.
>> Thanks...
>>
>>
>
>
Hi
Take a look at this article -
http://support.microsoft.com/default.aspx?scid=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
--080404050103090909090207
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Bill Brehm < wrote:
<blockquote cite="midugDaDaXpGHA.4988@.TK2MSFTNGP04.phx.gbl" type="cite">
<pre wrap="">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" <a class="moz-txt-link-rfc2396E" href="http://links.10026.com/?link=mailto:bnevarez@.sjm.com"><bnevarez@.sjm.com></a> wrote in message
<a class="moz-txt-link-freetext" href="http://links.10026.com/?link=news:B3DBFC04-0A32-4B7D-94FD-13C3B2173EB8@.microsoft.com">news:B3DBFC04-0A32-4B7D-94FD-13C3B2173EB8@.microsoft.com</a>...
</pre>
<blockquote type="cite">
<pre wrap="">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:
</pre>
<blockquote type="cite">
<pre wrap="">I don't know anything about SQL server.
We have one old PC running Windows NT and SQL server. I think it's a
standard edition. It is serving an accounting application. I want to move
to
a newer server before the old one goes bad (as it's already starting to
do).
The new server runs Windows 2000 Server. I have already installed SQL
server
(enterprise edition) on the new server.
So how do I go about moving the database over? I have browsed the
newsgroup
here and seen articles about backing up and restoring. But I don't even
know
how to do a proper backup and the articles don't say. (In the past I have
been backing up by stopping the SQL server and backing up the entire
directory including the database files. I figured that was a reasonably
safe
way to backup even though I would have no idea yet how to restore from
that.)
I will be able to kick everyone off the system and stop the SQL server if
necessary. If fact if it makes the task quicker and easier I would prefer
that.
Thanks...
</pre>
</blockquote>
</blockquote>
<pre wrap=""><!-->
</pre>
</blockquote>
<font size="-1"><font face="Arial">Hi<br>
<br>
Take a look at this article -
<a class="moz-txt-link-freetext" href="http://links.10026.com/?link=http://support.microsoft.com/default.aspx?scid=kb;en-us;224071</a><br>">http://support.microsoft.com/default.aspx?scid=kb;en-us;224071">http://support.microsoft.com/default.aspx?scid=kb;en-us;224071</a><br>
This might help get up and running again.<br>
<br>
Additionally you should look at this link which tells you how to move
the databases - <a class="moz-txt-link-freetext" href="http://links.10026.com/?link=http://support.microsoft.com/kb/314546/en-us</a><br>">http://support.microsoft.com/kb/314546/en-us">http://support.microsoft.com/kb/314546/en-us</a><br>
<br>
<br>
<br>
-- <br>
Regards<br>
Steen Schlüter Persson<br>
Databaseadministrator / Systemadministrator<br>
</font></font>
</body>
</html>
--080404050103090909090207--|||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:
> > 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...
> >
> >> 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:
> >>
> >>
> >> I don't know anything about SQL server.
> >>
> >> We have one old PC running Windows NT and SQL server. I think it's a
> >> standard edition. It is serving an accounting application. I want to move
> >> to
> >> a newer server before the old one goes bad (as it's already starting to
> >> do).
> >> The new server runs Windows 2000 Server. I have already installed SQL
> >> server
> >> (enterprise edition) on the new server.
> >>
> >> So how do I go about moving the database over? I have browsed the
> >> newsgroup
> >> here and seen articles about backing up and restoring. But I don't even
> >> know
> >> how to do a proper backup and the articles don't say. (In the past I have
> >> been backing up by stopping the SQL server and backing up the entire
> >> directory including the database files. I figured that was a reasonably
> >> safe
> >> way to backup even though I would have no idea yet how to restore from
> >> that.)
> >>
> >> I will be able to kick everyone off the system and stop the SQL server if
> >> necessary. If fact if it makes the task quicker and easier I would prefer
> >> that.
> >>
> >> Thanks...
> >>
> >>
> >>
> >>
> >
> >
> >
> >
> Hi
> Take a look at this article -
> http://support.microsoft.com/default.aspx?scid=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
>