question

jhowe avatar image
jhowe asked

advice full transaction log / disk then large tempdb ***URGENT***

hi all i need some advice in the following situation. Detected sharepoint was bigger than it should be and had a 10gig tran log (in simple recovery). Ran DBCC shrinkdb to clear log and attempt to shrink db. TEMPDB went up to 6 gig and ran out of space on C:. I've stabilised it for now but still have a 5gig tempdb and only 1 gig left on C:. mdf and ldf files are on other drives with lots space. Just want to know best way forward to clear tempdb, either by shrinking tempdb database/file, detaching/moving or restarting SQL service? fast response would be much appreciated...
sql-server-2005sharepoint
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
JohnM avatar image
JohnM answered
If you can afford an outage, I'd move tempdb to it's own LUN/disk if at all possible. I'd definitely get it off the of the C: drive if possible even if it has to share with the other databases. Pinal Dave has a quick article on moving tempdb along with a demo script: http://blog.sqlauthority.com/2007/04/01/sql-server-tempdb-is-full-move-tempdb-from-one-drive-to-another-drive/ It will require a restart of SQL Server to complete the move. Hope this helps!
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

jhowe avatar image jhowe commented ·
thanks john, we're going to try and virtualise the server, then move tempdb off the C:\! Obviously this was setup before my time as having db's on the OS drive is a bit stupid if you ask me! ;)
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.