0 Replies Latest reply on Sep 12, 2011 9:21 PM by TK45

    Fail to restore SQL Database on SSMSE 2005.




      Somehow, when I restored ePO database by SSMSE 2005, following error comes.



      System.Data.SqlClient.SqlError: RESTORE cannot process database 'ePO4_YK2K3' because it is in use by this session.

      It is recommended that the master database be used when performing this operation. (Microsoft.SqlServer.Express.Smo)


      "ePO4_YK2K3" is my database name.

      The error comes only when I logon by windows Administrator user.

      Even if I enable "Overwrite the existing database" option, the error comes still.

      However, if I logon by "sa" user with SQL authentication, it is possible to restore the database without error... somoehow...


      Do anyone know why the error comes onky when I logon by windows Administrator?

      Is it a specification of SSMSE?