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 |
|
eashoori
Starting Member
22 Posts |
 Posted - 2009-02-15 : 17:09:09
|
| Our SE have stoppped schedule of backing up trancation logs since last week, it would be temoporary, howver yeterday I manually backed up the logs that were greater than .5 GB and shrank those log files just to be safe for weekend. we still have over 1.3 TB space on drive, however looking at tempdb data file has negative space as well as log file has negative -5130% MB, I am concerned as I have never seen nagative for tempdb space options, please advise. should I be take any other action? As tempdb is simple recovery and I can't backup the log. Should I add that this is sharepoint db and it is on clustred environment. PLeae give me any advice and put my mind at ease.Thank yoiu a lot |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-15 : 17:37:02
|
| You can't backup TEMPDB at all. You should never shrink files unless you are in dire needs of space.Shrinking affects performance and will grow again. Well, for TempDB restarting SQL Services in offhours will create new fresh tempdb . I have never seen -ve % as well. |
 |
|
|
heavymind
Posting Yak Master
115 Posts |
|
|
|
|
|
tranaction log backup, Negative tempdb space?