I have recently changed all my hard drives and in the process of installing some projects I have seen that the database The file I was backing up was actually a wrong file because it had only 30% of the database I was running. I have my old drive and all the data should be intact, but I'm unable to detect the correct database file I'm ...
Is there any way that I can read the physical file location from the dead file SQL Server?
Obtain the master database from the old SQL Server instance and attach it to a new system, or the master database Restore the backup so that you can query it. (Do not overwrite / replace master DB of live system!)
SELECT [Name], system database by file name
You will find a list of databases on that server, and Full file path
Comments
Post a Comment