Jamie Scharbrough (1/10/2013)
Now, maybe I'm not looking in the right place, but I can't seem to find any backup schedules. I checked Config Manager, I checked Task Scheduler, I even checked to see if maybe there was just a plain Word doc somewhere.
In the SQL Server itself (when you connect to the engine), there's a node for SQL Agent. Check there, that's where most SQL tasks are scheduled from.
My question is, should I continue in the pattern that was set? (Diffs daily and fulls weekly). It seems about how I'd do it, but I feel REALLY inexperienced.
Normally, yes. This is a solid method of implementing backups. You'll also want to check the recovery model of your databases. If they're in anything but simple, you'll want to check your log backups as well.
Anyone have any basic advice for a (very) new DBA?
Over on the left side of the site, there's a section for books. There's a number of free ebooks in there. Near the top, Troubleshooting SQL Server, a guide for the accidental DBA is basically your #1 read. It'll help you get the keywords and general ideas you need to help you feel more confident in your own research.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA