As a DBA, do you ever wonder what is going inside your production database? Who is changing database schema during production time without informing you. Now, you need not to worry, you can setup DDL triggers to easily records all changes in table; like what was changed, when and by whom etc. Given is two [...]
Archive for June, 2010
Audit databases – Using DDL triggers
Posted: 5th June 2010 by Deepak in Scripts, SQL DBA, UncategorizedTags: change log, DDL Triggers, DDL_DATABASE_LEVEL_EVENTS, event, event_instance, msdb, sql audit
3
Database Logshipping issues & Considerations!
Posted: 4th June 2010 by Deepak in SQL DBA, UncategorizedTags: DBA, high availability, log, logshipping, mirroring, restore, shipping, sql server
While working on SQL Server logshipping a DBA must consider following points to have log shipping setup running smoothly over a long period of time. Logshipping architect will look like: Transaction log Backup and restoration jobs should work constantly (in parallel) and if backup/restoration jobs are not in sync due to network/server or any other [...]
