Re: backup and restore a database

From: Uri Dimant (urid_at_iscar.co.il)
Date: 09/28/05


Date: Wed, 28 Sep 2005 13:58:36 +0300

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?



Relevant Pages

  • Re: Restoring SQL Server Backups
    ... ORIGINAL BACKUP & RESTORE (MSDE Database) ... occurrenceof cachestore flush for the 'Object Plans' cachestore (part ...
    (microsoft.public.sqlserver.server)
  • Re: Restoring SQL Server Backups
    ... ORIGINAL BACKUP & RESTORE (MSDE Database) ... occurrenceof cachestore flush for the 'Object Plans' cachestore (part ...
    (microsoft.public.sqlserver.server)
  • 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 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: RMAN restore of full backup fails completely
    ... You are not using a catalog database. ... You might have autobackup controlfile on, ... Your autobackup has been made *prior* to the backup! ... plus archivelog', when i try a restore on the other server however, the ...
    (comp.databases.oracle.server)