Post reply

how to remove/delete standy by database on secondary instance?

  • July 31, 2012 at 2:43 pm

    #278766

    I was doing Log shipping and something went wrote now I want to start all over. How to delete restored database (standby/read only) on secondary instance?

  • July 31, 2012 at 3:20 pm

    #1519996

    You can drop the database. or just restore over it with your new full database you are using as a starting point.

    ---------------------------------------------------------------------

  • August 1, 2012 at 11:22 am

    #1520422

    Don't forget to remove any log shipping work done to this point:

    How to: Remove a Secondary Database (Transact-SQL) - SQL Server 2005

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • August 1, 2012 at 11:25 am

    #1520424

    thank you

  • August 13, 2012 at 3:53 am

    #1524973

    note - if all you want to do is re-initialise log shipping from a new full backup you don't need to remove and recreate the log shipping jobs, the existing ones can still be used.

    ---------------------------------------------------------------------

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply