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 - 2002-04-02 : 09:00:45
|
| Brian writes "While reading online books I found examples of moving the tempdb to another disk (D:\ to E:\). I did it wrong, it told me wrong or what ever, but now I have 3 different files for tembdb. Your example for moving the file worked like I wanted. However, now I want to remove the other 2 I created in error. I tried the alter database remove file, but get the following error"Server: Msg 5009, Level 16, State 3, Line 1ALTER DATABASE failed. Some disk names listed in the statement were not found. Check that the names exist and are spelled correctly before rerunning the statement."win2k sp???sql7Any help? TIABrian" |
|
|
Jay99
468 Posts |
Posted - 2002-04-02 : 09:55:06
|
| tempdb require at minimum 2 files; a data file and a log file. If you have 3 files, then there is only 1 that you can (possibly) remove. Your error message seems to point to a naming issue.You need to provide more information. What are the logical and physical names of the files associated with tempdb? What is the ALTER DATEBASE statement you are running?Jay<O> |
 |
|
|
|
|
|
Tempdb files