• Looks like you dealt with fairly smaller databases. The same scenario could have been worse, if the databases are of size, say 10 GB (in terms of restore times). Logshipping would have saved a lot of time in this case!


    HTH,
    Vyas
    SQL Server MVP
    http://vyaskn.tripod.com/