Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
udr9245
Starting Member
2 Posts |
 Posted - 2007-06-25 : 16:33:30
|
| Hello Friends:My problem relates to backing up my MS SQL 2005 database which is sitting on a shared server at a hosting company.OVERVIEW:- Hosting company is using MS SQL 2005- I am using the SQL Server Management Studio that comes with SQL Server 2005 Standard (NOT Express), which is installed on MY PC.- So, I am connecting to the SQL server over the internetWHAT I WANT TO ACHIEVE:- I would like to backup the data sitting on the Hosting company's MS SQL Server. I only have one database on this SQL Server. There are of course 100s of other databases on the same server which belong to other customers of the hosting company.- I want to bring the backup to MY PC, from the SQL Server.- As far as I can tell the following options within SQL Server Management Studio may be of help to me. I do not know which one I should use or which one is best or what is the proper method. 1) Select Backup option from the Tasks menu (but it only shows me drives/devices on the Hosting SQL Server, not my PC, so I can’t backup to my PC) 2) Export Data (it does not work, showing errors ‘…not a trusted connection…’ I have no clue what a trusted connection is. 3) Copy Database (which is supposed to copy the remote database on the Hosting company SQL server, to my local SQL Server running on my PC). I go through the wizard, on the last screen it just hangs i.e. shows- not responding)MY QUESTION TO THE COMMUNITY:How do I backup the database sitting on the hosting company SQL server? I of course need to bring the backup to my PC. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-06-25 : 16:38:23
|
| Duplicate, locking thread.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
Backing up MS SQL Server 2005 data