Hi All, Can some one specify some useful links for setting up log shipping in SQL 2005? Thanks in advance! Regards, Herbert R.
hi friend, pls refer http://deepakinsql.blogspot.com/2007/06/how-to-configure-log-shipping-in-sql.html http://msdn2.microsoft.com/en-us/library/ms178117.aspx ---Role change in sql 2005 http://msdn2.microsoft.com/en-us/library/ms191233.aspx ---Fail over in log shipping Regards Deepak SQL DBA
What is the problem in finding the same in the books online for SQL 2005, there are many in this site too:http://www.sql-server-performance.com/articles_clustering_log_shipping.asp Satya SKJ Microsoft SQL Server MVP Writer, Contributing Editor & Moderator http://www.SQL-Server-Performance.Com This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
Check the following blog... http://msmvps.com/blogs/omar/archiv...Ship-on-large-database-that-really-works.aspx MohammedU. Microsoft SQL Server MVP Moderator SQL-Server-Performance.com All postings are provided “AS IS†with no warranties for accuracy.
SQL 2000 log shipping still works with SQL 2005, in addition to that link you can refer to books online too. Satya SKJ Microsoft SQL Server MVP Writer, Contributing Editor & Moderator http://www.SQL-Server-Performance.Com @http://www.askasqlguru.com/ This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
have a look at brad'a article also very usefull http://www.sql-server-performance.com/sql_server_log_shipping.asp AKTHAR