Re: SQL restore table / rollback / undo table drop without backups?
- From: "Tibor Karaszi" <tibor_please.no.email_karaszi@xxxxxxxxxxxxxxxxxx>
- Date: Fri, 3 Jul 2009 13:42:47 +0200
If you never did a database backup, then your chances are very slim, because you don't have anything to "hang" your current log backup on. And, furthermore, the database would be in auto-truncate mode so the log is emptied regularly anyhow.
If you ever did a database backup, then you can perform a log backup now, then restore your database backup and all subsequent log backups (including this last one), but stop before this accident.
I haven't heard of such services, and chances are that there isn't much information in there physically anyhow. If you do find such service or tool (like http://officerecovery.com/mssql/index.htm), I wouldn't have too much hope, I'm afraid.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Anand" <anand.vetri@xxxxxxxxx> wrote in message news:4a8339d0-38a8-4c25-afdb-d101d739049a@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
possible or impossible?
we have a database which previously was understood to have backups on
it through the inception of the server. we found out today after
having dropped tables that the backups had not been performed as were
expected.
The database recovery model is Full, but we do not have any bak
(backup) files.
are there any possible options to get back the data that was lost on
the dropped tables?
Microsoft SQL server 2005.
or if there are even services out there that can restore data and how
much of a lag time there may be
.
- References:
- Prev by Date: SQL Server 2008 and background commit
- Next by Date: Re: SQL restore table / rollback / undo table drop without backups?
- Previous by thread: SQL restore table / rollback / undo table drop without backups?
- Next by thread: Re: SQL restore table / rollback / undo table drop without backups?
- Index(es):
Relevant Pages
|
Loading
