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 - 2005-06-06 : 08:08:46
|
| Kelly writes "How can I shrink the size of the tempdb database file? I have already tried right clicking tempdb through enterprise manager and selecting shrink database but this does not shrink the whole tempdb file." |
|
|
tomy74
Starting Member
32 Posts |
Posted - 2005-06-06 : 09:50:57
|
| Hi,you can shrink the data file by the following command :DBCC SHRINKDATABASE ... if your problem from log file use the following command :DBCC SHRINKFILE ...if not resized as u which do the following :So make a full database backup and try to delete the large log file and create a small one with growth option and everything will be fine.Thanks,Tarek Ghazali |
 |
|
|
ptegan
Starting Member
7 Posts |
Posted - 2005-06-06 : 10:36:10
|
| I'd guess also that when you start and stop the MSSQL service, tempdb resets itself back to its default size, doesn't it? |
|
|
|
|
|
|
Trucating tempdb