Ok, this is a bit tricky and manual, but here are the steps which you can follow in case you have installed the same mssql server version and then trying to attach your old mdf ldf so that you can run the server with same db status as was there in mdf ldf files in your hand.

Create same named db in MSSQL - we will recommend create them via Plesk Panel only so everything in within Plesk

Now locate your mssql data folder where it creates those mdf ldf files as in name of the database you just created and pick those newly created db's mdf and ldf file names from there.

Now locate your old mssql data folder where the old mssql data backup of mdf ldf file is there and locate similar looking file name of that old db and have those old mdf ldf == new mdf ldf which you just recorded in step 2 above.

Now stop the mssql server for a while and copy those mdf ldf from old sql data folder to new current sql data folder and overwrite the files of newly created db with this same named mdf ldf file.

Now start back the mssql server. Now if you face any error it can be mismatch of SQL server version so mdf ldf may only work if your old mssql version xxx.xxxx and the new version xxx.xxxxx is exact same.

Once done for one database, the same step needs to be done for other dbs in the same way.

If you have a managed server then create all required dbs with same old name in plesk panel and update our team and our team can help you with this above mentioned manual process but their role only comes when you create the same named empty db via plesk panel atleast and inform them for the help of mdf ldf migration to new sql data folder as mentioned in this article.
Was this article helpful?
Cancel
Thank you!