uploading express to 1&1

Hot Topic

MS Project file in Sharepoint marked as read-only
Cannot add solution to source control
Inserting "Null" Values on a SQL DB with a Table Adapter
How do I restrict Contributors from branching
Arraylist sorting
Vb Express 2005 How do I select a paper tray and/or select a paper size
Making VB recognize a Dance Dance Revolution dance pad
SQL querry between two dates
display date and time
Global EventHandlers

VS Team System

Missing Button Graphics/Text in Difference and Merge Tools
Question about Forms
Cannot download Team Foundation Server installation guide
Recording MP3 FIles
system.stackoverflowexception when running FXCOP
Example of tabbed webbrowsing
Multiple fonts in a richtext box
Hour Glass Running
clipboard question
solution as the topLevel of

uploading express to 1&1

I have made a rather simple login site using the tutorials I have found regarding membership and would like to transfer this to my hosting site (1&1), however I believe I need to have a .bak file to upload which I think is directly related to SQL2005. What do I need to do to accomplish this. Any help (and well described) would be great.

Thanks in advance,




Answer this question

uploading express to 1&1

  • Remmie

    Thanks Jon,

    SO I would need to create a instance of SQL2000 on my machine and create a .bak file from that Can I create a .bak file with Express and use that file for the transfer

    Regards,
    Patirck


  • GustavoPollitzer

    Sorry for the delay - forgot to check my posts.

    Yes your right - you can do this using SQL Server Management Studio Express for 2005 version, but not 2000 to my knowledge. This is the big problem with 1and1 and I have the same issue. I wote an app for a client and I can't use 1and1. I host this on my own PC but am looking to go with discoutasp.net as they fully support SQL 2005 and can connect directly to the hosted database.

    I think 1and1 are going to lose my business!!


  • slledru

    You can do this - but not with SQL2005. 1and1 only use sql server 2000. I tried uploading a 2005 version and it will not work. If you create a blank database and go to the "admin" part, you will see the version number:-

    Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)

    I got caught out with this one so I asked 1and1 when they will upgrade - and the response was:-

    "Unfortunately we would not be able to support the 2005 version, only 2000. I apologize for any inconvenience this causes you."

    Wasn't much help :-(

    The process is normally:

    1. Upload your .bak file using the "webfiles" panel. I think there is a folder _db_import already there.

    2. Go to SQL Aministration page, there you have your import/export panel. Click on import and follow the instructions. Remember you have to create a database to import to.


    3. Go to SQL administration page again and click on admin button related to your database, on the left nav menu, expand reports and you will have one called "import status". This will probably read:-

    "The backed-up database has on-disk structure version 611. The server supports version 539 and cannot restore or upgrade this database. RESTORE FILELIST is terminating abnormally."



  • Jocchan

    Did you switch to discountasp.net Did it work for you I am having the same problem with 1and1 and need to find a solution.

    Thanks
  • uploading express to 1&1
Answer this question