Solved

SQL Server 2008 R2 Management Studio

Posted on 2013-10-26
7
966 Views
Last Modified: 2013-10-30
Can you use SQL Server 2008 R2 Management Studio to connect to a web host's SQL Server 2008 and download the database to a local computer?
0
Comment
Question by:Mark01
7 Comments
 
LVL 10

Assisted Solution

by:Banthor
Banthor earned 125 total points
ID: 39603389
Non sequitur
The SQL Server instance would have to reside on the web server itself and have an exposed port, 1433 is the default port
0
 
LVL 26

Assisted Solution

by:Zberteoc
Zberteoc earned 125 total points
ID: 39603774
Management Studio can connect to any SQL instance that has access to. If the instance is on a different box then that box has to be setup to accept remote connections. Depending where that box resides, local network on same domain, different domain or internet the connection has to be setup accordingly.
0
 

Author Comment

by:Mark01
ID: 39604300
Hi Banthor and Zberteoc,

Can SQL Server 2008 R2 Management Studio be used to copy/download a database to a local
computer? I have SQL Server 2008 R2 installed on my development computer. I need to know if I will encounter any problems when I copy/download a SQL Server 2008 database from a web host to my computer which is running SQL Server 2008 R2.
0
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 
LVL 5

Accepted Solution

by:
MohitPandit earned 250 total points
ID: 39604831
Hello Mark01,

No, you will not face any issue.
You can go ahead to copy backup of database which is in SQL Server 2008 and restore at 2008 R2 OR in case you have .mdf and .ldf files only then you may attach those directly.

Please let me know in case you have any concern.

Best Regards,
Mohit Pandit
0
 

Author Comment

by:Mark01
ID: 39607356
Hi Mohit,

I’m concerned about a 10-20-2009 comment that was made by gnarlysage about working with a backup as compared to working with database files. Do I need to be concerned about this?

Here is gnarlysage’s comment:

the above article is good. In short, you need a copy of all webfiles (the application) and a copy of the database. You can get by with a backup of the database - but if you can get a copy of the actual database files it will be easier.

Here is the EE question from which the above quote came from:
http://www.experts-exchange.com/Programming/Languages/.NET/ASP.NET/Q_24825829.html).

Is there any disadvantage to working with a backup?
0
 
LVL 5

Assisted Solution

by:MohitPandit
MohitPandit earned 250 total points
ID: 39607771
Hi Mark01,

There is no need to worry about it.

I also worked with DNN host and took backup and restore at my local environment.
So, please do not worry to take backup and restore as well.

Apart from this, if you are still skeptical then, please follow below steps as it will be easy for your understanding:

1. Create a rough database with your hosting environment;
2. Create a single table in rough database with 3 records.
3. Take backup of rough database
4. Restore in local environment
5. Verify the table along with 3 records in local environment.

So, in case your rough database does not show any issue then actual production database will also not show any issue.

Please let me know in case you have other thoughts.

Best Regards,
Mohit Pandit
0
 

Author Comment

by:Mark01
ID: 39611974
Thank you, Banthor, Zberteoc and Mohit.
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
I have a large data set and a SSIS package. How can I load this file in multi threading?
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question