How to migrate ms sql database?

[Allis]

Hi,

How to go about migrating an existing ms sql database from Plesk to Plesk?

Thanks

 

[luciano]

Migrating

Hello!

So that you can migrate your SQL Server database you can do this:

1. Detach database in your old server.
2. Create a clear database, in your new plesk server, with the same name and user holes.
3. Upload database's LDF and MDF files of old database from the old server to the new server.
4. Detach your clear new database.
5. Atach your database using the MDF and LDF files you uploaded.

Hope it helps.

Luciano Greiner

 

[MolenoM]

It's approx 10 years old reply . So I am little worried whether it's still true or not .

I have migrated one account from one plesk server to another but database missed & now I want to migrate it manually . What to do ?