Re: Want to revert back to original state of database before i performed restore database.

If you have a full system backup from the time when you want to restore the
database, you could restore the SQL data and log files from that system
backup. Restore them to a different folder. Then you can attach those files
to SQL Server as a new database to verify its the data you want. See Books
On Line for instructions. You can search on 'attach'. If you're happy with
it you can use those files for the real database.
Paul Shapiro

"san" <shdomadia@xxxxxxxxx> wrote in message
news:1163591372.992261.249210@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Hello,
i am in great trouble. I want to revert back to original state of
database before i performed restore database on my sql server 2K
Database. Accidently i didn't take backup of my Database and i did
restore, so is there any way to get the original state back of my
Database?

Any suggestion will be highly appriciated.


.

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: Restoring SQL Server Backups
    ... ORIGINAL BACKUP & RESTORE (MSDE Database) ... occurrenceof cachestore flush for the 'Object Plans' cachestore (part ...
    (microsoft.public.sqlserver.server)
  • Re: SQL Litespeed
    ... I tested SQL Litespeed's backup and restore capabilities against that of the ... The first database, 'BINARY', had a single table with a single BINARY ...
    (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: Backups have Shadow Copy Problems
    ... and restarted the server. ... suggested and changed the recovery model to simple on the one database called ... I understand the issue to be: the backup task failed ... You back up data from a volume that contains a Microsoft SQL Server ...
    (microsoft.public.windows.server.sbs)
Loading