July 18, 2018 at 12:44 am
Hello Forum,
i used the query in the screenshot to list all Databases "online" and "offline".
When i look for the Database-Files "test_log.ldf" and "test_mdf"
in the Windows Explorer i can't find them.
Does anybody have an explanation?
July 18, 2018 at 7:06 am
margas - Wednesday, July 18, 2018 12:44 AMHello Forum,i used the query in the screenshot to list all Databases "online" and "offline".
When i look for the Database-Files "test_log.ldf" and "test_mdf"
in the Windows Explorer i can't find them.Does anybody have an explanation?
Have you queried database_files while in the context of that database? What changes were made to the database or it's files?
One issue could be that for whatever reason, sys.master_files is not always up to date until after a service restart when changes have been made to database files. But figuring out whatever is going on is likely related to information about the database itself.
Sue
July 18, 2018 at 7:12 am
Problem is solved. I detached some offline Databases and then the query was showing the right result
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply