Backingng Up a Database that is Attached

Hi,

I was trying to figure out how to back up a database that has been attached to the SQL Express instance. I found on the web this tutorial and tried to use it, however it seems like it cannot find the database. The DB is attached by the web application using AttachDbFilename in the connectionstring.

http://www.sqldbatips.com/showarticle.asp?ID=27

Any ideas?

thanks

If you are doing personal development you download the eval version and install it as a named instance and register the Express so you can manage it with Management Studio. It is good for 180 days but if you are developing full application buy the developer edition it cost $60 on the web and do the same. And one more thing the database is not attached to Express it is created in Express which is a full RDBMS(relational database management system) without the GUI tools. Hope this helps.

http://www.microsoft.com/sql/downloads/trial-software.mspx

|||

Hi,

I actually do have the the developer edition, and when I used the management studio to connect to SQL Express server (on a different machine) I was still unable to see/view this database thats was attached by the web app. I know the database was attached, because the web app was functioning properly and displaying/inserting data in the database.

|||If you have the developer edition you just right click at the top of management studio to register the Express and the Express becomes local to you. Then you use the backup and restore wizard to backup your databases in the Express. I have registered 68 SQL Server 2000/7.0 in one box. If you have more questions post again. Hope this helps.|||

Hi,

The problem is I do not see this databse in the pulldown in the wizard. I see all the other databses on the server, but none of the databses that the web app atached through AttachDbFilename.

Am I missing something?

tony

|||Well I think it is because you used just half of the database which is the data file, so check the Microsoft SQL Server folder under programs and check the data sub folder to see if the LDF(log data file) is there. If not create a blank database with same name and do INSERT INTO to recreate the database and delete the existing ones of all the attached databases because you need the log file and you also need to backup your databases. And no you are not missing anything Microsoft is using RDBMS(relational database management system) as file based database. So the SQL Server wizards may not be seeing all the attached databases because they are missing the log file. Another option is to right click on the database to see if backup is enabled. Hope this helps.