0

I am in a weird problem. Firstly some information about our env. We have around 50-55 servers and around 100 instances on them. Backups are configured through netback and that is using Nt Authority\System account. Everything is fine for the 99 instances but in one whenever we enable this account to login some databases go in recovery state. And when we disable the account than we can recover it with normal restore with recovery.

Any pointers will be highly appreciated.

5
  • 1
    Start with the error log. Mar 30, 2018 at 15:11
  • In error log it's saying: FCB open failed: could not open file "\\sharepath" for file number 1 OS error: 32 the process cannot access the file as it's being used by another process.
    – user148074
    Mar 30, 2018 at 15:12
  • 2
    Can you make sure SQL Server database files and folders are not under AV scanning ?. Or just stop the AV and see if you still face the issue
    – Shanky
    Mar 30, 2018 at 15:56
  • Database files are on a share path. And I don't think AV can lead to such problem as in my case. And yes one more thing it's a shared server with more instances and all other are running fine.
    – user148074
    Mar 30, 2018 at 16:00
  • What is the version of that instance? Mar 30, 2018 at 16:22

1 Answer 1

1

In error log it's saying: FCB open failed: could not open file "\sharepath" for file number 1 OS error: 32 the process cannot access the file as it's being used by another process

System account has issues with accessing database files on network share

Can you, perhaps, try this?:

  1. grant full access of [domain\serverName$] to \\sharepath\sharefolder where database files resides
  2. trace if there any open handles to those file, that prevents database to be started
4
  • 1
    For finding open file handles, learn.microsoft.com/en-us/sysinternals/downloads/procmon Mar 30, 2018 at 21:33
  • The service account is already having complete access to the share path. I am not able to understand how can enabling a account to login can lead to such a problem. Everythings running fine, you enable the login and bang you have some databases in recovery state. Doesn't make sense to me.
    – user148074
    Mar 31, 2018 at 3:25
  • @user148074, are your databases set to autoclose? Check sys.master_files to verify you don't have different databases using the same physical files.
    – Dan Guzman
    Mar 31, 2018 at 11:03
  • Checked and found that auto close is indeed switched on, can this lead to such issue?
    – user148074
    Apr 2, 2018 at 6:24

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.