Re: help!!!

From: Dan Guzman (danguzman_at_nospam-earthlink.net)
Date: 08/12/04


Date: Wed, 11 Aug 2004 20:13:57 -0500

Your only recourse to restore from your latest database backup.

-- 
Hope this helps.
Dan Guzman
SQL Server MVP
"ChrisR" <anonymous@discussions.microsoft.com> wrote in message
news:43fa01c47ff4$26cc0870$a301280a@phx.gbl...
> sql2k sp3
>
> I accidentally started restoreing the wrong db. I
> cancelled it and now its in a load state. Can I just put
> it back!!!


Relevant Pages

  • Re: login probs after restore
    ... Tibor Karaszi, SQL Server MVP ... "ChrisR" wrote in message ... > production and restore it in a development environment. ...
    (microsoft.public.sqlserver.server)
  • Re: Cyclic REdundancy error
    ... >I inserted data into my SQL Server table using BCP. ... Restore damaged files from the latest database backup. ... DBCC CHECKDB can be more time consuming than restoring the damaged files ...
    (microsoft.public.sqlserver.programming)
  • Re: SQL 2000 Standard Edition : Log Shipping copy problem..
    ... "Leave database read-only and able to restore additional transaction logs", ... the standby server with the same option. ... What if a full database backup has been schedule to run everyday on the ...
    (microsoft.public.sqlserver.replication)
  • Re: Another question about DB Mirroring
    ... when I do a restore automatically the db owner is ... Tibor Karaszi, SQL Server MVP ... if I stop the mirror or the ...
    (microsoft.public.sqlserver.setup)
  • Re: Another question about DB Mirroring
    ... changed with my domain account and I have to re set manually. ... domain account") when you do that restore. ... Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.setup)