Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
shajimanjeri
Posting Yak Master
179 Posts |
 Posted - 2007-07-09 : 06:18:57
|
| Is there any way to get the deleted records from LDF or MDF file. Today by accidentally I executed one query and that dropped my table Inbox(table name only) from database. And in that table there was more 4,000 records, all these lost. So anybody can help me how to recover this table records?. Is there any way to get these? I don't have any backup for this table.shaji |
|
|
b.veenings
Yak Posting Veteran
96 Posts |
Posted - 2007-07-09 : 06:59:23
|
| do you also not have an physical backup of the whole Mdf or LDF file?else you cannot get this back.do you have an application that makes backups like symantec backup exec?Need an SQLDB consultant?check www.veeningsengineering.nl |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-07-09 : 07:08:12
|
| "I don't have any backup for this table."Just for clarification: You don't need to backup a table, specifically, but you do need to backup the database.If you have a backup of the database you can restore the table from it (actually what you need to do is to restore the backup to a NEW, Temporary, database, then copy the table over to your Real database, and then you can Drop the temporary database).If you don't have a backup then you need to put one in place .... explore Full Recovery model - this would let you restore to a point-in-time - e.g. to the minute before the accident happened, which for a changing database may be more important than, say, "last nights backup".Note also that SQL Server supports a "Backup all databases" maintenance plan - invoking that would mean that ANY database you create on that server will be automatically backed up without you having to do anything extra. That can be a life saver too!Kristen |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
Recovering lost data