log shipping

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

BillE - 26 Jun 2008 18:24 GMT

SQL server 2000 log shipping was working fine. All service packs
up-to-date.

Suddenly, my standby database decided it was "loading/suspect".

I removed all log shipping, but I couldn't do anything with the standby. I
couldn't even delete it, until i realized i had to uncheck the checkbox to
delete the backup and restore history.

Now that I've deleted it, i can't restore a database with standby with the
same name! It seems to hang indefinitely, with no error.

How can I create a new database with the same name? Why is it not letting
me?

Reply to this Message

Hilary Cotter - 27 Jun 2008 13:37 GMT

You should have tried a alter database ProblemDatabaseName with recovery.

This might have cleared the loading status.

I am wondering if perhaps the old database files are hanging around and this
is what is causing the problem. Perhaps run profiler can capture SQL
statement starting/statement completed and add the Error events.

Hilary

> SQL server 2000 log shipping was working fine. All service packs
> up-to-date.
[quoted text clipped - 10 lines]
> How can I create a new database with the same name? Why is it not letting
> me?

Reply to this Message