SQL Server Performance Forum – Threads Archive

Log shipping in SQL 2005

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.

Sathya,
The links u provided were for SQL 2000 i believe……just check it Regards
Deepak
SQL DBA

Even i have searched and didn’t find any articles on SQL2005 Logshipping in the link above. Sagar

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.

http://msdn2.microsoft.com/en-us/library/ms188698.aspx AKTHAR

have a look at brad’a article also very usefull
http://www.sql-server-performance.com/sql_server_log_shipping.asp AKTHAR

]]>