Re: backup and restore a database

From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 09/28/05 

Date: Wed, 28 Sep 2005 12:29:11 -0500

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

Relevant Pages

  • RE: How do I restore from mdf and ldf files?
    ... Tasks -> Backup Database ... Tasks -> Restore Database ... Windows 2003 Server with Latest Service Pack ... Pre-requisites for Sharepoint Backup and Restore: ...
    (microsoft.public.sharepoint.portalserver)
  • Re: POINT IN TIME RESTORE
    ... This is what you should have done in order to do the restore as you wish: ... > 3- erase data ... > 5- restore database with norecovery ... The BACKUP DATABAE can of course be at an earlier point in time, ...
    (microsoft.public.sqlserver.server)
  • RE: How to restore edb & stm files from bkf backup file on another exc
    ... copied to a different storage group on the same server or to a different ... On production server successfully backup information ... Restore Status ... Failed to find a database to restore to from the Microsoft ...
    (microsoft.public.exchange.admin)
  • Re: Backend Exchange migrate to New Hardware (Server)
    ... Exchange mailbox stores and Exchange public folder stores. ... When you use Backup to restore Exchange databases, ... Storage Engine to restore Exchange database files and their ...
    (microsoft.public.exchange.setup)
  • Backup and Restore Files
    ... What is the best way to backup and restore a runtime database file? ... pszDisplayName As String ...
    (microsoft.public.access.gettingstarted)