1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

MSSQL: Add existing DB to Plesk

Discussion in 'Plesk for Windows - 8.x and Older' started by sdm-cs, Jan 9, 2006.

  1. sdm-cs

    sdm-cs Guest

    0
     
    Hi all,

    I've been using Plesk 7.5 for Windows for a few months now, it's been great! However I now have the following problem, I really hope you can help me! :)

    One of our developers migrated one of our busiest web sites onto our Plesk web server but did not create the MSSQL database through Plesk, instead he just loaded a backup directly into Enterprise Manager which means Plesk doesn't have a clue it exists. I've tried creating it through Plesk web admin and it fails each time because the database already exists within MSSQL.

    I think that reads Ok, so if you have any idea how I get this database recognised by Plesk, that would be smashing, thanks!
     
  2. sergius

    sergius Golden Pleskian

    28
    57%
    Joined:
    Nov 6, 2005
    Messages:
    1,898
    Likes Received:
    0
    before create domains via Plesk and then restore databases over
     
  3. sdm-cs

    sdm-cs Guest

    0
     
    I actually tried the following shortly after posting this (it worked!):
    • Detached the database in Enterprise Manager
    • Renamed the two files in the MSSQL data folder
    • Created the database in Plesk web admin
    • Detached the new database created by Plesk in Enterprise Manager
    • Removed those files from the MSSQL data folder
    • Named the original data files back to their original name
    • Attached the files to the database in Enterprise Manager
    • Created a user account for this database within Plesk web admin
    I think that's all I did, and it seems to be running fine now.

    Thanks! :)
     
Loading...