posted on Sunday, March 12, 2006 6:20 PM by ACALVETT

SQL 2005 - Log Shipping Monitoring?

My blog has moved to: http://sqlblogcasts.com/blogs/acalvett/

The full version of this post can be found here.

I took a look at log shipping in 2005 for the first time the other day and as i was curious to see how the monitor functionality had been implemented in SQL Server Management Studio i went hunting for it. I've got to say i was greeted with nothing but disappointment and left feeling that i now have a huge mountain to climb before it can be used in production......................!

To read the complete version of this post go to here.

Comments

# re: SQL 2005 - Log Shipping Monitoring? @ Tuesday, March 14, 2006 6:57 PM

Argh! I too, have about 14 or 15 databases currently log shipping. I have not had time to get to researching so I am glad you did, at least. I am disappointed, but thanks for the heads up, in any case.

--Greg

G. Milner

# re: SQL 2005 - Log Shipping Monitoring? @ Friday, May 19, 2006 7:28 PM

Yes, Log-shipping in SQL Server 2K5 really sucks compared to SQL server 2000, it took me long time to set it up (with various strange access errors). I consider myself an expert in LS as I have been using LS in SQL 2000 for more than 2 years.
Is this because MS does not want us to use LS any more and use mirroring instead?

jeffrey yao