| Author |
Topic |
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
 Posted - 2006-06-15 : 13:28:45
|
| Gurusi have a problem in hand.I have a db and some records were deleted from the DB accidentally and we dnt have the backup.Can we anyhow restore those records from .ldf file or somethin?anythin possibleregardsNitin |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-06-15 : 13:33:16
|
| What recovery model is the database using? If SIMPLE, then the answer is no. If FULL and you haven't backed up the transaction log, then you can use a third party tool to read the transaction log. I'm pretty sure we've already discussed this you though. Lumigent and Red Gate have tools such as this. IIRC, they are around 300 bucks or so.Tara Kizeraka tduggan |
 |
|
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
Posted - 2006-06-15 : 14:16:02
|
| TaraThird party tools are the only solution?Recovery model is full.No other way out coz we dnt have timeRegardsNitin |
|
|
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
Posted - 2006-06-15 : 14:16:52
|
| i meant to say is there any other way out?RegardsNitin |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-06-15 : 14:33:56
|
| If you don't have a full backup plus the transaction logs since the full backup plus the one that includes the delete, then the only way is by using a third party tool. Purchasing and downloading a tool should only take a few minutes. Just put it on your Corporate card then do an expense report to get it paid for by the company.Tara Kizeraka tduggan |
|
|
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
Posted - 2006-06-15 : 15:04:01
|
| yes i will do that.Thanks tara |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-06-15 : 21:10:29
|
if you can get it for free like a demo or trial, then use that, i expect this will be the last time you'll be asking this sort of question anywaysright?  --------------------keeping it simple... |
|
|
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
Posted - 2006-06-16 : 03:31:17
|
| Jen thanks for the advice |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-06-18 : 02:48:28
|
| Is this a runner chaps?If the recovery model is set to FULL but a full backups has never been made is the transaction log running in FULL mode? I thought that didn't happen until the FIRST full backup was made, but I may be talking out of the wrong end!Kristen |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-06-19 : 12:27:23
|
| The 3rd party tools read a transaction log backup. They don't require you to restore them. If you had to restore though, it would require a full backup as a starting point.Tara Kizeraka tduggan |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-06-19 : 14:15:15
|
| Yup, I understand that bit. I just thought the TLog didn't start growing until folk made their first Full Backup (and then if they don't make a TLog backup it grows for ever of course).So if I got that bit right I was assuming the TLog was clearing at checkpoint - until the first full backup is made.But given that we have automated backups and I've never done that I have no idea if its right, or just me being barmy!Kristen |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-06-19 : 14:19:01
|
| The transaction log grows regardless if a full backup has ever been made. It's only when you do a restore will you need the starting point plus the entire chain.Tara Kizeraka tduggan |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-06-19 : 14:31:54
|
| Thanks for clarifying Tara. Not something I'm expecting to experience though ... but maybe it will come up as an interview question!Kristen |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-06-19 : 14:35:20
|
| It comes into play a lot of times here when we install SQL Server in test or development. We don't perform transaction log backups on those servers. If we use the GUI to create the database and haven't changed model, then the database is created in full recovery model. I try to remember to change it to simple plus change model, but sometimes I forget. I then get alerted when we are close to running out of disk space or already have. Oops!Tara Kizeraka tduggan |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-06-19 : 15:43:01
|
| Part of my stuff that does the Full/TLog backups checks for not-yet-seen databases, and just adds them to the roster.Thus my problem when I get the Recovery Model wrong is that I wind up with a disk full of TLog backups!Kristen |
|
|
|
|
restoring Database