Solved

SQL Server 2008 R2 Management Studio

Posted on 2013-10-26
7
958 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
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
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

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Join & Write a Comment

Suggested Solutions

In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

744 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now