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
 What is the most important thing to take a DBA job

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

Posted - 2011-03-02 : 11:26:02
Makes sure the have backups running, and t log dumps

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx


Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

http://weblogs.sqlteam.com/brettk/

http://brettkaiser.blogspot.com/


Go to Top of Page

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.
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 2011-03-02 : 11:48:45
Pool Dude!!!

OK...

"It was like this when I got here..."



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx


Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

http://weblogs.sqlteam.com/brettk/

http://brettkaiser.blogspot.com/


Go to Top of Page

ajthepoolman
Constraint Violating Yak Guru

384 Posts

Posted - 2011-03-02 : 11:59:26
Thats more like it!

Hey, it compiles.
Go to Top of Page

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
Go to Top of Page

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.
Go to Top of Page

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.
Go to Top of Page

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

Go to Top of Page

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.
Go to Top of Page

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.
Go to Top of Page
   

- Advertisement -