how to take data backup from hosted sql server ??

Question

hai I want to take sql server backup from hosted server along with data??In local i know how to do this. Regards Divya

Sanjeeb Lenka · Answer

Hi, Refer to this link http://www.c-sharpcorner.com/UploadFile/b19d5a/generate-database-script-with-table-data-from-sql-server-2008/

Sunny Sharma · Answer

Hi divya, This is very same as you do with Local DB. In Microsoft SQL Server Management Studio you can right-click on the database you wish to backup and click Tasks -> Generate Scripts. This pops open a wizard where you can set the following in order to perform a decent backup of your database, even on a remote server: Select the database you wish to backup and hit next, In the options it presents to you, under the Table/View Options, change 'Script Data' and 'Script Indexes' to True and hit next, In the next four windows, hit 'select all' and then next, Choose to script to a new query window Once it's done its thing, you'll have a backup script ready in front of you. Create a new local (or remote) database, and change the first 'USE' statement in the script to use your new database. Save the script in a safe place, and go ahead and run it against your new empty database. This should create you a (nearly) duplicate local database you can then backup as you like. If you have full access to the remote database, you can choose to check 'script all objects' in the wizard's first window and then change the 'Script Database' option to True on the next window. Watch out though, you'll need to perform a full search & replace of the database name in the script to a new database which in this case you won't have to create before running the script. This should create a more accurate duplicate but is sometimes not available due to permissions restrictions. Hope it helps :)

how to take data backup from hosted sql server ??

Answers (2)