Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-06-03 : 08:23:45
|
| Piyush writes "Hi,I have installed sql server 2000 and databse having data and log files are on Drive C,D and F. I have a free space on drive F. But my tempdb database's log and data file are only on drive C and on D.When i m performing some big insertion operation (approx 14 m records) then my tempdb file is fulled so the transaction being cancelled. So my question is can i create the other tempdb.ldf and tempdb.mdf files on Drive F? I have enough space on drive F. If i can then what are the impact of that? Afterward can i delete that newly created files on drive F?Please reply." |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2004-06-03 : 08:56:02
|
| You can move the tempdb, but you should probably look at your insert operation if it is creating more logs than you need.Moving tempdbTo change the physical location of the tempdb database: Alter the tempdb database, using the ALTER DATABASE statement and MODIFY FILE clause, to change the physical file names of each file in tempdb to reference the new physical location, such as the new disk.Stop and restart SQL Server.Delete the old tempdb database files from the original location-------Moo. :) |
 |
|
|
|
|
|
SQL Server 2000 Tempdb Database full