Re: Restoring from non-truncated transaction log
From: 2 Struggling Admins (2StrugglingAdmins_at_discussions.microsoft.com)
Date: 02/04/05
- Next message: Chris: "Re: Restoring from non-truncated transaction log"
- Previous message: djc: "opportunistic locking"
- In reply to: Tibor Karaszi: "Re: Restoring from non-truncated transaction log"
- Next in thread: Tibor Karaszi: "Re: Restoring from non-truncated transaction log"
- Reply: Tibor Karaszi: "Re: Restoring from non-truncated transaction log"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 4 Feb 2005 11:59:04 -0800
> That restore overwrites everything inside the database. Including the
entries in the transaction
> log. This of a restore like applying a VM Ware image on a machine.
Like I said I am not very experienced with SQL. Please forgive my ignorance
in this matter. We were not backing up the Transaction log, just the
database. When the restore was done it wasn't restoring the transaction log.
Does it remove the entries from the transaction log when you restore the
database form a backup even if it doesn't restore the transaction log? I
would think that would be the opposite of what the transaction log was
supposed to do.
"Tibor Karaszi" wrote:
> > 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.
>
> That restore overwrites everything inside the database. Including the entries in the transaction
> log. This of a restore like applying a VM Ware image on a machine.
>
>
> > What I am wondering is would it be possible to restore the missing data in
> > the database with the transaction log?
>
> Are you saying that you saved something, somehow (backup, detach) before that restore was performed?
> If not, I fail to see anyway to get anything back. Unelss you have some type of backup which is more
> recent that the 2 month old backup.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> http://www.sqlug.se/
>
>
> "Support" <Support@discussions.microsoft.com> wrote in message
> 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: Chris: "Re: Restoring from non-truncated transaction log"
- Previous message: djc: "opportunistic locking"
- In reply to: Tibor Karaszi: "Re: Restoring from non-truncated transaction log"
- Next in thread: Tibor Karaszi: "Re: Restoring from non-truncated transaction log"
- Reply: Tibor Karaszi: "Re: Restoring from non-truncated transaction log"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
