Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««123

Setting All Tempdb Data Files to the Same Size Expand / Collapse
Author
Message
Posted Tuesday, May 7, 2013 4:12 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, April 9, 2014 7:17 PM
Points: 6, Visits: 269
I tried your method, It didn't worked because when I started the server with single user mode, I myself was not able to access the db..

I tried using ALTER DATABASE and DBCC SHRINKFILE..with EMPTYFILE option and it worked. I documented the process in the below link:

How to Best Remove Extra TempDB Data Files and Log Files

Thanks,
Suresh
Post #1450355
Posted Friday, May 10, 2013 12:25 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, July 23, 2014 1:36 PM
Points: 8, Visits: 176
I'm curious, was the sql server agent running? Anyway, I'm glad you found another way. Thanks for sharing.

Aldo
Post #1451710
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse