Results 1 to 3 of 3
Thread: Plesk 8.2 and MS SQL
-
08-16-2007, 02:11 AM #1Web Hosting Master
- Join Date
- Feb 2004
- Posts
- 2,197
Plesk 8.2 and MS SQL
I have been doing a bit of testing of MS SQL on Plesk, and I have a local database (MS SQL Standard 2005) and I can make a create script which references MDF files. However I'm not sure how I would import this into MS SQL? Whats the best way to export data from MS SQL and then import to a new server?
Version of MS SQL: Express 2005
Version of Plesk: 8.2
-
08-16-2007, 02:27 AM #2Junior Guru Wannabe
- Join Date
- Jun 2007
- Posts
- 30
Hi There,
You need to connect to MS SQL: Express 2005 (MSSQL server runnning on the old server) from the Enterprise manager installed in the new server. Once connected, backup the database you need to restore in the new server.
Once the needed backups are taken, you can restore in the local MSSQL server using the Enterprise Manager.Maestria Information Systems Pvt. Ltd.
Email: reachus@maestriatech.com
MSN : maestriatech@hotmail.com
-
08-16-2007, 02:37 AM #3Web Hosting Master
- Join Date
- Feb 2004
- Posts
- 2,197
Yep, I know backups and restorations need to be done, how exactly should this be done and in what format?
BTW, the old server is running MS SQL 2005 Standard, new one is running express.