Last post Dec 10, 2008 08:59 PM by Gregale.net
Dec 09, 2008 12:27 PM|closeguy2005|LINK
Hi, i want to host my website. One hosting service providing website I came across, requires MS SQL Enterprise Manager to connect SQL SERVER 2005 database . One other site requires to take backup of database.
Is there any hosting service provider site, which does not require MS SQL enterprise manager to transfer database from local computer to server ?
Dec 09, 2008 12:36 PM|Wyerarch|LINK
You should still be able to connect to the server using the SQL Server Management Studio Express
Dec 09, 2008 12:50 PM|closeguy2005|LINK
Don't have SQL server management studio express as well...
what i have is just visual studio 2005 . What should i do in this case?
Dec 09, 2008 02:34 PM|Wyerarch|LINK
If you install SQL Server 2005 Express edition (free) it'll allow you to install SQL Management Express as well.
Dec 09, 2008 09:01 PM|develop9090|LINK
Hi,, Check the host I use at http://www.re-invent.com. They offer a web-based SQL manager for SQL 2005 databases
Dec 09, 2008 09:10 PM|Gregale.net|LINK
it can be downloaded here
Dec 09, 2008 11:55 PM|closeguy2005|LINK
it can be downloaded here
Yes..i downloaded it now .. I downloaded this file SQLServer2005_SSMSEE ( there were 2 files to download..I choosed this one)
Dec 10, 2008 12:16 AM|kilko|LINK
The simplest way to use the Database publishing wizard - right click database in server explorer in Visual studio, click on publish database, follow the steps to generate .sql file of the db schema and data, execute the .sql file on the live server through
web admin and you are through.
Dec 10, 2008 12:37 AM|closeguy2005|LINK
Dec 10, 2008 12:59 AM|kilko|LINK
If you need to backup the database, SQL Management studio will be the best option. If you are not sure how to backup from the UI, you can use the below query to backup the same:
BACKUP DATABASE AdventureWorks
TO DISK = 'C:\Backups\AdventureWorks.BAK'
Dec 10, 2008 03:47 AM|Wyerarch|LINK
Using sql management studio, you can simply right-click on the database, and choose "Tasks" -> "Backup"
Dec 10, 2008 04:13 AM|closeguy2005|LINK
Dec 10, 2008 04:28 AM|Wyerarch|LINK
If you installed SQL Express after visual studio, and you did so after Visual Studio had already installed SQL Express, then you will have two instances of SQL Express running - this is not a problem! However, you will either need to locate the other instance
of SQL, or, open your database into the instance you are connected to.
Firstly, when opening SQL Management, have a look in the drop down box for what servers it can find, it may already see both instances. Secondly, if this does not work, have a look in C:\Program Files\Microsoft SQL Server and see if the are more than one
folder called MSSQL. If there are, you can look inside and see the files (databases, mdf's) that are there. Once you've located it, you can go into SQL Management, right click the server, and choose open database, and do it from the file.
Dec 10, 2008 04:52 AM|closeguy2005|LINK
Dec 10, 2008 05:38 AM|closeguy2005|LINK
Dec 10, 2008 06:11 AM|closeguy2005|LINK
Dec 10, 2008 06:20 AM|Gregale.net|LINK
so you previously didn't attach your database .mdf files? that was why you couldn't see it:)
Dec 10, 2008 07:08 AM|Wyerarch|LINK
If you look through windows explorer as previously suggested, you should have been able to see where the database was stored, and been able to attach it from there, if you were unable to locate your instance names.
Dec 10, 2008 07:13 AM|closeguy2005|LINK
Dec 10, 2008 07:42 AM|Wyerarch|LINK
"If there are, you can look inside and see the files (databases, mdf's) that are there. Once you've located it, you can go into SQL Management, right click the server, and choose open database, and do it from the file."
Dec 10, 2008 12:44 PM|closeguy2005|LINK
Hi, please ignore solution suggested by me ( going to that site & doing all that stuff)
You should just attach database in sql server management express
That's all ..
Wyerarch, marked your answer
Dec 10, 2008 08:59 PM|Gregale.net|LINK