SQL Server 2000 Log Shipping

155 pts.
Tags:
Log Shipping
Microsoft SQL Server 2000
SQL 2000
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

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 5  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • KH
    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
    155 pointsBadges:
    report
  • KH
    I am using SQL server 2000 and my logship file is always overwritten each time it logships.
    155 pointsBadges:
    report
  • Subhendu Sen
    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.
    29,780 pointsBadges:
    report
  • KH
    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.
    155 pointsBadges:
    report
  • KH
    [...] 8. Mrdenny and Rechil gave some handy tips regarding SQL Server 2000 log shipping. [...]
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following