SQL Server Performance

Can't delete logshipped db

Discussion in 'SQL Server 2005 Log Shipping' started by WingSzeto, May 4, 2007.

  1. WingSzeto Member

    I am using SQL 2K5 standard sp2.

    I am testing the logshipping between server A and B and make the logshipped db in server B as a standby. It is working. I disable the logshipping from server A and like to redo the setup one more time to get a good handle on all the steps.

    After the disable of log shipping of the db, all related jobs are removed, which is expected. On the server B, the logshipped database status is changed to 'restoring'. I tried to delete that database, restore on top of it and both time it said, dataase is in use. I check the actvitiy monitor and the db is not in use. Logshipping is not working because the db status is in use but I can't see why it is. Any help is very much appreciated.

    wingman
  2. satya Moderator

    http://msdn2.microsoft.com/en-us/library/ms189071.aspx

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

Share This Page