NOTE: This article is written for our Classic Cloud Control Panel. You can access this interface from the New Cloud Control Panel by clicking your username in the upper-left of the control panel and selecting "First-Generation Control Panel".
The Rackspace Cloud has made it very easy to manage your MSSQL 2008 databases by creating a server wide install of a tool called myLittleAdmin.
You can reach this interface at:
NOTE: To find out if your account is located in our ORD or DFW datacenter, check the test link for your site. If your testlink includes dfw in the URL, such as www.domain.com.php5-2.dfw1-1.websitetestlink.com then your account is in DFW.
When logging into myLittleAdmin, you will need to make sure to select the correct server choice from the drop down menu. You can find the correct value within the control panel on the View Database page.
NOTE: Alternatively, you can use other programs such as Management Studio Express or Enterprise Manager to manage your MSSQL databases as well.
Logging Into MyLittleAdmin
NOTE: The usernames are listed under the Database Users section; by default there is only one user and this would be the username you would use to login to myLittleAdmin. If there are multiple users listed, you may login with any of them. The number that prefixes the username is the account number for the website owner (yourself or your client) and is important when logging in, so be sure to enter the username exactly as it is listed on this page.
NOTE: Because this user is separate from your control panel account and FTP users, the password may or may not be the same as those users. If you cannot remember your database password you can reset the password by clicking on the user in the list and filling out the password form; however, please be aware that your website code may rely on the existing password, so changing the password for a database user could cause database connection errors on your website! If you are working with a live website and cannot risk this password reset, please contact a web developer for assistance.
With the above information, you're ready to start working with the database.
This will open the myLittleBackup interface in a new window:
The database backup form will load in the window's right frame.
If you don't want choose a backup set name and description or you're not sure what to use, just leave it blank or use the database name as both!
During this time you will see a loading message on the screen. Please take heed of the warning myLittleBackup gives: You're now ready to backup your database. The process can take several minutes. Be patient and do not click the stop button until done.
Congratulations! You have just created a backup of your MSSQL database! You should now see a link to download your database backup in Step 5.
If you experience a problem or you have further questions or concerns, please do not hesitate to contact our technical support 24x7 via phone, chat or by submitting a ticket through your control panel.
This concludes the series on adding and managing your databases for Cloud Sites. We've discussed how to create a new MySQL database, a MSSQL database and connect to the online interface offered by the Rackspace Cloud, and hos to perform database backups. In the next series, we will dive into the different web services offered in Cloud Sites.
© 2011-2013 Rackspace US, Inc.
Except where otherwise noted, content on this site is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License