How to import MS SQL on plesk.

[tong c]

I have an existing MSSQL database, I want to import this database to plesk. I know the Mysql database can via phpmyadmin tool, "import" . but the is no " import" or similar button on the Asp.Net Enterprise Manager(webadmin)。 Anyone can provide solutions? i will appreciate you!!!!!

 

[IgorG]

https://manage.grabweb.net/knowledgebase.php?action=displayarticle&id=459

 

[tong c]

https://manage.grabweb.net/knowledgebase.php?action=displayarticle&id=459

oh, millions of thanks。you are so helpful

 

[ederrafo]

hello IgorG,
what are the steps to export data,
I do not find those options in my parallels plesk control panel
thanks

 

[AStorch]

https://manage.grabweb.net/knowledgebase.php?action=displayarticle&id=459

Hi I tried this but I got:



Error: dbbackup failed: Unable to restore database 'bevrecords'
Not valid backup
The media family on device 'C:\Windows\TEMP\localhost\bevrecords\BevRecsCatalog.2010-05-25.mdb' is incorrectly formed. SQL Server cannot process this media family.
VERIFY DATABASE is terminating abnormally.


Any thoughts?

 

[AStorch]

https://manage.grabweb.net/knowledgebase.php?action=displayarticle&id=459

Hi I tried this but I got:



Error: dbbackup failed: Unable to restore database 'bevrecords'
Not valid backup
The media family on device 'C:\Windows\TEMP\localhost\bevrecords\BevRecsCatalog.2010-05-25.mdb' is incorrectly formed. SQL Server cannot process this media family.
VERIFY DATABASE is terminating abnormally.


Any thoughts?