Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 26-08-2009
Member
 
Join Date: Jan 2009
Posts: 10
SQL DBA server

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) ?
Reply With Quote
  #2  
Old 26-08-2009
Member
 
Join Date: Dec 2008
Posts: 72
Re: SQL DBA server

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
Reply With Quote
  #3  
Old 26-08-2009
Member
 
Join Date: Dec 2008
Posts: 106
Re: SQL DBA server

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.
Reply With Quote
  #4  
Old 26-08-2009
Member
 
Join Date: Dec 2008
Posts: 98
Re: SQL DBA server

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.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "SQL DBA server"
Thread Thread Starter Forum Replies Last Post
?Server browser is reporting with 0 Server found and 0 filtered? in Red Orchestra 2: Heroes Of Stalingrad Adamya Video Games 5 03-09-2011 10:59 PM
Med-V Inability to upload Packed Image to Server: could not connect to Images Server 2Fast Operating Systems 5 23-08-2010 08:13 AM
Slow Printer Performance on a Clustered Print Server in Windows Server 2003 Nathen Windows Software 5 19-03-2010 01:17 AM
install a xp pro terminal server with windows server 2003 server rossen Operating Systems 3 13-03-2009 05:12 PM
MMC 3.0 user snap-in error (windows server 2003, exchange server 2 RonnyEhv1982 Windows Server Help 1 15-03-2008 12:15 AM


All times are GMT +5.5. The time now is 10:42 AM.