Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 SQL-Administration

Author  Topic 

garywsims
Starting Member

1 Post

Posted - 2013-05-09 : 18:02:02
Where should I start want to become sql administrator.

robvolk
Most Valuable Yak

15732 Posts

Posted - 2013-05-09 : 19:18:16
Backup and restore. Nothing is more important for a DBA than to learn, perform and understand backup and restore for databases and logs.

This will get you started: http://msdn.microsoft.com/en-us/library/ms187048.aspx (read the sidebar articles too)

These will teach you syntax: http://msdn.microsoft.com/en-us/library/ms186865.aspx
http://msdn.microsoft.com/en-us/library/877ecd57-3f2e-4237-890a-08f16e944ef1

This will make you very good at it: http://www.sqlskills.com/blogs/paul/category/backuprestore/

You are not proficient in backup/restore until you can do it from memory in a query window. It's not enough to know how to do them through the GUI.

Once you've mastered that you can investigate other backup options (SAN snapshot, 3rd party disk replication, DPM/Arcserve/BackupExec vs. LiteSpeed/Redgate backup utilities) and how they work (or don't).
Go to Top of Page

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2013-05-10 : 01:43:37
Agreed about Backup and Restore. Those skills need to be enhanced by incorporating other DBA skills, to become a more rounder DBA, such as : security management, object management, performance management etc. Some other essential DBA skills notes on : http://www.sqlserver-dba.com/2013/01/sql-server-i-want-to-become-a-dba-what-should-i-first-learn-.html

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

srimami
Posting Yak Master

160 Posts

Posted - 2013-05-14 : 04:20:21
The reading of blogs/manauls gives you only 20% of knowledge; you will learn 80% of skills on Job.
Go to Top of Page

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2013-05-14 : 06:51:37
Hands -on- experience is very imporatnt but it is easy to fall into bad habits - and not focus on the critical tasks of the DBA . Reading blogs introduces you to many advanced concepts , particuarly with SQL Server - which doesn't have great product documentation - in comparison to DB2 or Oracle .

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page
   

- Advertisement -