restore data

[Akhteruzzaman]

Hi: How can I restore data from the transaction log file in SQL Server 2005? Please help..

[Andy_L_J]

Asuuming your backup is something like this, and you have the Database Recovery Method set to FULL::

BACKUP DATABASE TestDB
TO DISK = 'e:\backups\TestDB.bak',
WITH
FORMAT,
MEDIANAME = 'TestDB_MediaSet1'

BACKUP LOG TestDB
TO DISK = 'e:\backups\TestDB_log.bak'
WITH
FORMAT,
MEDIANAME = 'TestDB_MediaSet1'

You can restore with something like:

USE master
GO

RESTORE DATABASE TestDB
FROM DISK = 'e:\backups\TestDB.bak'

**WITH REPLACE**

Check these links: Backups[^] Transaction Log Backups[^] Full Database Restore[^]

I don't speak Idiot - please talk slowly and clearly 'This space for rent' Driven to the arms of Heineken by the wife