Open topic with navigation

Backing up the PowerSchool SMS database

You can back up a PowerSchool SMS system's database when necessary or set up a regularly scheduled time for PowerSchool SMS to do it automatically. The backup process results in a static copy of the database in a location of your choosing. Allow up to an hour for the backup process. Once a backup is underway, you can check on its progress or set up automatic notification of its success or failure.

Circumstances in which we recommend backing up a system's database include:

To back up a system's data: [You can do this if your role is District Administrator.DA]

1

In the Start menu click Programs > Microsoft SQL Server > Enterprise Manager.

2

In the left pane, locate the name of the system's database server.

3

Open Management, then SQL Server Agent, then Jobs.

4

In the right pane, right-click "[Your Database's Name] backup" and in the menu click Start Job. Enterprise Manager starts backing up your data.

=

To schedule a backup rather than run it immediately, click Schedules, then New Schedules.

=

To set the location of the backup, in the right pane, right-click "[Your Database's Name] Backup" and in the menu click Properties. Click Steps, then Edit.... In the Edit Job Step dialog, specify a location [Figure 422].

Figure 422: Edit Job Step dialog

To check on the progress of the backup process: [You can do this if your role is District Administrator.DA]

1

In the Start menu click Programs > Microsoft SQL Server > Enterprise Manager.

2

In the left pane, locate the name of the system's database server.

3

Open Management, then SQL Server Agent.

4

Right-click Jobs and in the menu click Refresh.

5

In the Status column, view the status of the backup process.

=

For a scheduled backup, you can also view the time of the last backup and the scheduled time for the next.

To set up an automatic notification of a backup success or failure:

1

Set up an operator to receive the notification:

a

In the Start menu click Programs > Microsoft SQL Server > Enterprise Manager.

b

In the left pane, locate the name of the system's database server.

c

Open Management, then SQL Server Agent.

d

Right-click Operators and in the menu click New Operator.

e

For Name, specify an operator or computer name.

f

In the Net Send Address, specify the name of the computer to which you want notifications sent.

g

Click Test to send a test message.

h

When Enterprise Manager displays a message, click OK.

i

Click OK.

2

Set up a notification:

a

In the Start menu click Programs > Microsoft SQL Server > Enterprise Manager.

b

In the left pane, locate the name of the system's database server.

c

Open Management, then SQL Server Agent.

d

In the right pane, right-click "[Your Database's Name] backup" and in the menu click Properties.

e

Click Notification.

f

Select the Net Send Operator check box and choose one of the operator's you set up in step 1.

g

Choose the condition that triggers a notification. Your choices include:

=

When the job succeeds

=

When the job fails

=

Whenever the job completes

h

Click OK.

www.powerschool.com
Tel: 866-434-6276
Email: smssupport@powerschool.com

Copyright 2015-2016 PowerSchool Group LLC and/or its affiliate(s). All rights reserved. All trademarks are either owned or licensed by PowerSchool Group LLC and/or its affiliates.