What is the purpose of Attach MDF file tool

By attaching from my local machine to the hosted DB, what useful tasks can I perform, apart from being able to update data using the SSM locally. I am interested in tasks relating to the maintenance of the database when a new version is released.


Thanks in advance.

 

How is it different to a restore?

 

The backup procedure will give you the ability to backup the specific object in your database. This is when you would use the restore feature.

The attach feature simply takes the database file off one SQL server and attaches it to another. As you can see you do not have a whole lot of options with the attach feature like you would have on the restore/backup feature.

Plus when you detach the database to attach it to another server the file can be large can it is taking the database files as is. In the backup procedure the database is somewhat compressed.

In all cases you should really not use the detach/attach feature for your everyday backup. The best practice is doing the backup/restore procedure.

 

I just want to expand on this topic and ask a few more questions.

I am trying to attach two .mdf files to my one database. It seems that when I attach the first one it works fine and when I try to attach the second it deletes the first one then the second one works fine.

Is it possible to attach two .mdf files? I am trying to get the visual web developer starter kit "personal site kit" to work and it uses two databases. the first holds user login info and the second holds pictures and such. So I am trying mix both databases into the one so that I don't have to pay for two databases. I know nothing about databases or how to do any of that and have no database tools.

Any ideas?

 

Hi,
You will need to merge the DB files and attach them as one.
Or attach one and use an SQL Copy method for the other.
If you need help with that let me know.
All the best,
Mark

 

ok good to know. I may just have my database buddy walk me through that. Is there no way to run scripts against the database from within the control panel? I didn't see a way but I just want to make sure I didn't miss something.

 

Hi,
You can run SQL from the DASP on-line SQL Server admin tool:
https://sqlwebadmin.discountasp.net/

I'm planning on creating Webcasts for that..if you need one let me know.
All the best,
Mark

 

yea lol I found that earlier and had no clue where to start for logging in... I might play with that.

A webcast would be awesome for that!

Ninja Edit: I don't know how I did it but I managed to add the two databases together in that tool you linked for me. Thanks for that. This will also be a helpful tool for hen I begin making my web services for my blackberry app Thanks again! and please do help out with a webcast because poor fools like me (digital artist) are lost when it comes to this technical stuff. We just throw stuff against the wall and if it sticks we jump up and down like baboons.

 

WiseMx,
Is there any documentation for DASP? Or is that what you mean when you say that you can provide a Webcast for that? I'm researching DiscountASP as my webhost, but first want to be sure I understand if/how to get my databases in "SQL Sever 2008 Developer Edition" connected between my local machine and DASP. Could I see the Webcast for this?
Thanks

 

Hi,
DASP has a Support/KB site:
https://support.discountasp.net/Main/Default.aspx

And yes I create Webcasts on request.
SQL Server 2008 Dev edition is what I now use for the DB Webcasts.
Over the next few days I plan on catching up with these.
What did you need exactly?
All the best,
Mark

 

SQL Server and its files too are very important for me,reason of I often work with its and once I noticed that something had happened with my sql server and files too. But fortunately my friend called me up and recommended me - mdf repair tool. To my great surprise the program resolved my troubles for a minute and without payment as I kept in mind. The application helped some of my friend too and they thanked me a lot.