Attaching SQL2005 DB

Hi,

just signed up with DiscountASP and have a question regarding attachment of databases. I have a SQL2005 MDF which is on my local machine. I understand from a KB article that to attach an MDF I need to copy the file to one of my application folders, upload it to the DiscountASP server and then run the attachment script from the Control Panel.

My questions is this: What happens to the MDF file after the Attach script has finished. Is it copied to another folder or server before actually being "attached" to SQL server? Or is the file in my application folder actually attached to SQL Server. If it is the later then I presume I have to delete or move the MDF on my local machine. Otherwise during the next publish it might overwrite the one on the DiscountASP server.

Thank you in advance.

ps - have to say I am impresed by what I have seen so far ...

 

During the attachment the mdf is copied over to DASP SQL Servers.So the copy in your applications doesnt affect the same.

Vikram

DiscountASP.NET
www.DiscountASP.NET

 

Super! thats what I was hoping. Many thanks Vikram for the quick response.

 

I assume that when users interact with my database, they will be modifying the file that was copied over to DASP SQL Servers. How do I copy this modified version back to my local machine so that I can analyze the data? When I use my Web copy utility in Visual Developer Express 2005 it copies the file in the App_Data folder.

 

You can create a backup of your database using the 'SQL Tool Suite' (Control Panel>MS SQL 200*> SQL Tool Suite) which will be stored in the root.You can then download and restore the same on your local machine.

Vikram

DiscountASP.NET
www.DiscountASP.NET

 

Thanks, Vikram! Like jimmykavI really appreciate the quick reply.