i managed to shrink tempdb but i'm still having the same error when i run the create database

how can i alter the size of tempdb which currently is 5GB because i thought stoppping and restarting sql server should do this.

the create statement specifies that the initial size = 2

model is 12MB

one thing i've noticed is tempdb to be 5120MB and i'm unable to do anything about this because i thought if you restart sql it should clear tempdb.

checking from explorer i've got at least 23GB of space left

luckily yes they are, and it worked thanks

thanks guys, all sorted with a clever vb script. thanks

yep thats what i've decided to do. thanks for your help

nothing, i just thought maybe i can have a sp to run that can generate this for me anytime i want

Yes I have even with 'active'

thanks all, your responses is greatly appreciated.

managed to stop the offending process by stopping the process from windows...thanks

How do I make the database suspect?

thanks guys just did a test backup and restore now...