I have an issue with my logship server (SQL 2000). I logship every 10 mins from production to backup server, all has been working fine, until today when a network issue caused a logfile which i use to restore was corrupted.
I need to make the Logship DB Live to retrieve some data
I run "RESTORE DATABASE CLIENT_A WITH NO RECOVERY"
but i get the following error message.
File 'log_file1' was partially restored by a database or file restore. The entire file must be successfully restored before applying the log.
Is there anyway i can bring the DB back to Life. Please i would really appreciate any help on this issue.
January 18, 2011 10:41 AM
January 19, 2011 10:35 AM