• Some of the SMEs are now using VM snapshots/backups as their backup solution rather than a proper SQLServer backup. Works some of the time... Other places rely on the auto close functionality of the database and then use a file level backup agent.

    And with the previous 2 methods emergency mode doesn't always work.

    I always prefer to work with the corporate backup teams who know that a dba is there to help.

    Too many of the places I have seen, even the large companies that ought to know better, dont have any strategy of testing backups. Oh the attitude is new hardware is better, of the 3rd party server host wont have a disaster because of xyz!