1. Check OS Event Logs, SQL Server Logs, and Security Logs for unusual events.
2. Verify that all scheduled jobs have run successfully.
3. Confirm that backups have been made and successfully saved to a secure location.
4. Monitor disk space to ensure your SQL Servers won’t run out of disk space.
5. Throughout the day, periodically monitor performance [...]
Posts Tagged ‘DBA Duties’
SQL Server DBA Checklist
Posted in Microsoft SQL Server, tagged DBA Daily Activities, DBA Duties, DBA Tasks, jshah143, SQL Server DBA Checklist on March 17, 2008 | Leave a Comment »
About Author
Join My DB Group
Database Support
-
Blog Readers
- 154,196 Readers
-
Top Posts
- Error 18456, Severity 14: Login Failed States
- SQL Server 2005 Interview Questions
- DBA Roles and Responsibilities
- SQL Server 2008 Active-Passive/Active-Active Cluster Installation
- SQL Server 2005 Schema, Schema Properties, Schema T-SQL
- System Databases in SQL Server 2005
- How to decide Primary Key column data type in MySQL? Expectation with the Primary Key column
- How to change SQL Server Instance Name?
- How to read transaction log data in SQL Server 2000/2005?
- SQL Server DBA Checklist
Pages
Tags
-
Recent Posts
-
Database Articles- Msg 7391, Level 16, State 2, Line 23 – Error while running Linked Server
- Script – Generate DBCC ShrinkFile for each datbase files
- Login failed for user ‘(null)’. Reason: Not associated with a trusted SQL Server connection.
- DBCC PAGE
- Shrink Log File
- An error has occurred while establishing a connection to the server
- What are the features we can enable using Surface Area Configuration Tool?
- SQL Server Security Interview Questions
- How to change Min/Max Memory in SQL Server?
- SQL Server 2008 Active-Passive/Active-Active Cluster Installation
Category Cloud
-
Top Clicks
Archives
Meta
