first you get the database backup from your hosting server, then create a new database in your local server(database name may be same) and restore the backup database to your local server. There is option for Backup & Restore options in Express edition In Sql Server 2005 Express Edition - there is no Import & Export options, if you need this option you should by the standard edition or professional edtion etc,,,

Here itself you could find more[^]

Please explain why it is that you believe this error is invalid, and what you've done to verify it. How about posting us some code ? Christian Graus Driven to the arms of OSX by Vista. "! i don't exactly like or do programming and it only gives me a headache." - spotted in VB forums. I can do things with my brain that I can't even google. I can flex the front part of my brain instantly anytime I want. It can be exhausting and it even causes me vision problems for some reason. - CaptainSeeSharp

The following list highlights the major SQL Server 2005 components that are not supported in SQL Server Express: Reporting Services Notification Services Integration Services Analysis Services Full text search OLAP Services / Data Mining From: http://msdn.microsoft.com/en-us/library/ms165636(SQL.90).aspx[^] "My interest is in the future because I'm going to spend the rest of my life there." - Charles F. Kettering