I spent several hours to figure out how to backup a mssql-server with linux. It wasn’t easy but I found a nice solution.
Yes Microsofts SQL-Server – I’m managing a page which uses asp.net and mssql, so I needed a solution to backup the complete server and database from the commandline.
I found a PHP script which does most of the job. The script needs php-mssql extension, so install it with:
sudo apt-get install php5-mssql
If you want to query the MS-SQL-Server from the commandline, use tsql (from freetds), install it with
sudo apt-get install freetds-bin freetds-common
Now download my modified script from here (php_mssql_backup.php)
This script is basically from http://www.php-trivandrum.org/code-snippets/php-mssql-backup/ I just modified the code for a couple of data-types in ms-sql-server 2008.
Open the script and insert your cretentials (host,user,pass,db) at the bottom of the script.
Then execute the script on the commandline:
php5 php_mssql_backup.php ./output.sql
That’s it, feel free to copy or modify the script. Feedback is also welcome!