SQL Server 2000

Thu, 10 Jul 2008 21:06:53 GMT

For more information, please refer to SQL Server 2005 knowledge base article.

SQL Server 2005

Thu, 10 Jul 2008 20:34:45 GMT

SQL Server 2005 is a comprehensive database software platform providing enterprise-class data management and integrated business intelligence (BI) tools. The SQL Server 2005 database engine provides more secure, reliable storage for a relational database format or XML. By supporting both a relational database format and XML, the SQL Server 2005 database engine provides the flexibility necessary to support the way you work. It also enables you to build and manage highly available, well-performing database software applications that you and your people can use to take your business to the next level.

Viewing SQL Server 2005 Databases
Adding SQL Server 2005 Database
Backing up SQL Server 2005 Database
Restoring SQL Server 2005 Database
Truncating Database Files
Adding SQL Server 2005 Database User
Deleting SQL Server 2005 Database
Deleting SQL Server 2005 Database User

Viewing SQL Server 2005 Databases

To view the list of SQL Server 2005 databases, click Databases >> SQL Server 2005 menu item on your space page. SQL Server 2005 page will open.

Adding SQL Server 2005 Database

To add a new SQL Server 2005 database, click Create Database button. SQL Database Properties page will open.

Type the name of your database in the Database name box. Choose users to access your database and click Save button.

Backing up SQL Server 2005 Database

To backup SQL Server 2005 database, open SQL Server 2005 page. Choose database that you wish to backup and click on the database name. SQL Database Properties page will open. Click Backup button. Backup SQL Database page will open.

In the Backup File Name box, type the name of the file where backup data will be stored. Check Zip Backup box if you want to zip backup file. Choose the backup destination and click Backup button.

Restoring SQL Server 2005 Database

To restore SQL Server 2005 database, open SQL Server 2005 page. Choose database that you wish to restore and click on the database name. SQL Database Properties page will open. Click Restore button. Restore SQL Database page will open.

Choose the backup file to restore from, and click Restore button.

Truncating Database Files

To reduce the size of SQL Server 2005 database data and log files, you can truncate database files. To truncate SQL Server 2005 database files, open SQL Server 2005 page. Choose database that you wish to truncate and click on the database name. SQL Database Properties page will open. Finally, click Truncute Files button.

Adding SQL Server 2005 Database User

To add a new SQL Server 2005 database user, open SQL Server 2005 page and click Create User button. SQL User Properties page will open.

Type the name and password of the database user in the User name and Password boxes. Select the default database and choose databases which the new user can access. Finally, click Save button.

Deleting SQL Server 2005 Database

To delete SQL Server 2005 database, open SQL Server 2005 page. Choose database that you wish to delete and click on the database name. SQL Database Properties page will open. Finally, click Delete button.

Deleting SQL Server 2005 Database User

To delete SQL Server 2005 database user, open SQL Server 2005 page. Choose database user that you wish to delete and click on the user name. SQL User Properties page will open. Finally, click Delete button.

Newest KB Articles in Managing Databases