| Jyothi Pai [MS] 2002-12-20, 6:23 pm |
| Hi Giorgio,
As Geoff has pointed out, there is no guarantee that the data exists in any
recoverable form in your existing database plus you cannot get the data
back from the database files using any of our tools. You could also explore
other database recovery shops.
You could also try to backup the currently active transaction log (provided
the log file is accessible and undamaged) using the following commands from
Query Analyzer:
BACKUP LOG <db_name> TO DISK = '<path_to_backup_file or
backup_device_name>' WITH NO_TRUNCATE
If you have a last know good full database backup, restore the database
from the last known good backup by running this command:
-- You can restore this as a *new* database just to be safe with NORECOVERY
to be able to restore transaction log backups
RESTORE DATABASE <db_name> FROM DISK = '<path_to_backup_file>' WITH
NORECOVERY
-- Followed by any other transaction log backups. Make sure you do not
select to recover the database until you apply the *last* transaction log
for example,
RESTORE LOG <db_name> FROM DISK = '<path_to_log_backup1>' WITH NORECOVERY
GO
RESTORE LOG <db_name> FROM DISK = '<path_to_log_backup2>' WITH NORECOVERY
:
:
-- You could restore to a point in time just before you deleted the data
accidentally (if you know when this happened) and the database will be
restored to the state it was -- in as of the specified date and time
RESTORE LOG <db_name> FROM DISK = '<path_to_log_backup1>' WITH RECOVERY,
STOPAT = '<point in time up to which you want to recover the data>'
GO
For more information, please refer to the following books online (BOL)
topics:
RESTORE
How to restore to a point in time (Transact-SQL)
Be sure to make a copy of the database files and also backup the database
as it stands at this time as a safety measure before you start the above
exercise.
HTH,
Regards,
Jyothi Pai
Microsoft Online Support Engineer
Get Secure! – www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
| From: "Giorgio Parmeggiani" <gipasoft@gipasoft.net>
| Newsgroups: microsoft.public.sqlserver.server
| Subject: Deleted Rows
| Date: Fri, 20 Dec 2002 17:23:44 +0100
| Organization: Tiscali Spa
| Lines: 17
| Message-ID: <atvg6g$s7l$1@lacerta.tiscalinet.it>
| NNTP-Posting-Host: ppp-217-133-210-54.dialup.tiscali.it
| X-Trace: lacerta.tiscalinet.it 1040401424 28917 217.133.210.54 (20 Dec
2002 16:23:44 GMT)
| X-Complaints-To: newsadmin@it.tiscali.com
| NNTP-Posting-Date: 20 Dec 2002 16:23:44 GMT
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
| Path:
cpmsftngxa09!TK2MSFTNGP08!cpps
sbbsa01.microsoft.com!news-out.cwix.com!newsfe
ed.cwix.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!newsfe
ed.icl.net!newsfeed.fjserv.net!newsfeed.freenet.de!frnkge1-snf1.gtei.net!new
s.gtei.net!draco.tiscalinet.it!not-for-mail
| Xref: cpmsftngxa09 microsoft.public.sqlserver.server:247147
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| Hi
|
| I have involuntarily deleted some rows
| of a table I can in some recover them?
| Opening with notepad the file of
| sql server I see the deleted rows!
|
| Thanks
| Giorgio
|
| ----------------------------------------
| Dr. Giorgio Parmeggiani
| Consulente Software
| http://www.gipasoft.net
| ----------------------------------------
|
|
|
|