Re: Restore database

Here's what you should have done:

I did a backup for application database: testdb
I re-created the master db with setup.exe
Restore the testdb database

No need to create a database before you restore it. If you want to read further, read about the REPLACE option of the RESTORE command.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"astalavista" <nobody@xxxxxxxxxxx> wrote in message news:46c56398$0$422$426a74cc@xxxxxxxxxxxxxxx
Hi,

SQL server 2005
I did a backup for application database: testdb
I re-created the master db with setup.exe
I created a new database testdb
I want to restore the backup of testdb
when I did I have the following message ...

The backupset holds a backup of a database other than the existing 'testdb' database

What I missed ?



.

Relevant Pages

  • Backup and Restore Files
    ... What is the best way to backup and restore a runtime database file? ... pszDisplayName As String ...
    (microsoft.public.access.gettingstarted)
  • 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: Transaction Log ??
    ... we used to simplify our database restore process: ... every database got their respective backup folder. ... -- get logFileName, FirstLSN, LastLSN list ...
    (microsoft.public.sqlserver.security)