Log shipping in sql server 2008?

Question

Any chances in log shipping in sql server 2008 compare with sql server 2005?

Answer 1

They are pretty well identical with the exception that you can do database and log backup compression in SQL Server 2008 EE, and SQL Server 2008 R2 SE, and EE.

---

looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941

Answer 2

refer the following

Availability Enhancements with SQL Server 2008

---------------
Thanks,Suhas V

 

Answer 3

A couple more points - log shipping now works with replication and full-text search. So if you have a full-text database and you log ship it you no longer have to rebuild the catalogs when you failover. With replication and a remote distributor you can set up a mirroring or log shipping on your publisher so on failover you will not have to reinitialize your subscriptions.

---

looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941

Answer 4

Hello,

In addition to Hilary and Suhas recommendations. I would also recommend you to read the following article Database Backup Compression Feature In SQL Server 2008 to know how to configure and use this feature.

Hope This Helps!

Thanks
Ashish Kumar Mehta

Please click the Mark as Answer button if a post solves your problem and Vote as Helpful if a Post is Helpful!