After installing the SQL Server, you must configure it for your environment according to the following recommendations:
- Ensure that SQL Server and SQL Server Agent services are running and are all set to an automatic startup mode.
- Review System Event Logs for unusual errors.
- In Microsoft SQL Server Management Studio, right-click the top-level SQL Server node.
- Select Properties from the menu to display the Server Properties dialog box.
- Select the Database Settings page.
- Set the default Data directory and default Log directory to match directories created in previous steps, as shown in the following figure.
- Click OK to save your changes.
TIP: Optionally, you can offload tempdb onto a separate physical drive. The drive(s) must be physical and not logical to achieve the intended benefits. For more information, refer to readily available information on the Internet concerning system I/O configurations.
NEXT TOPIC: Implement SQL Backup Strategy