I am new to SQL 7.0, and I am going to an in residence 70-028 course
Occasionally I have to restart the Server service in order to recreate
the tempdb.mdf file, for it is causing my C: drive to fill.
Can I permanently move/point the tempdb.mdf (and other files like
master.mdf) file to my logical drive which has 100 gig of free space.
My C: drive is typically sized to handle the system/program file only (2
gig in size).
I am sure that I will get all the answers that I need next week, but I
am flying by the seat of my pants this week.
Any options would be appreciated.