Results 1 to 3 of 3
  1. #1

    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

  2. #2
    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

  3. #3
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •