system databases data and ease of rebuild
Posted on 2014-08-11
I have the read that the master DB is crucial for an effective MSSQL backup and restore policy – but when looking at why people said it stores login information? Excuse my ignorance but if it’s just a username and password is that a real big deal to just fresh install MSSQL and create the same or a new set of usernames and passwords? Or am I missing something? It doesn’t sound a massive issue.
Also someone mentioned “agent jobs”, what kinds of things are these agent jobs doing? And how hard are they to setup from scratch to match those preconfigured before? Is it easy to re-setup or a nightmare if you don’t have a backup?