You can either stop and start the SQL services (this will refresh the
db) or
backup tran tempdb with truncate_only
You can DBCC Shrinkfile if the size is way out of line. Be sure not to
shrink it too small as an auto-grow will impact performance.
-----Original Message-----
From: Bellizzi Christopher Joseph
[mailto:mssqldba-ezmlmshield-x42832664.[Email address protected]
Sent: Friday, February 29, 2008 12:50 PM
To: LazyDBA Discussion
Subject: RE: Please help!!!!!1
Reboot.
PAYCHEX
Christopher Bellizzi
Information Technology * Database Administration
675 Basket Road * Webster, New York 14580
(585) 216-0670 * [Email address protected]
-----Original Message-----
From: Ramesh Phogat
[mailto:mssqldba-ezmlmshield-x81965363.[Email address protected]
Sent: Friday, February 29, 2008 1:42 PM
To: LazyDBA Discussion
Subject: Please help!!!!!1
Hi All,
Suppose my TempDataBase is full then what we do for this ?
Kindly give the Solution for this .How to resolve that problem?
What are steps to do for this? Could anyone some insight on this?
Thanks & Regards
Ramesh Phogat
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
-----------------------------------------
The information contained in this message may be privileged,
confidential, and protected from disclosure. If the reader of this
message is not the intended recipient, or any employee or agent
responsible for delivering this message to the intended recipient,
you are hereby notified that any dissemination, distribution, or
copying of this communication is strictly prohibited. If you have
received this communication in error, please notify us immediately
by replying to the message and deleting it from your computer.
Thank you. Paychex, Inc.
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
DISCLAIMER:
The information contained in this e-mail may be confidential and is intended solely for the use of the named addressee. Access, copying or re-use of the e-mail or any information contained herein by any other person is not authorized. If you are not the intended recipient please notify us immediately by returning the e-mail to the originator.
MS Sql Server LazyDBA home page