How to create a new database in Microsoft SQL Server

Answer

On various GFI products, you may be required to create a new Microsoft SQL database. This article explains how to create a new database on the following versions of Microsoft SQL Server:

• Microsoft SQL Server 2000
• Microsoft SQL Server 2005
• Microsoft SQL Server 2008

Microsoft SQL Server 2000

1. Open Microsoft SQL Management Studio
2. Expand the Microsoft SQL Server node where you want to create the database
3. Right click the Databases node and then click New Database
   
   
4. Type the database name in the dialog box, for example, MailSecurityReports, and then click OK

Microsoft SQL Server 2005

1. Open Microsoft SQL Management Studio
2. Connect to the database engine using database administrator credentials
3. Expand the server node
4. Right click Databases and select New Database
   
   
5. Enter a database name and click on OK to create the database

Microsoft SQL Server 2008 or later

1. Open Microsoft SQL Management Studio
2. Connect to the database engine using database administrator credentials
3. Expand the server node
4. Right click Databases and select New Database
5. Enter a database name and click OK to create the database