Good idea, I think i can try that too, Durai. Thanks!

Thank you!

Thanks Durai! My thoughts were like this:

- shutdown the db

- move the files from this disk/drive(X) to another temporary disk/drive(Z)

- perform whatever maintenance to this disk drive X such as...

Thanks 🙂 But, how frequently should i take the backup of this actual files? I mean do they change over time? Can i just take a copy of them...

Found the culprit. It was a 3rd party tool causing this havoc!

Thanks, This is what i did the last time when the master corrupted.

Thanks Jeffrey, This new insight really helped!

Thanks!

Hmm...Looks like theres no way to get a copy of these files (model and master) without bringing the database down first!

Wow, Thanks Steve!

I shall get back after conducting couple of tests. Thanks.

Many Thanks, Markus!

absolutely. copies of system files saves the database when it comes to a reality 🙂

I have heard that it is possible to actually have a copy of those files(system), triggered...

Thanks, Is this something that can be done upfront even before the job actually kicks in (my job is a scheduled task)

Thanks, That aside, is there a way to verify or compare and ensure that both the msdb databases are same. I mean the msdb backup that i had and the...