Often we find ourselves troubleshooting outages which may have been caused by the physical server or virtual machine being unreachable rather than the database service itself being unavailable. End-users don’t know this. They simply call and say that the application or database is not working. We may try to access the database via SSMS or SQL Developer. If that fails, […]
Simple Restore Script
The SIMPLE_RESTORE script is useful if: You work in a company whose security policy requires that you write your own backup solution and present it before it gets put into production You cannot touch the production server because it is managed by a third party vendor but you do have access to the backups. You have no control over the […]