I have a production database for which i've lost all backups i had. i recently tried run a delete on some specific records and ended up deleting all records. i made a backup of the whole database and the log. i tried to restore the log using the following script:
RESTORE DATABASE b1
FROM disk='C:\sql\Ba ckup\b1'
WITH NORECOVERY;
GO
RESTORE LOG b1
FROM disk='C:\sql\Ba ckup\b1_log'
WITH RECOVERY ,
STOPAT = 'Feb 10, 2007 12:00 AM';
GO
i checked the database afetr this to see if the rollback was done, but it wasn't.
i still have only the new data inserted after the delete.
i have run the log through sql log explorer and got all the records in there but could not use it because its a demo version.
Pls help cos i need it fast!!
RESTORE DATABASE b1
FROM disk='C:\sql\Ba ckup\b1'
WITH NORECOVERY;
GO
RESTORE LOG b1
FROM disk='C:\sql\Ba ckup\b1_log'
WITH RECOVERY ,
STOPAT = 'Feb 10, 2007 12:00 AM';
GO
i checked the database afetr this to see if the rollback was done, but it wasn't.
i still have only the new data inserted after the delete.
i have run the log through sql log explorer and got all the records in there but could not use it because its a demo version.
Pls help cos i need it fast!!