Home >> FAQs/Tutorials >> SQL Server FAQ

SQL Server FAQs - Creating and Managing Databases and Physical Files

By: FYIcenter.com

A collection of 16 FAQs on creating and managing databases on SQL Server 2005. Clear answers are provided with tutorial exercises on creating, renaming, and deleting databases; setting current database; bringing databases offline and online; reviewing, moving and copy database physical files. Topics included in this collection are:

1. What is a database?
2. What is the simplest way to create a new database?
3. How to set the current database?
4. How to delete a database?
5. Why I am getting this error when dropping a database?
6. How to get a list all databases on the SQL server?
7. Where is my database stored on the hard disk?
8. How to create database with physical files specified?
9. How to rename databases?
10. Why I am getting this error when renaming a database?
11. What are database states?
12. How to set a database state to OFFLINE?
13. How to move database physical files?
14. How to set database to be READ_ONLY?
15. How to set database to be SINGLE_USER?
16. What are system databases?

To follow tutorials in this collection, you should connect to SQL server as the system administrator "sa" and run Transact-SQL statements presented in each tutorial.

(Continued on next topic...)