Back-Up and restore

Hi Guys,
I have a database, which I recently backed up. Now I would like to
restore this back-up on another server. So basically I m trying to
create a copy of my database on the other server.
How can I restore this back-up file on the other server. When I try
doing that from the Enterprise Manager, it says that I have to choose
from an existing backup file. I m using SQL Server 2000 on Win 2K.
So basically what I want is to create the database from scratch on the
new server using that back up file from the other database. Can somebody
tell me the procedure for this. I m a newbie at SQL Server.
Thanks.
Ricky
--
Posted via http://dbforums.comRicky, it should be fairly straight forward. Use Enterprise Manager and
fire off the restore wizard. Just restore database from device and navigate
to the backup file. If you have problems, I highly recommend going to the
Books online and lookup the topic "RESTORE DATABASE" and do the restore from
Query Analyzer in T-SQL. You may find T-SQL a little more difficult, but
it's more rewarding and more flexible that the GUI for all database
functions. The only thing that comed to mind that I've never done with QA
is to get a table in design view and rearrange the column order... and that
is just cosmetic anyway.
hth,
Eric
"Ricky_Singh" <member32195@.dbforums.com> wrote in message
news:3082099.1057594899@.dbforums.com...
> Hi Guys,
> I have a database, which I recently backed up. Now I would like to
> restore this back-up on another server. So basically I m trying to
> create a copy of my database on the other server.
> How can I restore this back-up file on the other server. When I try
> doing that from the Enterprise Manager, it says that I have to choose
> from an existing backup file. I m using SQL Server 2000 on Win 2K.
> So basically what I want is to create the database from scratch on the
> new server using that back up file from the other database. Can somebody
> tell me the procedure for this. I m a newbie at SQL Server.
> Thanks.
> Ricky
> --
> Posted via http://dbforums.com|||Hi Ricky,
You said :
>>'I have a database, which I recently backed up. Now I would like torestore
this back-up on another server. So basically I m trying to create a copy of
my database on the other server'. <<
It seems to me that you already have a backup available that you want to
restore...do the following :
1) Copy the backup file across to the new server.
2) On the new server, create a database device ( Expand: Management > Right
click on 'Backup' > New backup device, note the path and give it a
descrpiptive name (somedbname.bak)
3) Right click on the database you want to restore, All Tasks > Restore
Database
4) Click on 'From Device' and click 'Select Devices' on device name > click
Add.
5) click on filename and browse to the location where you copied the old
backup file and click ok.
6) Now, don't close all the windows, come back to the restore database
window and click on 'Options' tab and select the 'Force restore over
existing database'
7) in the Logical filename, check the old server for the logica filename
(somedbname) and enter it there, do the same for both log and mdf files.
8) In the 'Move to Physical filename' make sure it is pointing to the data
and log files of this new database.
Note that, the logical filename is not the path, but just a name, you can
get it by going to the old server, right click the database > properties --
the 'Filename' here is the logical filename -- do the same for the
Transaction log tab as well.
After you hit restore...it will complete the restore and give u a message
saying that restore is complete...
Hope this helps.
Regards,
Andy.
PS: This information is Ad-hoc and i cannot be held responsible for any
action you might take, I recommend that you consult a few people and then go
about it.
Thanks
"Ricky_Singh" <member32195@.dbforums.com> wrote in message
news:3082099.1057594899@.dbforums.com...
> Hi Guys,
> I have a database, which I recently backed up. Now I would like to
> restore this back-up on another server. So basically I m trying to
> create a copy of my database on the other server.
> How can I restore this back-up file on the other server. When I try
> doing that from the Enterprise Manager, it says that I have to choose
> from an existing backup file. I m using SQL Server 2000 on Win 2K.
> So basically what I want is to create the database from scratch on the
> new server using that back up file from the other database. Can somebody
> tell me the procedure for this. I m a newbie at SQL Server.
> Thanks.
> Ricky
> --
> Posted via http://dbforums.com