How to backup MS SQL Server

[ghostgo]

Hi, i am not a very good programmer and i have a MS SQL server database with my hosting with godaddy.
Can someone please tell me how to backup my sql database.

I do not see this option in the control panel online...is there a query or something...i'm very weak when it comes to databases.

Thanks

[shartken]

If you use PHP MYAdmin, you can hit a backup link that will print out the SQL code needed to backup your db.

If you are using the MySQL CC, or just accessing it from a command line, the easiest way is to import the tables into an MSAccess database.

Look for a MySQL ODBC. With that, you can set up a connection to your MySQL database. Then you can import the data into your Access db.

There are others ways to do it. The most popular is with a program called Putty but you need a Shell password to your server and most hosts don't support that.

[rcvalencia9]

Is MS SQL Server Enterprise Manager Installed in your PC? Open it. Expand The necessary User Name then Expand Databases. Then Right Click The Database. Then Select Backup. It will ask you what tables/queries to backup and the destination. You can select 3 different Backup Types. Full/Differential. I forgot the other one.

You can also do this using Query Analyzer. But harder.

[hannah]

I remember this online storage service which has the ability to execute backups of MS SQL Server databases without interrupting your existing processes. We have used this service, the backup process is stable, fast and reliable to handle GB’s of data.

The detailed procedure to backup your SQL databases is clearly mentioned with screen images in their product website.