• I have scripted the backup and restore from one server to another. We use native SQL for the backup and for the restore. I restore from a file on the disk on one server to a different server and this is done on a nightly basis - immediately following the backup of said database.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events