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.
| 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-08f16e944ef1This 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). |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
|
|
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. |
|
|
|
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 |
|
|
|
|
|
|
SQL-Administration