Specifications

• model – used as the template for all databases created on the Microsoft SQL

Server instance

• msdb – used by Microsoft SQL Server Agent for scheduling notifications and

tasks, recording operations

System databases can be restored from a backup created within the Microsoft SQL Server

version, which the server instance is currently running.

After selecting the appropriate object for back up, click Next to continue.

5.2.4 Specifying Credentials

In the first step of this wizard you specified the default task execution account (see

Defining

a Backup Strategy

(p. 32)) so the backup task would run as it was executed by the specified

user.

If you want to change the credentials for access Microsoft SQL Server, click the Change link

while selecting the source to backup.

There are two choices:

• Use Windows Authentication

• Use Microsoft SQL Server Authentication

Enter user name and password, then click OK.

The domain name must also be specified if the user is a member of a domain

(DOMAIN\Username).

Figure 21. Specifying credentials

5.2.5 Selecting a Backup Archive Location

The further you store the backup archive from the original location, the safer it will be in

case of data damage. For example, saving the archive to another hard disk will protect your

data if the primary disk is damaged. Data saved to a network disk or backup server will

survive even if all your local hard disks are down.