November 27, 2003 at 4:52 am
The question is:
Does SQL Server enable a transaction log restore without a predecessor full Restore?
If you can find a formal documentation or reference about it, it will be great.
Here are my current conclusions:
User have to perform Full Backup (DBs and logs) and this backup will be a major backup from the SQL point of view.
Than user perform incremental backup (say transaction logs only ) this backup appear as sub-backup in the SQL.
So than user wants to restore specific transaction he should first to restore from the full backup with the option "leave the DB non-operational, allow transaction restores" .
After performing this step DB is in the status "loading" and waiting for the transaction restores.
Now user can choose transaction sub-backup in the backups tree and with option "leave DB operational, wont be any more transaction restores" user can restore specific transaction.
Notice! If user restored to much and need to go to the past transaction only, he should start the hole process again!!!!
November 30, 2003 at 10:33 am
In your scenario you could restore the full backup, then the incremental, then the tran logs if the transaction happened after the incremental, if the tran happened before the incremental, you could go from full to the tran log backup.
HTH
Ray Higdon MCSE, MCDBA, CCNA
------------
Ray Higdon MCSE, MCDBA, CCNA
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply