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

Switching "warm" server to active

I’m currently testing SQL Backup Pro under the 14 day trial period on two SQL 2000 standard servers. I’ve been able to successfully use the log-shipping functionality. However, I have one problem I have been unable to resolve:

How do I change the status of the destination database from loading to being on-line and accessible? I understand that I can apply the last known good backup and change the option during a restore to “leave database operationalâ€. However, if this were a real-world scenario and the primary server suffered a major hardware failure, the last transaction log backup may have already been shipped to the backup server and would have been applied with the “non-operational†option. In this case, with no more transaction log backups to apply, how do I make the database on the secondary server accessible?
summerm
0

Comments

3 comments

Sort by
  • petey
    Run the following:

    RESTORE DATABASE <database name> WITH RECOVERY
    petey
    0
  • summerm
    petey wrote:
    Run the following:

    RESTORE DATABASE <database name> WITH RECOVERY

    Thanks for the reply.

    Will this statement restore the entire database again, or will it just switch the mode from standby to live?
    summerm
    0
  • Jason Cook
    The command Peter provided will change the database from the "loading" state to the "live" state without any subsequent restores - the database will be made available (and start processing requests) in the state the log shipping wizard left it.

    Jason
    Jason Cook
    0

Add comment

Please sign in to leave a comment.