How can we help you today? How can we help you today?

automatic switchover

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.
vad2319
0

Comments

2 comments

Sort by
  • vad2319
    Just to add, I am looking for a failover solution.
    vad2319
    0
  • petey
    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.
    petey
    0

Add comment

Please sign in to leave a comment.