Tempdb.mdf and other *.mdf files??

Tempdb.mdf and other *.mdf files??

Post by bryan dimic » Fri, 24 Mar 2000 04:00:00


I am new to SQL 7.0, and I am going to an in residence 70-028 course
next week.

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.



1. clone database from 1 mdf file to multiple .mdf files (.mdf and .ndf)

I need to replicate a 26GB database.  The source database has only 1
logical name and 1 physical file (26GB .mdf file).  Unfortunately, on
my target server I don't have one big file system.  I manage to
combine space by create a new database with multiple files.  But
restore fails because I don't have the same file configuration.  Has
any one successfuly done this type of clone?
I'd love to hear a different approach.

2. Help Data Conversion: ASCII fixed format to MS Access 97

3. Tempdb.mdf / other mdf files ????

4. dBASE IV 2.0 programming question

5. Move all tables from a .ndf file to the .mdf file and eliminate the .ndf file

6. Select chunk at a time ???

7. TempDB.mdf growth in SQL Server 2000

8. VB6/ADO/Access 97 Unsuccessful Query

9. Tempdb.mdf over 2GB??

10. moving Tempdb.mdf for speed

11. How did tempdb.mdf become Read-only?

12. Big size tempdb.mdf

13. How to Convert .DMP file into .MDF file