I am looking at what I need to do to move my new DNN 4.4 site to a hosting provider. I believe the provider has SQL Server
2005. My site was developed with SQL Server 2005 Express.

Q. What if one is using SQL Server Express rather than SQL 2005?
A. The only difference would be if you are using a SQL Server Express user instance. From the top of my head, you could convert such a db to a real sql server database, after which the procedure is the same as i described. If you want to know how to convert a user instance, have a look at this article: http://msdn2.microsoft.com/en-us/library/bb264564.aspx

"User instances only work in the Express Edition of SQL Server 2005"

Converting a User Instance Database

You might want to change your user instance database into a normal SQL Server database. The primary reasons to do this are if you want multiple users to connect to the database or if you need to upgrade to another version of SQL Server—perhaps because you are running into performance or database size limitations. While there are several ways to do this, the easiest way is to attach the database files to a normal SQL Server instance by using the CREATE DATABASE ... FOR ATTACH command. Then remove the AttachDbFilename and User Instance options from the connection string. Remember that while you are connected to your own instance of SQL Server, you have full administrator permissions on the databases that are attached to that instance. When you change to a normal SQL Server instance, each user must have a login and database user. The database user must be granted the permissions required to run the application.

Having discovered this information I confess to not following how to implement the change?????

I have created a backup now. I'd just been backing the whole "C:\Inetpub" folder up on my laptop so far.

Anyway, what I am confused about is, is an 2005 Express database .mdb file the same as SQL 2005
professional database .mdb file?

ie. Can I simply send the backed up database from SQL 2005 Express to the web provider to attach
to their SQL 2005 professional version?

OK now I'm getting somewhere. I have "TurningPoint.mdf" and missquoted it as a .mdb, sorry.
I was getting confused trying to sort this all out.

This means somehow I do have to convert this to a TurningPoint.mdb file.
How is my next question?