none
Convertto-SPProjectDatabase Database in use RRS feed

  • Question

  • Convertto-SPProjectDatabase : Database validation failed. Reason:
    DatabaseInUse.
    At line:1 char:1
    + Convertto-SPProjectDatabase -WebApplication http://pmsite.myurl.net
    -Dbserver d ...
    Tuesday, December 2, 2014 7:04 AM

All replies

  • Check SQL server and make sure that your account and the farm admin account has access to the project databases.

    CHeers!


    Michael Wharton, MVP, MBA, PMP, MCT, MCTS, MCSD, MCSE+I, MCDBA
    Website http://www.WhartonComputer.com
    Blog http://MyProjectExpert.com contains my field notes and SQL queries

    Tuesday, December 2, 2014 6:32 PM
    Moderator
  • Check my answer at the bottom of my thread...

    this might be a little late - but I went through the error several times -

    Update: Success!!!

    It seems the solution to the DatabaseInUse error (show below) is to use a different database name.  I had used the same database name several times.  When I tried to use a different database name on the ConvertTo-SpProjectDatabase command - I got the Are you sure you want to perform this.


    Convertto-SPProjectDatabase : Database validation failed. Reason:
     DatabaseInUse.
     At line:1 char:1
     + Convertto-SPProjectDatabase -WebApplication http://mynew2013pwa
     -Dbserver d ...


    https://social.technet.microsoft.com/Forums/projectserver/en-US/1b0f2c43-4000-435f-81ad-084c80f2e78c/moving-data-to-a-project-content-database?forum=projectserver2010general






    • Edited by kbwrecker Thursday, December 4, 2014 11:01 PM
    Thursday, December 4, 2014 10:57 PM
  • Really, changing the name of ProjectServiceDBName did work ! I had removed the old ProjectServiceDBName before doing this, but it seemed to be registered somewhere and even restarting the DB server didn't get rid of it. So we have to change it to another new name !

    Thank you for posting it. It helped me after a lot of time struggling to understand why it kept complaining Database is in use whole 4 of the restored files are new.

    Monday, April 20, 2015 9:28 PM
  • You're welcome - glad my pain saved someone else from going through the same thing for a long time
    Wednesday, June 17, 2015 12:57 PM