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 |
|
carumuga
Posting Yak Master
174 Posts |
 Posted - 2009-08-14 : 02:00:16
|
| I was trying to shrink the tempdb database file, scheduled as a job.I got this below couple of times.Cannot shrink log file 2 (templog) because total number of logical log files cannot be fewer than 2. (but the step succeeded)Could you please explain me the process to get ride of this error and the root cause.Thanks in advance. |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2009-08-14 : 18:10:49
|
| Can you supply the exact command you are executing? Or are you using the UI?=======================================Men build too many walls and not enough bridges. -Isaac Newton, philosopher and mathematician (1642-1727) |
 |
|
|
carumuga
Posting Yak Master
174 Posts |
Posted - 2009-08-17 : 00:07:58
|
| These are the commands i'm using it.dbcc shrinkfile(tempd,1)godbcc shrinkfile(tempdR,1)godbcc shrinkfile(templog,1)godbcc shrinkfile(templogR,1)go |
|
|
|
|
|
|
DBCC Shrinkfile - error msg