SQL Server 2008 R2 Management Studio
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?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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:
https://www.experts-exchange.com/questions/24825829/Moving-DotNetNuke-from-one-hoster-to-another.html).
Is there any disadvantage to working with a backup?
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:
https://www.experts-exchange.com/questions/24825829/Moving-DotNetNuke-from-one-hoster-to-another.html).
Is there any disadvantage to working with a backup?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you, Banthor, Zberteoc and Mohit.
ASKER
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.