1

I am trying to implement an SQL Server backup client using SMO. The system is designed so that the user can manually configure where SQL Server stores its backups, by default its set to the Windows TEMP directory but the user can change that to whichever directory he desires.

The problem is SQL Server might not have access to that directory and I am not sure how to check if the selected directory is accessible by SQL Server.

Is there an SQL command/query that one can use to verify that SQL Server has access to a given location?

Zaid Amir
  • 4,727
  • 6
  • 52
  • 101
  • http://stackoverflow.com/questions/1281620/checking-for-directory-and-file-write-permissions-in-net – TheGameiswar Jul 28 '16 at 06:16
  • 1
    @TheGameiswar the link you shared checks if my application has access to the directory. I need to check if SQLServer which runs in a different session than my application also has access – Zaid Amir Jul 28 '16 at 06:24

0 Answers0