Re: Restoring from non-truncated transaction log
From: Paul S Randal [MS] (prandal_at_online.microsoft.com)
Date: 02/04/05
- Next message: Jacco Schalkwijk: "Re: How to Log Errors/Exceptions into Event Log"
- Previous message: Brett: "MS Access can't find Recordsource object"
- In reply to: 2 Struggling Admins: "Re: Restoring from non-truncated transaction log"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 4 Feb 2005 13:54:55 -0800
Hi - I suggest you read the Books Online topics on recovery models
('Selecting a Recovery Model' is a good start) as that will help you
understand the issues and alternatives you have depending on what recovery
model you're using.
Regards.
-- Paul Randal Dev Lead, Microsoft SQL Server Storage Engine This posting is provided "AS IS" with no warranties, and confers no rights. "2 Struggling Admins" <2StrugglingAdmins@discussions.microsoft.com> wrote in message news:BABCE850-09CC-4766-A370-71360F7C9C8C@microsoft.com... > >> 1- the DB was in Full recovery mode > Sorry about this. Like I said, I am not very experienced with SQL. I had > NOT been backing up the transaction log, so I would assume the transaction > log would still have all of that data in it. Does it remove data from the > transaction log when you restore a database but not the transaction log? As > far as the "Full recovery mode" goes, do you mean backup the entire database > every time. We do backup the entire database as opposed to just the changes, > but not the transaction logs. Is this what you are referring to, or is it a > setting on the restore? > > "Chris" wrote: > > > Hi, > > > > In my opinion, if > > 1- the DB was in Full recovery mode > > and > > 2- you have have the complete T-log since Nov > > > > then it will work. > > > > But I would be surprised if you meet both requirement > > Chris > > > > > > "Support" <Support@discussions.microsoft.com> a écrit dans le message de > > news:A8AE3D87-6975-444D-BD77-23407F529DEE@microsoft.com... > > > We have a database which unfortunately someone has restored from a backup > > > which was 2+ months old after he ran a script against the database that > > had > > > negative effects. So, now there is a gap in the data from Nov23 - Jan 31. > > > What I am wondering is would it be possible to restore the missing data in > > > the database with the transaction log? We were not backing up the > > > transaction log; so, it was not truncated. We have detached the database > > and > > > the transaction log and reattached them on another server. > > > > > > For some reason every time I explain this in person, people miss > > something. > > > So, here are the basic facts: > > > > > > MS SQL server 2000 database restored from backup > > > 2 months of missing data > > > in tact(not truncated) transaction log > > > a script was run against the database before it was restored from backup > > on > > > Jan 31 > > > database structure is identical. > > > > > > Is this savable data, or should we just give up. I am not a DBA. He quit > > > about 1.5 months ago; so please be specific about what to do as I am not > > yet > > > extreamly familiar with SQL server 2000. By the way we have been working > > on > > > this since the 31st, and all we know for sure is that SQL doesn't like it > > > when you do something like this. Thanks in advance for any guidance > > either > > > way. > > > > > >
- Next message: Jacco Schalkwijk: "Re: How to Log Errors/Exceptions into Event Log"
- Previous message: Brett: "MS Access can't find Recordsource object"
- In reply to: 2 Struggling Admins: "Re: Restoring from non-truncated transaction log"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
