Essential SQL Server Concepts - Microsoft Business Intelligence Tools for Excel Analysts - page 165

There are several options and configurations available to you when creating a database:
➤ Database name: Give careful thought to selecting your database name. You can change it;
however, it might impact queries and applications that reference that name.
➤ Owner: In general, leave this field selected to Default. By default, SQL Server assigns all
objects in the database to DBO. For more complex databases, you might consider setting
multiple owners in your database to organize objects under them.
➤ Database files: Refer to the previous section for best practices on setting up these files.
➤ Options: Clicking Options in the Select a Page pane. That takes you to the Options tab in the
New Database window (see Figure 8-12). Select Simple from the Recovery Model drop-down
list, as shown in Figure 8-12. This option keeps your log file under control.
Figure 8-12: Select Simple from the Recovery Model drop-down list.
Database maintenance
SQL Server database maintenance involves several aspects, including backup, index rebuilding, and
statistics updates. The full scope of database maintenance is traditionally handled by the system
administrator. If you're managing the system yourself, it's helpful to know how to back up a database.
Follow these steps for the easiest way to back up your database:
1. Right-click your database, and choose Tasks ➜ Back Up.
The Back Up Database window opens, which allows you to select the options for the backup
you want to perform (see Figure 8-13).