American access system ADV-1000 Betriebsanweisung PDF herunterladen (Seite 740)

100

101

740 WIN-PAK User Guide

Note:

If the database server is not stopped while SQL

maintenance plan is running, the SQL maintenance

plan will stop the database directly from SQL. When

this occurs, there will be a loss of history for the

time the service is stopped until ALL services are

restarted.

In order to see any history after this point, it is

necessary to stop all services including SQL, and

restart all the services as the PC is rebooted. The

history during the time the plan was run until the

services are restarted is permanently lost.

Alternatively, you can stop the maintenance plans, or

deselect the WIN-PAK database from the

maintenance plan list.

The WP/WPP services must be stopped before

running a maintenance plan. The best way to

accomplish this is to create a schedule in the

operating system and add a script to stop all WP/

WPP services.

It is up to the local IT administrator to create this

script as every system is different.

Scenario: Maintenance plan created by a DBA runs

on a schedule in SQL at 11pm.

The message on the bottom of the SQL Server

Service Manager windows will give you the

computer name followed by "MSSQLServer-

Running". Select the SQLServerAgent. The

message on the bottom of the SQL Server

Service Manager windows will give you the

computer name followed by "SQLServerAgent-

Running".

7 If MSSQLServerAgent components are not

running, click on the Start/Continue button.

1 2 ... 735 736 737 738 739 740 741 742 743 744 745 ... 776 777

Kommentare zu diesen Handbüchern

Keine Kommentare

American access system ADV-1000 Betriebsanweisung Seite 740

Kommentare zu diesen Handbüchern