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 |
|
nar
Starting Member
1 Post |
 Posted - 2007-10-18 : 07:07:57
|
| I'd delete data from table in SQL Server2000.and I didn't have any backup file?Anybody Please help me.How do I recovery data? I had myDB.mdf 10,xxx KB and myDB.ldf 100,xxx KB |
|
|
AnimalMagic
Starting Member
28 Posts |
Posted - 2007-10-18 : 07:20:16
|
| without a backup i dont think you have many options unless you copied the data into another table before deleting. |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-18 : 07:22:12
|
| If you are using FULL Recovery Model you may be able to use a log reader like Lumicent.However, if you NEVER made a Full Backup I reckon that the database will not have started TLogging ...Put a Maintenance Plan in place for ALL User Databases - otherwise it will happen again!Kristen |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-10-18 : 08:04:23
|
quote:
Originally posted by nar
I'd delete data from table in SQL Server2000.and I didn't have any backup file?Anybody Please help me.How do I recovery data? I had myDB.mdf 10,xxx KB and myDB.ldf 100,xxx KB
Always take table backup before deleting data if you are working in a production serverMadhivananFailing to plan is Planning to fail |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-20 : 01:15:13
|
| Take look at Lumigent's Log Explorer. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-20 : 03:03:07
|
| rmiao:Sorry, I'm too lazy to test this, and I'm sure you will know the answer!If I make a database, FULL Recovery Model, and I do NOT take a Full Backup - is the TLog recording? My expectation is that the database is behaving like SIMPLE Recovery Model UNTIL I take my first Full backup?And if that is the case would there be anything that a Log Reader could salvage?ThanksKristen |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-20 : 16:47:16
|
| If db is in full recovery model, Log Explorer can recover transactions in both log file and log backup files. If db is in simple recovery model, nothing can do after checkpoint since committed transactions are truncated from log. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-10-20 : 18:24:02
|
| Kristen,Even if a full backup has not been taken on a database, SQL Server is still saving the transactions in the tlog file as long as the recovery model is not SIMPLE. It's just that you can't restore to a point in time until you start with a full backup and then have a tlog chain.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-21 : 06:51:41
|
| Thanks Tara. Mind you ... I don't plan on relying on Lumigent, and our maintenance routines will take a Full Backup within 10 minutes of the new database being created, so I don't have to worry about this scenario - but its nice to know how to save other folks skin.Kristen |
|
|
|
|
|
|
|
|
How do I recovery data from SQL Server2000