Craig Farrell (1/6/2011)

---

3) What will you do if tempdb, transaction log file is full

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.