February 19, 2008

Is there a query that you can run in SQL that will tell you which database (if any) has a bad path to its data


My backup software continues to tell me that I have a bad path to a database on one of my servers, but I can not see him when I check manually. I am sure that I am simply disappeared, but I have no idea how to tell where it is. Is there a stored procedure or application that I can run that can tell me if there is a wrong path and where it is?

1 comment:

backup guy said...

(From old blog's comments)
No, because the two things are not related.

You did not say that you are using RDBMS, but the physical path of where one of your database files is expected to be available from your console management DB or similar setup.

Safeguard Your program is claiming that it can not find a file DB where it should be, so it is logical that if you look at where it is said that the file is not, file will not be there.

You will probably rebuild your backup set, tracking down more than what it regards as a programme of "disappeared" DB file.