What are the challenges you face when working across database platforms? Take the survey

automatic switchover

vad2319vad2319 Posts: 40
edited April 1, 2008 8:13PM in SQL Backup Previous Versions
The logshipping process works great.

Would it be possible to automatically recover the database at the DR site without my involvement?

I know I could write the sql command "RESTORE DATABASE", but can we recover it automatically? something like a switchover?

Thanks in advance.


  • Options
    Just to add, I am looking for a failover solution.
  • Options
    peteypetey Posts: 2,358 New member
    There isn't a built-in function to automatically perform the failover.

    Log shipping's main feature would be protection of data from local disaster. Database mirroring would be more suited to quick failover requirements, if you are using SQL 2005.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
Sign In or Register to comment.