Home Forums SQL Server 2005 Administering Miracle happened with my 2 database test server databases... RE: Miracle happened with my 2 database test server databases...

  • When you created the log shipping, it created the database(s) on the second server, and starting the log shipping to them.

    When you deleted the log shipping, all you deleted was the physical act of shipping/recovering the transaction logs. The database(s) on the second server are still there. (You might find that they are in a norecovery or standby state).

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes


    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2