The DBA run a file relocation script to move the physical Database file from where it was running to I:.
ALTER DATABASE [cro01] MODIFY FILE ( name=cro01,filename=N'i:\SQLData\cro01.MDF')
He take the Database offline ad copy the file.
But *for some strange reason* he don't finnish the job correctly. We have now mdf files duplicated and we dont know which one is running. How do I know the "real" running location of the files via a Tsql query? Is it posible? I want to avoid checking manually each disk file location against each sys.master_files entry.
Asked by Sergio Branda
(11 rep)
Nov 15, 2018, 06:14 PM
Last activity: Nov 15, 2018, 08:18 PM
Last activity: Nov 15, 2018, 08:18 PM