Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by PS1

  1. PS1

    shrink tempdb

    Hi! I did refresh it. After running the Shrink Database function in EM you get a MsgBox with info about the size after shrinking and it indicated the same size as before... It's curious, isn't it? Thank you for your efforts. Best, PS
  2. PS1

    shrink tempdb

    Hi! Thank you for your suggestions. I tried them, but they didn't work (the model DB was quite small - a few MB...). I managed to shrink the tempdb via SQL Server 2000 Enterprice Manager (my SQL version is 7.0) using the All Tasks->Shrink Database feauture - I don't know why, but it works...
  3. PS1

    shrink tempdb

    Hi! I tried DBCC SHRINKFILE (both via Query Analyzer and Enterprice Manager) before and it doesn't shrink the DB. After restarting the SQL Server Services tempdb still has the same size. Do you have any other ideas? Best, PS
  4. PS1

    shrink tempdb

    Hi! I tried DBCC SHRINKFILE (both via Query Analyzer and Enterprice Manager) before and it doesn't shrink the DB. After restarting the SQL Server Services tempdb still has the same size. Do you have any other ideas? Best, PS
  5. PS1

    shrink tempdb

    Hi All, I have tempdb of allocated space 10 GB of which only 1% is used (SQL Server 7.0). I need to free up the unused space, but shrinking this data base is not working. Could you pls help me with this? Best regards, Piotr
See more

Part and Inventory Search

Back
Top