Filter
Top Products
CHAPTER 5 Upgrading Adaptive Server
Installation Guide 75
5 Log in to the Replication Server, and resume the Log Transfer connection
for each replicated primary and each replicated RSSD:
1> resume log transfer from server.database
2> go
If this is a replicated RSSD, you must log in to the replicate Replication
Server.
6 If you are using Rep Agent, log in to the Adaptive Server and restart the
Rep Agent:
1> use database
2> go
1> sp_start_rep_agent database
2> go
7 If you are using LTM, restart the LTM.
Reenabling auditing
Reenable all auditing options for stored procedures using the audit options you
recorded during pre-upgrade. Reenter the audit options using
sp_audit.
For example, if you had enabled stored procedure auditing for
sp_addlogin
stored procedure in your server before upgrade, run the following
sp_audit
command to reenable auditing on
sp_addlogin:
sp_audit "exec_procedure", "all", "sp_addlogin", "on"
Adaptive Server 12.5.x and later includes the following global audit options for
sp_audit:
•
security
• dbcc
The functionality provided by the following sp_auditoption options is now
covered by the
sp_audit security global audit option:
•
server boot
• roles
These options are turned off by default and are not turned on even if you used
sp_auditoption "all", "on" to turn on all global audit options in a version earlier
than 11.5.
To turn on these options, use: