Control Panel Forum Hosting Help ASP.NET 3.5 & SQL 2008 Web Hosting Resources

Total members: 88776
Average new registrations per day (in last 7 days): 89

New Registration: Open

Register Now

Home » Tips » How to use SQL Server 2005 Express database

General	Hosting Features	Upgrade Options	Server Issues
Coding Questions	Security & Permissions	Site Promotion

How to use SQL Server 2005 Express database

08 Nov, 2005

Summary
This article talks about connecting to SQL Server 2005 (or, SQL Server Express) from your free ASP.NET hosting account.

We have SQL Server 2005 Express now available for all members.

You can upload SQL Server Express database files (.mdf) to the database folder using File Manager and attach the database file to SQL Server using Database Manager

How to create a new SQL Server database ?

If you need to use SQL Server Express database, you must create a new database file in your machine and upload to the "database" folder in your AspSpider account. There is a "Attach SQL Server database" feature available in the Database Manager, which will allow you to attach the uploaded database file to SQL Server.

Earlier, we used to create databases directly on the server for members. We have discontinued this feature currently.

As of now, you cannot create a database on the server. You must create locally and upload the .mdf file.

You will not be able to use the auto attach feature to attach database from your App_Data folder.

Steps:

1. Create a new SQL Server database in your local SQL Server 2005.
2. Detach database.
3. Upload .mdf file to the "database" folder.
4. Use the button "Attach SQL Express Database" to attach the .mdf file to SQL Server.

How to backup SQL Server 2005 Express database ?

There is no backup mechanism avaliable yet.

If you need to backup your SQL Server database, you must first "detach the database" (using DatabaseManager) and then download it.

The detach process may fail, if your database is currently in use. You may need to wait for several hours and try again.

Related Topics:

Connection strings
How to use MS Access database