Restoring Database from Transaction Log only.

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.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Restoring Database from Transaction Log only.

Author

Topic

sandesh_moghe
Constraint Violating Yak Guru

310 Posts

Posted - 2002-03-26 : 05:10:11

Hi,
Is it possible to restore/Recover database from Transaction Logs only.
I have searched the forum for the same, but didnt get satisfactory answer.

Thanx in advance

---------------------------
Sandesh - The Messanger

AndrewMurphy
Master Smack Fu Yak Hacker

2916 Posts

Posted - 2002-03-26 : 06:56:17

Sandesh,

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=14063

might be of use.

Andrew

sandesh_moghe
Constraint Violating Yak Guru

310 Posts

Posted - 2002-03-26 : 08:03:21

Thanx Andrew,
But my problem is quite different.
first of all we just go thru the scenariao...
I have a full back up of say 21st March.
I have data files on C drive and log on D drive
If Today My C drive crashes.....
At this point i have 21st March Backup and Transaction Log.

How can i recover the database?

---------------------------
Sandesh - The Messanger

Jay99

468 Posts

Posted - 2002-03-26 : 09:22:01

SOL* . . . that's why you do incremental backups, you can only restore up to your most recent backup (note: sometimes you can take a transaction log backup even if the db is corrupted and then restore up to the point in time just before corruption). If you blow you disk, and all you have is a full backup from the 21st of March, start packin your cardboard box . . .

quote:


-- Back up the currently active transaction log.
BACKUP LOG MyNwind
    TO MyNwind_log2
    WITH NO_TRUNCATE
GO

-- Restore the database backup.
RESTORE DATABASE MyNwind
    FROM MyNwind_1
    WITH NORECOVERY
GO

-- Restore the first transaction log backup.
RESTORE LOG MyNwind
    FROM MyNwind_log1
    WITH NORECOVERY
GO

-- Restore the final transaction log backup.
RESTORE LOG MyNwind
    FROM MyNwind_log2
    WITH RECOVERY
GO

*(footnote): maybe there is some 3rd party tool that can do this . . .

Jay
<O>

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources