| Author |
Topic |
|
BBassic
Starting Member
10 Posts |
 Posted - 2012-04-04 : 12:57:56
|
| Firstly, allow me to apologise if I've posted this in the wrong place.I've been asked to move from my current role as customer services manager into a new role as our companies DBA. I have some experience with SQL server, things like query building etc. but not much experience as an administrator.It's going to be one of those learn on the job deals with a bit of budget going towards courses and training but the majority of my developing this fledgling career is going to be self-taught. Can you give me any tips like essentials that any good DBA needs to know?Thanks for any help you can giveChristopher |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2012-04-04 : 14:35:23
|
| Get this, read it. [url]http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/[/url]--Gail ShawSQL Server MVP |
 |
|
|
BBassic
Starting Member
10 Posts |
Posted - 2012-04-05 : 05:33:56
|
quote:
Originally posted by X002548
quote:
Originally posted by BBassicI've been asked to move from my current role as customer services manager into a new role as our companies DBA.
HOLY COWStart by making sure you are doing backups on a regular basisBrett8-)
Yeah it was quite a shock. Very welcome though. I've done everything I can in my current role so I was looking for a new challenge. |
|
|
|
BBassic
Starting Member
10 Posts |
Posted - 2012-04-05 : 05:34:21
|
quote:
Originally posted by GilaMonster
Get this, read it. [url]http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/[/url]
That looks fantastic, thank you |
|
|
|
Xiez
Starting Member
13 Posts |
Posted - 2012-04-06 : 18:21:51
|
| I'm sort of in the same boat. I'm a database programmer thrown into the DBA slot. It's not quite as scary for me since I have a good knowledge of sql, but, like you, not much knowledge on the admin side. Good luck, and welcome to the IT world! :-p |
|
|
|
BBassic
Starting Member
10 Posts |
Posted - 2012-04-10 : 05:19:28
|
quote:
Originally posted by Xiez
I'm sort of in the same boat. I'm a database programmer thrown into the DBA slot. It's not quite as scary for me since I have a good knowledge of sql, but, like you, not much knowledge on the admin side. Good luck, and welcome to the IT world! :-p
Thanks!I have a bit of SQL knowledge. I've been assisting our development team for three years in varying capacities. Usually just involves writing stored procedures and data querying. But, the administration side of things is a completely different kettle of fish. Or at least it seems so. |
|
|
|
BBassic
Starting Member
10 Posts |
Posted - 2012-04-11 : 12:24:17
|
| I have a question here about back-ups, I was hoping someone could help me with. The MSDN entry about Full and Bulk-Logged backups states that a database backup is insufficient and would also require a transaction log backup, but it doesn't state (at least not to my untrained eyes) why a database only backup is insufficient. Could anyone shed some light? |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-04-11 : 13:19:36
|
| The transaction log is separate from the data files. It continually logs information until it is backed up, or truncated manually. This can cause the transaction log to grow until (or unless) there is no more disk space, at which point the database will go offline.The Simple recovery model truncates the log every time it flushes transactions to disk, this prevents the log from growing too large. Consequently, you can't make log backups in Simple recovery, and therefore can't do point-in-time restores, log shipping, database mirroring, or transactional replication. Full and bulk-logged don't truncate the log, so regular backups are required to maintain size and recoverability. |
|
|
|
|
Beginners questions