Dear Friends,
How to recover Accidently deleted records from SQL Server 2005?
Please Friends help me
Thanx in advance
+2
A:
If your database is in full recovery mode then it is possible to restore it back in time. Otherwise you need to restore a backup to get that data back.
Read this article: How to: Restore to a Point in Time (SQL Server Management Studio)
Denis Valeev
2010-09-23 12:33:55
Curses, you beat me to it. ;)
Andy Evans
2010-09-23 12:38:10
@Andy Evans Hahah! :) There's nothing like competition, eh?
Denis Valeev
2010-09-23 12:40:03
+1
A:
This article may provide some useful information for you. If you don't have a backup that contains the records you need I don't believe there's much you can do.
http://www.simple-talk.com/sql/backup-and-recovery/sql-server-2005-backups/
Chuck
2010-09-23 12:39:42