Sample Header Ad - 728x90

Where are my files?

1 vote
2 answers
341 views
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