Upload Database File - SQL 2008

Today in an emergency we had to move our SQL databases to DiscountASP.net

I stopped the server on our old SQL 2000 box.
FTP'd the file to a new folder on our site called App_Data

I used the SQL 2008 tool to UPLOAD the MDF file.

During the upload process it says "Could not open new database 'SQL2008_xxxxx_xxx'. CREATE DATABASE is aborted.

The technician says the following error was logged:

The log cannot be rebuilt.
The log cannot be rebuilt because there were open transactions/users when the database was shutdown, no checkpoint occurred to the database, or the database was read-only. This error could occur if the transaction log file was manually deleted or lost due to a hardware or environment failure.

---

Please make sure that you commit and open transactions and that you cleanly detach the database in your development environment. Afterward, please upload the data file again and try attaching the database.



I have the log file and the database. I can remount them on my own SQL 2000 box and they attach just fine.

What do I need to do to fix this issue so I can upload them onto the SQL 2008 box at DiscountASP.net?

Thanks!!

 

Well I did all that and it seems to have uploaded. Thank you!

However, once uploaded none of my tables or stored procs seem to exist.

What would do that?

 

Are you using "SQL2008_xxxxx_xxx_user" to log in? If you created an extra user to access this database, you will have to give it permissions by following this KB article: http://support.discountasp.net/KB/a...l-logins-to-my-sql-2008.aspx?KBSearchID=21784

Otherwise, open a ticket a have support check it out for you