Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 High Availability (2005)
 SQL 2K5 log shipping

Author  Topic 

kdubb777
Starting Member

24 Posts

Posted - 2007-07-19 : 17:59:04
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

38200 Posts

Posted - 2007-07-19 : 18:00:16
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 - 2007-07-19 : 18:05:21
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

38200 Posts

Posted - 2007-07-19 : 18:10:27
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
Master Smack Fu Yak Hacker

7266 Posts

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

mohit_sme
Starting Member

13 Posts

Posted - 2007-08-23 : 16:58:16
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

1 Post

Posted - 2013-04-22 : 01:08:47
unspammed
Go to Top of Page
   

- Advertisement -