Prev: Best SQL Backup Solution.
Next: transaction without a request
From: MessedBackup on 17 Mar 2010 22:51
We lost our full backup due to a system delete operation, our db went to
suspect mode and upon recovery we deleted a bunch of unused tables. One table
that was used got deleted as well. DB is in Simple recovery mode, therefore,
no backups exist nor does anything else?? any way i can use the tran log to
recover point in time without fullbackup? any disk recovery help??
From: Uri Dimant on 18 Mar 2010 02:52
Do you have MDF (datafile)of the database?

"MessedBackup(a)hotmail.com"
<MessedBackup(a)hotmail.com@discussions.microsoft.com> wrote in message
news:F33D574F-749D-4170-97E7-BEA90E25ED76(a)microsoft.com...
> We lost our full backup due to a system delete operation, our db went to
> suspect mode and upon recovery we deleted a bunch of unused tables. One
> table
> that was used got deleted as well. DB is in Simple recovery mode,
> therefore,
> no backups exist nor does anything else?? any way i can use the tran log
> to
> recover point in time without fullbackup? any disk recovery help??


From: Tibor Karaszi on 18 Mar 2010 04:29
So all you have is the database, in simple recovery model, and no backups?
No, since you are in simple recovery, the log records has most likely
already been re-used (overwritten). You can of course try some "log reader"
tool (Bing/Google) and see if they find anything in the log - but I doubt
it...

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi



"MessedBackup(a)hotmail.com"
<MessedBackup(a)hotmail.com@discussions.microsoft.com> wrote in message
news:F33D574F-749D-4170-97E7-BEA90E25ED76(a)microsoft.com...
> We lost our full backup due to a system delete operation, our db went to
> suspect mode and upon recovery we deleted a bunch of unused tables. One
> table
> that was used got deleted as well. DB is in Simple recovery mode,
> therefore,
> no backups exist nor does anything else?? any way i can use the tran log
> to
> recover point in time without fullbackup? any disk recovery help??

 | 
Pages: 1
Prev: Best SQL Backup Solution.
Next: transaction without a request