Hi I have an issue with my logship server (SQL 2000). I logship every 10 mins from production to backup server, all has been working fine, until today when a network issue caused a logfile which i use to restore was corrupted. I need to make the Logship DB Live to retrieve some data I run “RESTORE [...]
Answer Question | January 19, 2011 10:41 AM
Log Shipping, Log Shipping failure, SQL 2000, SQL Server 2000, SQL Server 2000 Log Shipping
I have setup log shipping on our production SQLServer to send the logs to a server I have at my home for a warm backup solution. The process seemed to work but then I had a problem on my secondary server – it seemd to stop working for a period of 2 weeks (I dont [...]
Answer Question | August 2, 2010 9:27 PM
Log Shipping, SQL Server 2000 Log Shipping, SQL Server 2005, SQL Server log shipping
We are using log shipping on our SQL Server as our disaster recovery solution. When we want to test our disaster recovey with a test transaction, not production, we need to use the secondary copy. However, we don’t want to stop it and lose consistency between disaster recovery and the production copy. How can we [...]
Answer Question | March 6, 2009 4:56 PM
Disaster Recovery, Disaster recovery (DR) testing, Disaster Recovery Database, Disaster recovery planning, Log Shipping, SQL Server, SQL Server databases
I’m using log shipping for my DR. When I want to test my DR, I need to access my DR database and do my tests (and modify it). My problem is I don’t want to stop my log shipping and lose integrity between my prod DB and DR DB. I’m looking for a solution to [...]
Answer Question | March 4, 2009 3:00 PM
Data Recovery, Log Shipping
Every time I restore one of my SQL Server 2005 databases to a point in time, my log shipping restore job fails on my secondary server. Any ideas on how to correct this?
Answer Question | December 20, 2008 7:41 PM
Log Shipping, SQL Server 2005, SQL Server database
I’ve upgraded our warm backup to SQL Server 2005 recently, but our log shipping is down. How can SQL Server 2005 be used with SQL Server 2000 log shipping?
Answer Question | November 11, 2008 7:06 PM
Log Shipping, SQL Server 2000, SQL Server 2000 Log Shipping, SQL Server 2000 to SQL Server 2005 migration, SQL Server 2000 to SQL Server 2005 upgrade, SQL Server 2005, SQL Server upgrades
What are the pros and cons for log shipping vs. replication in SQL Server? When is one favored over the other?
Answer Question | May 2, 2008 5:21 PM
Log Shipping, SQL Server availability, SQL Server replication
We were going to use log shipping from a cluster back to a dr site in a different city. Our network Operations folks want us to use a product called DoubleTake for MS SQL 2005. Anyone had any experience or insight with this. Log shipping has worked for us for 8 years, and if I [...]
Answer Question | March 24, 2008 2:35 PM
Disaster Recovery, Double-Take Software, Log Shipping, SQL Server 2005