Dear all Morning .

  • Am Using SQL 2008

    while restoring the database am getting an error like Database is in Use

    Regards
    Chowdary...

  • That's because there is an active connection to the database. You need to make sure that there aren't any connections before you restore a database

    -------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
    There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
    I would never join a club that would allow me as a member - Groucho Marx

  • As mention by Stuart you need to kill the connections for required database. If database is in use; you can't perfrom restore operation.

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

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

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