SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 SQL-Administration
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

garywsims
Starting Member

1 Posts

Posted - 05/09/2013 :  18:02:02  Show Profile  Reply with Quote
Where should I start want to become sql administrator.

robvolk
Most Valuable Yak

USA
15676 Posts

Posted - 05/09/2013 :  19:18:16  Show Profile  Visit robvolk's Homepage  Reply with Quote
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
Flowing Fount of Yak Knowledge

United Kingdom
2067 Posts

Posted - 05/10/2013 :  01:43:37  Show Profile  Visit jackv's Homepage  Reply with Quote
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 - 05/14/2013 :  04:20:21  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

United Kingdom
2067 Posts

Posted - 05/14/2013 :  06:51:37  Show Profile  Visit jackv's Homepage  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000