Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Accidental DBA - Where to Start? (General Question) Expand / Collapse
Author
Message
Posted Wednesday, September 18, 2013 10:23 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, May 22, 2014 8:22 AM
Points: 45, Visits: 139
Hello,

I will be taking over the role of a SQL Server DBA for my company. Our SQL Servers have always been maintained by our Server Admins. I will be going to training in about a week. I would like any suggestions on what I should begin looking at when I come back from training. I am familair with SQL Server Versions 2005, 2008, and 2008 R2 from a developers viewpoint. The DBA role will be new to me. What would be some of the first issues I should address as I take over the responsibility of these databases?

Thanks!
Post #1496006
Posted Wednesday, September 18, 2013 10:34 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 11:42 AM
Points: 13,279, Visits: 12,112
Here is a great place to start.

http://www.red-gate.com/community/books/accidental-dba


_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1496011
Posted Wednesday, September 18, 2013 2:26 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 8:51 AM
Points: 5,587, Visits: 24,942
defyant_2004 (9/18/2013)
Hello,

I will be taking over the role of a SQL Server DBA for my company. Our SQL Servers have always been maintained by our Server Admins. I will be going to training in about a week. I would like any suggestions on what I should begin looking at when I come back from training. I am familair with SQL Server Versions 2005, 2008, and 2008 R2 from a developers viewpoint. The DBA role will be new to me. What would be some of the first issues I should address as I take over the responsibility of these databases?

Thanks!


First let me say ... something that I would make sure my training course covered and covered well, and that is "database backups and restores". Including frequency of backups and restores to a point in time.

For without the data user queries can run fast or slow it matters not.


If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read

Before posting a performance problem please read
Post #1496131
Posted Wednesday, September 18, 2013 2:31 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 12:19 PM
Points: 42,770, Visits: 35,868
defyant_2004 (9/18/2013)
What would be some of the first issues I should address as I take over the responsibility of these databases?


Backups. Integrity Checks. Backups. Restores. Backups. Backups. Backups.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1496135
Posted Wednesday, September 18, 2013 3:14 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 8:33 AM
Points: 36,958, Visits: 31,465
And just in case, backups.

--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1496145
Posted Wednesday, September 18, 2013 3:42 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 3:04 PM
Points: 801, Visits: 715
And to add to Jeff's and Gail's posts: restores. A lot of people take backups. Not everyone restore their backups, or understand how they should do in a disaster scenarios.

There are two important reasons why you regularly should restore your backups (in environment different from production):

1) To make sure that you are familiar with the procedure.
2) The backups are actually good and valid.


Erland Sommarskog, SQL Server MVP, www.sommarskog.se
Post #1496155
Posted Thursday, September 19, 2013 10:45 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, August 15, 2014 6:44 AM
Points: 132, Visits: 246
Did someone mention backups and restores?

Having just finished restoring a blown server which housed our SQL Server instance , I'll put the exclamation point on backups/restores.

To wit -------> !


____________
Just my $0.02 from over here in the cheap seats of the peanut gallery - please adjust for inflation and/or your local currency.
Post #1496492
Posted Thursday, September 19, 2013 4:05 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, August 19, 2014 9:08 AM
Points: 550, Visits: 1,610
If you have available hardware/VM resourses, do one of your practice restores to a non production server just you yourself use and go wild on it. I find my best learning occurs when I've screwed something up and have to fix it, but I suggest doing that on an environment no one else relies on
Post #1496635
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse