Log Shipping Questions

[Bell1991]

I have set up log shipping. I need to restore our master database from a different environment. Once i do this, do i need to do an new initialize?

 

[mrdenny]

I would think that you probably would as the database wouldn't be attached any more, and I'm pretty sure that you won't be able to attach it without putting it into read/write mode.

You can try, but I would assume that a re-init will be needed.

What's the cause of the master database restore?

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog

 

[Bell1991]

Perhaps, i need to be more clear.


The database i am log shipping is called "MyDatabase" on database A. It is set up to log ship to database B.

I need to still be able to perform full database backups on Mydatabase on database A. The application that uses it is not the best and allows deletion of data. I need to be able to restore the database (as a new name) to recover data when needed.

 

[mrdenny]

As long as you are able to backup the database and getting the missing records loaded into the product table on the subscriber you should be fine. Just make sure to do regular full and transaction log backups.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog