Author |
Topic |
tony4SQL
Starting Member
2 Posts |
Posted - 2011-03-02 : 10:56:19
|
I just got an offer from a small company. 10% of my workload will be DBA role. I have passed the MCTS exam but have a little DBA work experience. What are the most important things I need to know during the the job transfering?Thanks a lot!Tony |
|
X002548
Not Just a Number
15586 Posts |
|
ajthepoolman
Constraint Violating Yak Guru
384 Posts |
Posted - 2011-03-02 : 11:29:24
|
Oh man, I was hoping that Brett would have some witty response about learning to blame the network admin or to have a catalog of wordy responses memorized that would imply that someone else broke the database!Hey, it compiles. |
 |
|
X002548
Not Just a Number
15586 Posts |
|
ajthepoolman
Constraint Violating Yak Guru
384 Posts |
Posted - 2011-03-02 : 11:59:26
|
Thats more like it!Hey, it compiles. |
 |
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2011-03-02 : 16:25:08
|
Everything you are going to need to know is clearly explained here:http://sqldumbass.com/CODO ERGO SUM |
 |
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-03-02 : 17:12:15
|
#1 Backup and Restore.#2 Backup and Restore.Then make yourself an expert on SQL Internals (particularly storage), Indexes, and T-SQL. You'll be expected to be able to resolve performance issues, and write T-SQL code that the developers aren't good enough to write. And to optimize what they did write. Understand performance indicators, what and how to measure/monitor. |
 |
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-03-02 : 17:33:37
|
Learn how to make backups WITHOUT using maintenance plans. In fact, learn to make them without using the GUI, just plain ol' T-SQL. Learn how to restore them the same way, and do regular restores against another SQL Server to ensure the backups are valid. |
 |
|
tony4SQL
Starting Member
2 Posts |
Posted - 2011-03-02 : 19:23:16
|
First of all, thanks everybody who read and replied my post. Regular backup and restore is not difficulty for me. Is there any special steps to backup and restore a database with replication (snapshot) on it? How can I find out and monitor all jobs runing on database server?quote: Originally posted by Michael Valentine Jones Everything you are going to need to know is clearly explained here:http://sqldumbass.com/CODO ERGO SUM
|
 |
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2011-03-03 : 06:04:12
|
Have a look at member TKizer's blog/links. She has some routines built that make DBA life nicer. |
 |
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-03-03 : 09:11:56
|
quote: Originally posted by tony4SQL any special steps to backup and restore a database with replication (snapshot) on it?
Nope. You should be backing up the distribution db too though.quote: How can I find out and monitor all jobs runing on database server?
Expand the SQL Server Agent node in Management Studio. It lists all jobs AND has a Job Activity Monitor. |
 |
|
|