Welcome to WuJiGu Developer Q&A Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
417 views
in Technique[技术] by (71.8m points)

sql server - Can we relocate the sqlaudit file to some other machine and view

We have enabled security audit for MSSQL DB and generated the sqlaudit file. We are also able to view the content by running below command through SSMS:

SELECT   * 
    FROM     msdb.dbo.rds_fn_get_audit_file
                 ('D:
dsdbdataSQLAudit*.sqlaudit'
                 , default
                 , default ) where action_id = 'LGIF';

But our requirement is to share this file with the security team so that they can view it locally in their server (which is different from the DB server for which sqlaudit file was created).

They are trying to run the same command after changing the file path but getting below error:

Msg 33224, Level 16, State 4, Line 1
The specified pattern did not return any files or does not represent a valid file share. Verify the pattern parameter and rerun the command.
The statement has been terminated.

Is there anything we need to consider while sharing the audit file?


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)
等待大神答复

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome to WuJiGu Developer Q&A Community for programmer and developer-Open, Learning and Share
...