July 31, 2012 at 2:43 pm
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
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
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
thank you
August 13, 2012 at 3:53 am
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