SQL DBA server

[GULISTAN]

I will return to training in administration database in SQL Server 2005 from Microsoft. I never did any specific courses in Administration database. I would like someone to know a generic or detail if time permits, what are the routine tasks of a DBA (SQL Server 2005) ?

[Caesar]

DBA is who handles the Data Base

• Administer servers DB
• Create databases, tables, and modifies
• Monitor server load, and notes the applications that drive up the load to optimize later
• Optimizes tables (indexing, clustering ,...) to accelerate the execution time of applications including
• Provides privileges to users
• Ensure the backup DB and monitors

[EDRIC]

Something you could not shrink the database

• You could to see if there are open transactions.
  
• If there is no open transaction, you could take a backup of the transaction log, put in simple recovery mode and then put back to the full or bulk log recovery mode and then shrink.
  
• If that action does not work, create an empty data file and take the option to shrink move with all the data to the new data file. If you receive a message, could not transfer all the data to the new data file, is Because there are maybe some who contain table data type Text or image. In that case you need to find Which tables are still in the data file, and then you need to create Those tables with prefix temp and transfer all the data into it. After you delete the original table and rename all tables with prefix temp.
  
• Do not forget to create all constraints, triggers, indexes for the new tables. Create all indexes after the transfer of the data to optimize the transfer time.

[Maceo]

This is SQL Server 2005 comes with reports already designed for ease of analysis on the use of our server.

The best known is the tool with osql or sqlcmd (2005), we execute a query on the SQL Server and if you get an error saying the server is not responding or too long, this indicates that the server is not operational.

Make a NET START Windows service, if it is not in use, it will start and he'll return an error code to inform us if the service has started. However, if you only want to check if the service is started and not automatically start the service, this option is not for you.