YOUR's SQL SERVER

Tuesday, 12 November 2013

MS SQL Server DBA Checklist

https://docs.google.com/document/d/1pF6_-1MB4j8_KCAG25GuP0gMWsmBy0qkPyyhRyiZyeE/edit?usp=sharing
Posted by sunny at 06:23 No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Newer Posts Older Posts Home
Subscribe to: Posts (Atom)

Translate

Subscribe To

Posts
Atom
Posts
All Comments
Atom
All Comments

YOUR's SQL SERVER

Loading...

Popular Posts

  • DBA TASKS FOR DAILY / WEEKLY / MONTHLY
    DBA TASKS FOR DAILY / WEEKLY / MONTHLY Daily Tasks: The following tasks should be completed on a daily basis: Check to make sure t...
  • Log Shipping Administration & .TUF File
    Administering and Managing Log Shipping Log shipping is one of four SQL Server 2005 High-availability solutions. Other SQL Ser...
  • DBA DAILY RUNNING SCRIPTS
    DBA DAILY RUNNING SCRIPTS Checking free space in all drives EXEC master .. xp_fixeddrives To Run a failed job by a single T-SQL...
  • SQL DBA SCRIPTS
    SQL DBA SCRIPTS How to extract Litespeed file and convert it into native backup file Please find the extractor.exe file on the syst...
  • A Better sp_who2 using DMVs (sp_who3)
    A Better sp_who2 using DMVs (sp_who3) The following code generates the same information found in sp_who2, along with some additional t...
  • DBCC and SP_Commands
    1.DBCC CHECKALLOC DBCC CHECKALLOC checks page usage and allocation in the database. Use this command if allocation errors are found for t...
  • ERwin Data Modeler Error: Unable to locate client connectivity software
    ERwin Data Modeler Error: Unable to locate client connectivity software When first trying to connect to SQL Server from an installati...
  • DBCC Commands Daily using Commands and Examples
    DBCC Commands Daily using Commands and Examples   1. xp_fixeddrives  ----- how much free space for all the drives.   2. dbcc sqlperf...
  • SQL Server Monitoring Checklist
    SQL Server Monitoring Checklist 1. Make sure each of your production databases are available and accessible to their users. 2. Check a...
  • How to Update Statistics
    How to Update Statistics There are two ways to update statistics. The first way is the easy way. It is one line of code that will upda...

Blog Archive

  • ▼  2013 (137)
    • ▼  November (1)
      • MS SQL Server DBA Checklist
    • ►  September (136)

Total Pageviews

Subscribe To

Posts
Atom
Posts
All Comments
Atom
All Comments
Picture Window theme. Powered by Blogger.