Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Aug 04, 2008 01:45 PM by chidge
Jul 08, 2008 11:46 PM|LINK
Okay I am using one of the starter sites. I have a folder where the databases are, 2 of them aspnetdb and personal. I am not sure how to proceed. I have copied the site to my host but I am getting a database error. so here are my questions;
Even thought I have never attached the databases to SQL express, are they accually running on it? If that is the case why if I launch SQL studio do I not see them? I know these are stupid questions to most of you and I am sorry. Just trying to learn here.
I am sure your answers will lead to more questions.
Thanks in Advance
Jul 09, 2008 01:26 AM|LINK
ASPNET will automatically create the ASPNETDB under App_Data folder when Personalization or one of the other application services such as roles, membership or profiles are being used for the first time. Also by default, ASP.NET creates the database as
a single SQL Server Express database file that contains the database schema for all of the application services. Using the Web.config file, you can configure your application so that a separate database file is created for personalization. Further, in the
Web.config file, you can specify a SQL Server database to store the application services data instead of using the default SQL Server Express database
Jul 09, 2008 11:12 AM|LINK
I get that - But how do I attach to the database once the entire site is copied to my web server? I cant seem to detach the database from VWD2008 so that I can attached it to SQL Exp and do a backup. This would allow me to send the backup to my host and
they could do a restore.
Sorry for being so ignorant.
Jul 09, 2008 11:30 AM|LINK
> I have copied the site to my host but I am getting a database error. so here are my question
I suggest that you read very carefully your hosters FAQ - there is usually some special procedure to follow.
Who is your hoster?
Jul 09, 2008 08:29 PM|LINK
Jul 10, 2008 12:09 AM|LINK
I get that - But how do I attach to the database once the entire site is copied to my web server? I cant seem to detach the database from VWD2008 so that I can attached it to SQL Exp and do a backup. This would allow me to send the backup to my host and they
could do a restore.
See below for your reference
Jul 14, 2008 11:01 AM|LINK
I am still way confused on exact what the steps are for detaching the database or backing it up so tha I can send it to my hosting provider.
Jul 14, 2008 11:13 AM|LINK
The reson you are struggling to get a specific answer is that this process depends on your hosting company. My advice would be to have a look at their technical help and see what you can find out. Generally most of the hosting companies that I have dealt
with would require a .bak file - a backup of the database which you will restore onto the SQL server. you will also require a different connection string as the database will not be held within the App_Data folder as you are used to. This process is the bane
of my life - and I'm an experienced SQL DB Admin. The variety of methods that hosts use is a problem, i try to use one host as much as possible - that way I know the process.
I would install SQL Server Management Studio Express on you PC, attach the database(s) that you need and create backups of them. Its likely that you will then be able to restore the backups to the SQL server that you have set up on the host. Although, to
save yourself any loss of time, speak to your hosts first.
Jul 14, 2008 11:25 AM|LINK
Therein lies the problem. I do have SQL Studio installed but I can not detach ANY of my databases from VWD2008. There is a detach option but then don't detach and if I try to attach them to SQL studio anyways (thinking they really did detach) I get a ton
of permission errors.
Is there some special process that I am missing to attach them to SQL?
Thanks a bunch..
Jul 14, 2008 02:46 PM|LINK
Nice! SQL drives me mad somethimes. We will have to work through the errors Im affraid. Firstly, make sure that the permissions on the physical folder where the mdf and ldf files are held lets do anything. Next, close VS and anything else that is connected
to the DB. open management studio and try attaching DB. Let me know the errors and i will try to help you through.