I have a SQL 2005 database server which has about 20 user databases which total upto 1 TB.We have nightly backups and they go onto the tape eventually everyday.
In case this server crashes what are my options beside restoring from the backups.
someone mentioned Warm Standby Server, is it a feasible solution? pros and cons? basically we want to reduce the down time.