Restoring a backup of an existing DB to a new name on the same server and getting exclusive lock error

  • I am attempting to restore a version of my current database ("JamestonDB") to a new name ("JamestonDB0628"). I have been successfull restoring other databases but this one is giving me "cannot obtain exclusive lock error". This database is more heavily used, but since I am creating a "new" database I do not understand the error.

    <><
    Livin' down on the cube farm. Left, left, then a right.

  • Not sure why, but it appeared that this backup wanted to do a "Tail log" backup. Turned that off and it restored fine. (or at least like I needed it).

    <><
    Livin' down on the cube farm. Left, left, then a right.

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

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