Basic steps for setting up SQL Server maintenance

1

Choose a backup strategy

Choose a backup strategy to employ.

2

Identify the databases to back up

Compile the list of databases to be part of the SQL Server Maintenance Plan.

3

Specify the recovery model type for each database

SQL Server Recovery Models

4

Identify storage locations

Decide on the locations of the SQL Server database and transaction log backup files. Consider local drives and network locations.

5

Configure administrative access

Create a dedicated Windows account with access to the required file locations and a password that does not expire.

6

Create SQL Server maintenance plans

Create a SQL Server Maintenance Plan.

7

Deploy the backup solution

Decide on a backup strategy and implement the backup solution.

8

Test the backup process

Observe the operation of the backup and file copy operations until satisfied that they are working correctly.