• jasona.work (7/8/2013)


    1. Can I backup a DB that is in an offline state? I'm inclined to think no.

    No, you cannot backup an offline database, however you can copy or move or even delete the raw database files (mdf and ldf).

    jasona.work (7/8/2013)


    2. Can I restore over-top a DB that is in an offline state (using WITH REPLACE)?

    If a database is offline you can restore over the top of it no problem.

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉