Restoring from a CD

There are two SQL 2000 servers, Server A and Server B. I backed up all the databases on Server A and then burned the backups to a CD. Now I am trying to restore one of the databases from Server A on Server B but I am having problems and getting error messages.
How do I restore a database backup file (*.bak) from a CD if the database backup is from another SQL Server?What problem are you having, specifically?
Don't forget to go into the options tab and change the file paths for the
physical file names -- in my experience that's the most common thing people
forget about when restoring databases from other servers.
"Evan" <anonymous@.discussions.microsoft.com> wrote in message
news:01075679-9221-4095-ABAF-0DB0C4CED06C@.microsoft.com...
> There are two SQL 2000 servers, Server A and Server B. I backed up all the
databases on Server A and then burned the backups to a CD. Now I am trying
to restore one of the databases from Server A on Server B but I am having
problems and getting error messages.
> How do I restore a database backup file (*.bak) from a CD if the database
backup is from another SQL Server?
>|||I'm not sure how to restore the backup so I tried a couple different methods but none of them worked. I'd like directions on how to restore the databases.
Evan
-- Adam Machanic wrote: --
What problem are you having, specifically?
Don't forget to go into the options tab and change the file paths for the
physical file names -- in my experience that's the most common thing people
forget about when restoring databases from other servers.
"Evan" <anonymous@.discussions.microsoft.com> wrote in message
news:01075679-9221-4095-ABAF-0DB0C4CED06C@.microsoft.com...
> There are two SQL 2000 servers, Server A and Server B. I backed up all the
databases on Server A and then burned the backups to a CD. Now I am trying
to restore one of the databases from Server A on Server B but I am having
problems and getting error messages.
>> How do I restore a database backup file (*.bak) from a CD if the database
backup is from another SQL Server?
>|||In Enterprise Manager:
Create a new database with whatever name you want.
Right-click on it. Click "All Tasks" -> "Restore Database".
Select "From device".
Click "Select Device", then "Add..." and browse the file you want to
restore.
Click "OK" twice. Then click the "Options" tab. Select "Force restore over
existing database". Make sure the paths in "Move to physical file name"
exist on your server. Edit the paths if necessary.
Click "OK". At this point it should restore...
"Evan" <anonymous@.discussions.microsoft.com> wrote in message
news:29FAAB9A-E962-40D2-8733-F476D8650F7B@.microsoft.com...
> I'm not sure how to restore the backup so I tried a couple different
methods but none of them worked. I'd like directions on how to restore the
databases.
> Evan
>
> -- Adam Machanic wrote: --
> What problem are you having, specifically?
> Don't forget to go into the options tab and change the file paths for
the
> physical file names -- in my experience that's the most common thing
people
> forget about when restoring databases from other servers.
>
> "Evan" <anonymous@.discussions.microsoft.com> wrote in message
> news:01075679-9221-4095-ABAF-0DB0C4CED06C@.microsoft.com...
> > There are two SQL 2000 servers, Server A and Server B. I backed up
all the
> databases on Server A and then burned the backups to a CD. Now I am
trying
> to restore one of the databases from Server A on Server B but I am
having
> problems and getting error messages.
> >> How do I restore a database backup file (*.bak) from a CD if the
database
> backup is from another SQL Server?
> >|||It worked! Thanks a million.
I tried that procedure before but it didn't work - the file paths are a gotcha.
Evan
-- Adam Machanic wrote: --
In Enterprise Manager:
Create a new database with whatever name you want.
Right-click on it. Click "All Tasks" -> "Restore Database".
Select "From device".
Click "Select Device", then "Add..." and browse the file you want to
restore.
Click "OK" twice. Then click the "Options" tab. Select "Force restore over
existing database". Make sure the paths in "Move to physical file name"
exist on your server. Edit the paths if necessary.
Click "OK". At this point it should restore...
"Evan" <anonymous@.discussions.microsoft.com> wrote in message
news:29FAAB9A-E962-40D2-8733-F476D8650F7B@.microsoft.com...
> I'm not sure how to restore the backup so I tried a couple different
methods but none of them worked. I'd like directions on how to restore the
databases.
>> Evan
>> -- Adam Machanic wrote: --
>> What problem are you having, specifically?
>> Don't forget to go into the options tab and change the file paths for
the
> physical file names -- in my experience that's the most common thing
people
> forget about when restoring databases from other servers.
>> "Evan" <anonymous@.discussions.microsoft.com> wrote in message
> news:01075679-9221-4095-ABAF-0DB0C4CED06C@.microsoft.com...
>> There are two SQL 2000 servers, Server A and Server B. I backed up
all the
> databases on Server A and then burned the backups to a CD. Now I am
trying
> to restore one of the databases from Server A on Server B but I am
having
> problems and getting error messages.
>> How do I restore a database backup file (*.bak) from a CD if the
database
> backup is from another SQL Server?
>>