Backup data and restore RRS feed

  • Question

  • Dear All,

    how i can restore data from other database to another in same server.

    i just do this:

    right click on database -> task -> restore -> database

    after that i choose destination of database and source of database and i click option to overwrite destination.

    but i got error: Restore cannot be process database because it is in use by this session.

    how i can solve that problem?

    help please.

    best regards,


    Friday, August 22, 2014 7:23 AM


  • Hello Surbakti,

    Before you can restore a backup all Connections to the database, which you want to restore, have to be closed, also your own Connections.

    If you are using SSMS 2012, there is on the last tab an Option to force closing all Connections.

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Friday, August 22, 2014 7:36 AM