Provides access to all the pages in a database that were previously marked suspect by recovery.
sp_forceonline_db dbname, {"sa_on" | "sa_off" | "all_users"}
is the name of the database to be brought online.
allows only users with the sa_role access to the specified page.
revokes access privileges created by a previous invocation of sp_forceonline_page with sa_on.
allows all users access to the specified page.
Allows the System Administrator access to all suspect pages in the pubs2 database:
sp_forceonline_db pubs2, "sa_on"
Revokes access to all suspect pages in the pubs2 database from the System Administrator. Now, no one can access the suspect pages in pubs2:
sp_forceonline_db pubs2, "sa_off"
Allows all users access to all pages in the pubs2 database:
sp_forceonline_db pubs2, "all_users"
A page that is forced online is not necessarily repaired. Corrupt pages can also be forced online. Adaptive Server does not perform any consistency checks on pages that are forced online.
sp_forceonline_page with all users cannot be reversed. When pages have been brought online for all users, you cannot take them offline again.
sp_forceonline_db cannot be used in a transaction.
To bring only specific offline pages online, use sp_forceonline_page.
Only a System Administrator can execute sp_forceonline_db.
Values in event and extrainfo columns from the sysaudits table are:
Event |
Audit option |
Command or access audited |
Information in extrainfo |
---|---|---|---|
38 |
exec_procedure |
Execution of a procedure |
|
System procedures sp_forceonline_page, sp_listsuspect_db, sp_listsuspect_page, sp_setsuspect_granularity, sp_setsuspect_threshold
Copyright © 2005. Sybase Inc. All rights reserved. |