Restoring from transaction log

[idd]

Hi, Ignore the previous thread the title was wrong.
Big Problem, hoping for solution soon.
Using SQL 2000

A database on SQL 2000 was deleted by a script which dropped and re-created the database.

We checked for a backup but it seems the backup failed the night before and there are no .bak file backups for this database, basically backups for this particular database are limited to the following.

an MDF from March 2007
an LDF from March 2007
All transaction Log files since January.

I have recreated a database using the mdf and ldf from march, hoping that I could use the transaction logs since then to bring the database up to present day.

I carried out a backup of this database to make a .bak file, I then restored the database with the option:

Leave database non operational but able to restore additional tranaction logs.

When I tried to then restore the database with the transaction logs, (they are daily logs) since March 29th 2007

I get a message along the lines
Could not redo log record(20:96:2), for transaction ID (0:2936), on Page (1:95), database 'BT2009' (41), Page LSN = (19:264:2), Type = 1, LOGpcode = 4, context 2, prevpageLSN20:16:391)

Anybody got any ideas.

 

[mrdenny]

Without a valid backup you won't be able to restore the logs. To be able to use the logs from 3/29/07 to current you would have to have the full backup from 3/29/07 as well.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[idd]

Hi There fortunately are baclup team managed to salvage a proper backup of the server from the night before,

That was just lucky, note to all who read this thread, make sure you have backups of all systems and databases.

Thats my first task, take backups of all individual databases and then put a new maintenance plan in place.

Idd