SQL Server - (NEED Script) Create a Server Audit named [Audit-8] in your SQL Server. This audit should use a file target

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899603
Joined: Mon Aug 02, 2021 8:13 am

SQL Server - (NEED Script) Create a Server Audit named [Audit-8] in your SQL Server. This audit should use a file target

Post by answerhappygod »

SQL Server - (NEED Script)
Create a Server Audit named [Audit-8] in your SQL Server. Thisaudit should use a file target located in C:\COPServer\Audits andthe target may consist of an unlimited number of files, each filewill be limited in size to 32 MB. The audit should be configuredsuch that, in case it fails to log an operation, that operationwill fail. It should also be configured with a filter to log onlyoperations for members being added to, or removed from, a serverrole dbcreator. Make sure the audit is enabled, then, execute thescript. If no errors, save the script as Audit8.sql in the abovesame file location.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Top
Post Reply

Return to “Archived Questions & Answers”