Will snapshot of a DB be still working if its source DB is being restored?

  • IN SQL 2005 Enterprise Edition.

  • sunny Brook (12/31/2008)


    IN SQL 2005 Enterprise Edition.

    post more info what about your snapshot!!! :hehe:

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • Restore will fail if there is a snapshot associated with the DB.


    * Noel

  • sunny Brook (12/31/2008)


    IN SQL 2005 Enterprise Edition.

    U can not restore database bec database is an use by snapshot.

    _____________________________________________________________________________________________________________
    Paresh Prajapati
    ➡ +919924626601
    http://paresh-sqldba.blogspot.com/[/url]
    LinkedIn | Tweet Me | FaceBook | Brijj

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

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