Home Forums SQL Server 2008 SQL Server 2008 - General Strange File issue > "CREATE FILE encountered operating system error 5(Access is denied.) while attempting to open or create the physical file" RE: Strange File issue > "CREATE FILE encountered operating system error 5(Access is denied.) while attempting to open or create the physical file"

  • August 19, 2013 at 2:28 am

    #1642575

    kenneth.gore (8/18/2013)

    So why would the SQL process have handles to these files if it is not using them? Even after two reboots.

    Can't think of any logical reason if they're not registered with the instance.

    Are you sure they're not part of a different DB than you're expecting? Do they appear anywhere in this output:

    SELECT physical_name, DB_NAME(database_id) Database_Name FROM sys.master_files