GilaMonster (1/6/2011)
Craig Farrell (1/6/2011)
Best way to start that research is get yourself a small partition on a drive (usually your C:\ is smaller), create a database, and fill it with stuff until your Transaction Log is out of room. You'll get some errors. Start researching those errors. It's a common issue.Good idea, but I'd suggest limiting the size of the log, not filling C drive up. Windows gets a little twitchy when there's no free space on C.
Spoiling all my fun, Gail. The best way to learn how to deal with a truly fragged up computer is to make one. Sadly... I've actually walked onto a site that had a server like that. That was an experience to get going again as a glorified Level I thinking I was actually good at my job. 😉
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