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 |
|
kid_on_the_block
Posting Yak Master
172 Posts |
 Posted - 2006-04-04 : 02:18:19
|
| Hi AllWas getting this error Server: Msg 1101, Level 17, State 10, Line 1 Could not allocate new page for database 'TEMPDB'. There are no more pages available in filegroup DEFAULT. Space can be created by dropping objects, adding additional files, or allowing file growth.So went to EM & added another file (Additional file in some other drive ) to the Tempdb , now I want to delete this file ??? What are the steps ... I cant re-start the SQL Server Please help . |
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2006-04-04 : 02:54:33
|
| Allow the file growth.. From Enterprise manager.. right click on the tempdb then click on properties. Under transaction log increase the file growth.. If Debugging is the process of removing Bugs then i Guess programming should be process of Adding them. |
 |
|
|
kid_on_the_block
Posting Yak Master
172 Posts |
Posted - 2006-04-04 : 05:49:17
|
| chiragkhabaria Dear , I want to delete the file I have created ,,,,,, can i do that , if yess please let me knw the processThanks a ton |
|
|
|
|
|
|
|
|
Deleting a file ffrom the DB