delete the databse

how can i delete the database if it is in loading state?

any helpHi there,

Which version of SQL are you working on? SQL 2000/2005 ? Detach the database first before deleting it. Hope it helps, good luck & take care.

Quote:

Originally Posted by bharadwaj

how can i delete the database if it is in loading state?

any help

|||Hi sashi,

we r usinq sql2000. logshipping is going on.we have remove the logshipping recently.that time we have done some mistake.now when we try to re-configure logshipping,we found that the database is there in secondary server (with loading state).

I have checked the following things.
1.attach\detach database.
2.take offline for that database
3. restore database with recovery.
4.sp_dbremove replication...
every time i was getting the error like the database is in use.
i have checked the msdb logshipping tables also.but no clue

any advice from ur side.
regards
Bharat