SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 High Availability (2005)
 SQL 2K5 log shipping
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

kdubb777
Starting Member

24 Posts

Posted - 07/19/2007 :  17:59:04  Show Profile  Reply with Quote
I have a customer that has 52 user db's and wants log shipping. Has anyone scripted log shipping in 2k5? I know it was not supported in 2000.

tkizer
Almighty SQL Goddess

USA
37466 Posts

Posted - 07/19/2007 :  18:00:16  Show Profile  Visit tkizer's Homepage  Reply with Quote
Log shipping is available in 2005, but you should use database mirroring instead if you don't require sending the logs to two servers. Database Mirroring is so much easier, is easily scripted, and failovers are very easy and fast.

We use log shipping for our 2000 databases only. All of our prod 2005 databases are mirrored.

Tara Kizer
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

kdubb777
Starting Member

24 Posts

Posted - 07/19/2007 :  18:05:21  Show Profile  Reply with Quote
I don't have another server for the witness and they can't loose any data.
quote:
Originally posted by tkizer

Log shipping is available in 2005, but you should use database mirroring instead if you don't require sending the logs to two servers. Database Mirroring is so much easier, is easily scripted, and failovers are very easy and fast.

We use log shipping for our 2000 databases only. All of our prod 2005 databases are mirrored.

Tara Kizer
http://weblogs.sqlteam.com/tarad/

Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37466 Posts

Posted - 07/19/2007 :  18:10:27  Show Profile  Visit tkizer's Homepage  Reply with Quote
You don't need a witness.

We use asynchronous database mirroring without a witness.

We'd lose less data with database mirroring than we would with log shipping in the case of a disaster. Even asynchronous database mirroring isn't as far behind as log shipping.

Tara Kizer
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

rmiao
Flowing Fount of Yak Knowledge

USA
7266 Posts

Posted - 07/20/2007 :  10:42:04  Show Profile  Reply with Quote
If really need witness, you can install an express instance somewhere on your network.
Go to Top of Page

mohit_sme
Starting Member

USA
13 Posts

Posted - 08/23/2007 :  16:58:16  Show Profile  Visit mohit_sme's Homepage  Send mohit_sme a Yahoo! Message  Reply with Quote
It depends on the business requirement, so sometime Log Shipping could be more beneficial than DB Mirroring.

Like putting data onto multiple servers is a classic example, and again people have implemented log shipping (SQL Server 2000) in various different ways because of it's conceptual flexibility.

Read this for more details....

http://mohitnayyar.blogspot.com/2007/08/microsoft-sql-server-2005-high.html


Thanks
Mohit Nayyar
http://mohitnayyar.blogspot.com
Go to Top of Page

Christineshc
Starting Member

Angola
1 Posts

Posted - 04/22/2013 :  01:08:47  Show Profile  Reply with Quote
unspammed
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000