how to take data backup from hosted sql server ??

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 :)

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sanjeeb Lenka13y ago
Hi,

Refer to this link

http://www.c-sharpcorner.com/UploadFile/b19d5a/generate-database-script-with-table-data-from-sql-server-2008/
0
Sunny Sharma13y ago
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 :)
0