locked
Help! I've lost my database! RRS feed

Answers


  • Jamie,

    If you set it up a few months ago then you must have been using the CTP service.   You probably missed the email included below. 

    You can go to https://ctpportal.database.windows.net to find your old database.



    ================

    We’re talking this extraordinary step of sending email directly to the account contacts of record for the SQL Azure Database CTP (you!) in order to let you know of a couple of exciting things about the service upgrade that just completed.  We are proud to announce that we are feature complete for PDC ’09 and we’re lighting up the first of our production environments to make it simple and easy to transition to the production system as we drive toward commercial availability.  This will have a small impact on your use of the current CTP service.  Here is a quick summary:

    ·         You are invited to begin using an updated CTP of the SQL Azure Database service.  Your sign-up information has already been pre-provisioned on the new service.

    ·         This updated CTP of the SQL Azure Database service has been deployed to a new production cluster and is accessed through a different service URL (e.g. <servername>.database.windows.net).

    ·         The previous CTP of the service remains available and unchanged, except for a change to the URL of the developer portal.

     

    Please read on for further details.

     

    SQL Azure Service Update

     

    Summary:

     

    As we get ready for the Professional Developer’s Conference (PDC) in Nov ’09, we are bringing on line the first of a new set of data center clusters that we’ll use to support the commercially available service. 

    This new cluster is now available for use by existing customers of the current CTP that we released last Aug. 

     

    In order to make this transition as easy as possible, we’ve pre-provisioned accounts on the new cluster for all existing customers of the August CTP.  Also, we’ve left the August CTP service up and running in parallel.  The August CTP will remain available and unchanged for now, although we will decommission the August CTP service by the end of this year (Dec ’09).

     

    One side effect of this new environment is that we’ve had to re-purpose the developer portal URL in support of this new environment.  The old developer portal is available at https://ctpportal.database.windows.net.  Use this (and the current service URL at <server>.ctp.database.windows.net) to continue to get access to the August CTP environment.

     

    One key benefit of migrating to the new data center cluster will be that because this will be the same machine cluster we’ll use for the commercially available service, all servers and databases in this environment will automatically carry over to the commercially available service.  All you will need to do is to update your billing information as part of signing up for a commercial offer.  More information on when and how to complete this sign off process will be sent later this fall as part of our launch messaging.

     

    Please start using the new service!  Here’s how:

     

     

    How to move to our Production Service: 

     

    Step 1) Visit https://sql.azure.com – to activate your account and create a new server and databases.  As noted above, we’ve already pre-provisioned your existing account information so you don’t need a new invitation code.   Be sure to use the same LiveID associated with your SQL Azure Database CTP account when logging in.

     

    If you would like to access and view your August CTP server and databases, you can still do that, using the developer portal available at this address:  https://ctpportal.database.windows.net

     

    Step 2) Any data stored in the August CTP service that you would like to take forward into the commercially available service can be migrated to the new production cluster using SSIS.  A walkthrough of how to do this can be found in the Windows Azure Training Kit.   See the “Moving Data Into and Out Of SQL Azure using SSIS” topic for more details.  The training kit also has details on using bulk copy (BCP).


    Tonyp
    Friday, December 4, 2009 5:36 PM

All replies


  • Jamie,

    If you set it up a few months ago then you must have been using the CTP service.   You probably missed the email included below. 

    You can go to https://ctpportal.database.windows.net to find your old database.



    ================

    We’re talking this extraordinary step of sending email directly to the account contacts of record for the SQL Azure Database CTP (you!) in order to let you know of a couple of exciting things about the service upgrade that just completed.  We are proud to announce that we are feature complete for PDC ’09 and we’re lighting up the first of our production environments to make it simple and easy to transition to the production system as we drive toward commercial availability.  This will have a small impact on your use of the current CTP service.  Here is a quick summary:

    ·         You are invited to begin using an updated CTP of the SQL Azure Database service.  Your sign-up information has already been pre-provisioned on the new service.

    ·         This updated CTP of the SQL Azure Database service has been deployed to a new production cluster and is accessed through a different service URL (e.g. <servername>.database.windows.net).

    ·         The previous CTP of the service remains available and unchanged, except for a change to the URL of the developer portal.

     

    Please read on for further details.

     

    SQL Azure Service Update

     

    Summary:

     

    As we get ready for the Professional Developer’s Conference (PDC) in Nov ’09, we are bringing on line the first of a new set of data center clusters that we’ll use to support the commercially available service. 

    This new cluster is now available for use by existing customers of the current CTP that we released last Aug. 

     

    In order to make this transition as easy as possible, we’ve pre-provisioned accounts on the new cluster for all existing customers of the August CTP.  Also, we’ve left the August CTP service up and running in parallel.  The August CTP will remain available and unchanged for now, although we will decommission the August CTP service by the end of this year (Dec ’09).

     

    One side effect of this new environment is that we’ve had to re-purpose the developer portal URL in support of this new environment.  The old developer portal is available at https://ctpportal.database.windows.net.  Use this (and the current service URL at <server>.ctp.database.windows.net) to continue to get access to the August CTP environment.

     

    One key benefit of migrating to the new data center cluster will be that because this will be the same machine cluster we’ll use for the commercially available service, all servers and databases in this environment will automatically carry over to the commercially available service.  All you will need to do is to update your billing information as part of signing up for a commercial offer.  More information on when and how to complete this sign off process will be sent later this fall as part of our launch messaging.

     

    Please start using the new service!  Here’s how:

     

     

    How to move to our Production Service: 

     

    Step 1) Visit https://sql.azure.com – to activate your account and create a new server and databases.  As noted above, we’ve already pre-provisioned your existing account information so you don’t need a new invitation code.   Be sure to use the same LiveID associated with your SQL Azure Database CTP account when logging in.

     

    If you would like to access and view your August CTP server and databases, you can still do that, using the developer portal available at this address:  https://ctpportal.database.windows.net

     

    Step 2) Any data stored in the August CTP service that you would like to take forward into the commercially available service can be migrated to the new production cluster using SSIS.  A walkthrough of how to do this can be found in the Windows Azure Training Kit.   See the “Moving Data Into and Out Of SQL Azure using SSIS” topic for more details.  The training kit also has details on using bulk copy (BCP).


    Tonyp
    Friday, December 4, 2009 5:36 PM
  • Perhaps you may have two Windows LiveID like I have. I can see Windows Azure or SQL Azure with each account.
    mysorian
    Friday, December 4, 2009 6:29 PM
  • Thanks Tony, you're spot on.
    I didn't so much miss the email as not bother to read it! Terrible habit of mine, sorry for having had to post this!

    cheers
    jamie
    http://sqlblog.com/blogs/jamie_thomson/ | http://jamiethomson.spaces.live.com/ | @jamiet
    Sunday, December 6, 2009 2:35 PM