SQL server standard procedures
Posted on 2011-09-20
I have to create standard procedural documents/templates for our SQL servers.
-SQL database backups and log backups (includes how to track and verify daily db backups)
-SQL server patching (procedure)
-Setup New SQL server for development/UAT etc ( create template to store information to setup new server which should include database, permissions, owner, approvals etc.)
-Replication (check records in sync)
-SQL daily checks (include backups, jobs disk space etc.)
If anybody have any templates or documents or any kind of procedures for any of these and would share it I would really appreciate it.