May 11, 2021 at 6:53 am
Locate database files did not get out any .mdf file, even though there is an mdf file in the directory. This happened after I installed a new instance and wanted to attach a database to the instance. The only thing I observed though is that the CU versions of both instances are different. The first instance is 15.0.4033.1 and the new instance is on 15.0.2000.5. Please any idea on why this happend and what can I do to resolve it?
PS: The instances are on a production server. I have an option to install the latest CU but I am not if there wont be problems with the older running instance
May 11, 2021 at 8:24 am
the user that the instance runs under may not have access to that folder - check permissions
May 11, 2021 at 12:23 pm
Thank you very much for the hint. I will give it a try
May 11, 2021 at 5:54 pm
What version of SSMS are you using? There was a bug in one of the older version where you couldn't see the files from the GUI.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
May 12, 2021 at 9:10 am
Hi,
I am using SSMS 18
May 12, 2021 at 10:34 am
It worked when I granted file system permission to NT SERVICE\MSSQL$InstanceName
May 19, 2021 at 7:28 am
are you getting any warning or message popup?
SQL Database Recovery Expert 🙂
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply