Attaching SQL Server Database. Pls Help

Hello there,

This seems to be a very nice forum on the internet for developers and this is my very first post on this forum.

Anyways, my question is how do I attach a database in the web server. (I've purchased Sql Server 2005 space)

Now the scenario is, I've 2 databases:

<u>Database 1</u> is the ASPNETDB.MDF (inside the App_Data folder) this has the roles and membership details etc.

<u>Database 2</u> is the AbcDB.mdf (it has my tables, stored procedures etc) and it is located in 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data' and NOT in the root of my web application folder.

And now the thing is, to upload it in discountasp.net I can only do it if the database is under the App_data folder or in the root of web application.

My question:

Do I have to physically move my database AbcDB.mdf to the web application root folder or App_Data folder of the web application?

How can I get AbcDB.mdf database to go under App_Data folder (which already has the ASPNETDB.MDF)

I want to upload my AbcDB.mdf, how can do it? Please help

I am very confused.

Thanks!

Any small comment or help will be greatly appreciated.

Thanks once again!

Post Edited (live2learn) : 8/16/2008 9:00:48 PM GMT

 

Hi,
This is on my list of Webcasts but I have not created that video yet.

You already took a great step, adding SQL Server 2005, both 2005 and 2008 have the Attach feature.

It's very simple really, just upload your DB to your site, intoa folderthat's a good place for you.
Then in the SQL Server 2005 section of your Control Panel you will find the Attach feature.

As for the second DB, this part gets a bit tricky but it's not very hard to do really.
You can use either SQL Server 2005 on your end or the new SQL Server 2008 Express.
The new Express version of SQL Server 2008 is the first Express version that can import and export.

You have other options in either of those management tools.
You can create scripts then execute them on the remote SQL Server...
You can use the Import/Export wizard in SQL Server 2008 Express.
You can use the previous versions of SQL Express but you are limited and it's harder.

What will be your next step? Let me know and I'll be glad to help.
Salute,
Mark

 

Hi Mark,

Its so kind of you to reply. I would really appreciate if you can make a webcast for this database attach/upload. It will be a great help. Also, can you please send me the link of your other webcasts.

I just have bought Sql Server 2005 space. But still wondering which database to attach. /emoticons/confused.gif

By the way, my Database is in the Server Explorer, not in the App_Data folder. So do I have to right-click this folder App_Data and add existing item (i.e my database)?

Because when we attach/upload the database, discountasp.net asks for the App_Data folder path.

And do you have any website hosted on DiscountAsp.Net?

Which database are you using Sql Server 2005 or 2008? Did you upload you db using the attach feature?

Cheers! /emoticons/smile.gif

Thanks Mark!

Looking forward to your kind reply.

 

Hi,
I currently have three servers with DASP, one is IIS6 andtwo are IIS7.
One of them is what we, DASP and I, use for the Webcasts and general IIS7 tests as needed:
http://iis7test.com/webcasts/

DASP allows me to install any SQL Server needed for tests that DASP customers need.
Currently I use both SQL Server 2005 and 2008 for tests.
Customers really should move away from SQL Server 2000, I think anyway.
I can and will create this Webcast, seems it will help a lot of customers here.
Salute,
Mark

 

Update:
Sorryabout the delay...It is on the server now.
http://iis7test.com/webcasts/

Videos #8 and #9.
Both are the same, #9 is a Silverlight streaming version of the same video.
Salute,
Mark