Home > IT Answers > SQL Server > SQL Server 2000 Log Shipping
KH
155 pts.
 SQL Server 2000 Log Shipping
Log Shipping, Log Shipping failure, SQL 2000, SQL Server 2000, SQL Server 2000 Log Shipping
Hi

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.

Thanks

 

 



Software/Hardware used:
SQL 2000
ASKED: January 18, 2011  10:41 AM
UPDATED: January 19, 2011  10:35 AM
RELATED QUESTIONS
Answer Wiki:
If you are using the default log shipping that comes with SQL Server 2000, then the log files should be kept on both servers hard drive. Just copy the file from the production server to the backup server. You have to finish the current log file before you can bring the server back online. If you were only using a single file and you don't have a copy of it on the active server, you'll need to start the log shipping over.
Last Wiki Answer Submitted:  January 19, 2011  5:24 am  by  Subhendu Sen   22,035 pts.
All Answer Wiki Contributors:  Subhendu Sen   22,035 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Thank you for your reply

How could i restore the current logshipped DB if i cant access the original source for some reason. is there noway of undoing the last log restore that was partially restored.

Thanks

KH
 155 pts.
 

I am using SQL server 2000 and my logship file is always overwritten each time it logships.

KH
 155 pts.
 

U can undo log shipping thru database maintenance plan. But remember, it is not possible to delete the maintenance plan that was already used for log shipping until and unless u remove log shipping.

Subhendu Sen
 22,035 pts.
 

Thanks Mr Denny

The conclusion we have come to is my logship DB is not of any use i cant bring it back as it stands because i use a single file which gets copied from LIVE server to backup server. Hopefully will be moving to SQL 2008 this year and we wont have these problems.

KH
 155 pts.