backup and restore a database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Joe - 28 Sep 2005 09:03 GMT

Dear all,
When i backup a database to a device(file) and then restore it into other
computer. The user always use to know the name of the database in order to
restore the database, can i make a backup to user without know the name of
the database to success to restore?

Reply to this Message

Uri Dimant - 28 Sep 2005 11:58 GMT

Joe
I don't understand. Do you want to pass to BACKUP command a database name as
a parameter?

> Dear all,
> When i backup a database to a device(file) and then restore it into other
> computer. The user always use to know the name of the database in order to
> restore the database, can i make a backup to user without know the name of
> the database to success to restore?

Reply to this Message

Sue Hoegemeier - 28 Sep 2005 18:29 GMT

You can restore a user database backup to whatever database
name you want. The user doesn't have to specify the original
name of the database that was backed up.
You can find samples of how to do this in books online under
the topic: How to restore a database with a new name
or check the following link:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_7_b
ackpc_6ng9.asp

-Sue

>Dear all,
>When i backup a database to a device(file) and then restore it into other
>computer. The user always use to know the name of the database in order to
>restore the database, can i make a backup to user without know the name of
>the database to success to restore?

Reply to this Message