January 3, 2010 at 9:21 pm
what is day to day activites in sqlserver dba
January 3, 2010 at 9:30 pm
Have you tried searching online?
If you have started reading a SQL DBA books you should find these in them too.
Any way in short and this is not a complete list...
System Monitoring in terms of security, performance etc.
Troubleshooting SQL system related problems.
Backup / Recovery of databases.
Managing users and permissions.
and many more...
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
January 4, 2010 at 12:16 am
Check to make sure the SQL Server is still online and that you still have connectivity.
Check the NT and SQL Server logs for any errors or problems.
Ensure that no SQL Server job has failed.
Resolve any problem tickets.Close any outstanding change tickets.
Perform the necessary backups, whether transactional or complete.
Check the general health of the server (space, CPU utilization, memory) to confirm there are no issues.
Track locking issues, including deadlocks, blocking, and lock timeouts.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply