i need to download my database files from my hosting account. it doesn't have a export option. It is MS SQL database. After that i want to import in MS Sql server 2008.
Hello himanshuon, If you create a ticket requesting your database back up as a compressed download file, they will surely provide it to placing it on a folder that you can reach using your FTP account.
first contact your technical support and take your server details. Then go your database back up and download ms sql database file.
Most of the time you will find import/export option under phpmyadmin (its a 3rd party script and most of the hosting companies use it) You can find the link to phpmyadmin under your hosting account control panel (if you are already in phpmyadmin and sill can't find any export option then its either a restriction or a bug and you need to raise a support ticket to get help Hope it helps
You can use MSSQL Managment Studio using which you can backup your database, else your webhost should provide you a copy of required database backup.