Restoring over an offline database

  • Good Morning Experts,

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

  • coolchaitu - Monday, August 13, 2018 8:43 AM

    Good Morning Experts,

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

    If you are going to replace the DB, why not just drop it first?
    😎

  • coolchaitu - Monday, August 13, 2018 8:43 AM

    Good Morning Experts,

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

    I've no idea. Try it with a test database.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply