Saturday, February 25, 2012

backup and restore a database

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?Joe
I don't understand. Do you want to pass to BACKUP command a database name as
a parameter?
"Joe" <Joe@.discussions.microsoft.com> wrote in message
news:4E97E1F0-DC3E-4994-9F0A-0104F2F26979@.microsoft.com...
> 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?|||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/d...>
kpc_6ng9.asp
-Sue
On Wed, 28 Sep 2005 01:03:03 -0700, Joe
<Joe@.discussions.microsoft.com> wrote:

>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?

No comments:

Post a Comment