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.
| 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 Kizerhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
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 Kizerhttp://weblogs.sqlteam.com/tarad/
|
|
|
|
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 Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
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. |
|
|
|
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.htmlThanksMohit Nayyarhttp://mohitnayyar.blogspot.com |
|
|
|
Christineshc
Starting Member
1 Post |
Posted - 2013-04-22 : 01:08:47
|
| unspammed |
|
|
|
|
|
|
SQL 2K5 log shipping