Viewing 15 posts - 511 through 525 (of 854 total)
Thank you, any idea what to do next
October 8, 2009 at 2:15 pm
I just ran in and it was succussful
October 8, 2009 at 2:08 pm
Before I run DBCC CHECKDB ({Database Name}) WITH NO_INFOMSGS, ALL_ERRORMSGS. Is this going to cause my webside to go down?
October 8, 2009 at 12:31 pm
corruption happend at 1256 with messages:... page header is all zeroes
(0:0)/(1:11)0/1,
pageno is/should be:objid is/should be:
Getpage: bstat=0x9, sstat=0xa00, cache
lot of them and then
Getpage: bstat=0x9, sstat=0xa00, cache
SqlDumpExceptionHandler: Process 79 generated fatal exception...
October 8, 2009 at 12:27 pm
yes, I have a clean backup. My last transaction job ran at 12 and corruption happend at 1256
October 8, 2009 at 11:57 am
I need actually tool,that would monitor space on server,databases,tables
September 30, 2009 at 12:26 pm
Thank you very much, but still why my logs got smaller,is this beacause Reorganization of Indexes job ran?
September 23, 2009 at 7:20 am
This is what I have:
Database NameLog Size (MB)Log Space Used (%)Status
Db1 130.3672 ...
September 23, 2009 at 7:00 am
Yes, I am running transaction job every 15 minutes and integrity Checks, and Reorganization of Indexes once a week. So the Reorganization of Indexes job ran last night and brought...
September 23, 2009 at 6:51 am
Thank you for this code. I have another question. One of my db, contains this:
DB:
MB Day1 ...
September 23, 2009 at 5:44 am
Thank you, do you know the tool that I can compare the space growing for db.
September 22, 2009 at 8:12 am
I put all of my db here, any suggestions, how can I clean up the drive?
Here is my system db:
master4
mastlog0
modeldev2
modellog0
MSDBData 1674
MSDBLog31
tempdev1544
templog68
Here is db:
DB11827
DB1_log16
Db23
db2_log0
db32
db3_log0
db474
db4_log0
db53
db50
db62
db6_log0
2
db72
db7_log0
db84669
db8_log313
db910
db9_log1
db1011
db10_log24
db1121
db11_log0
21
db1250
db12_log1
db1310
db13_log0
db14500
db14_log211
db1566
db15_log5
db150
db150
db16394
db162
db1715
db17_log0
db1812081
db18_log516
db1976
db19_log5
db19_Log120
db20428
db20_log8
db21 3
db22_log0
db222
db22_log0
db2323
db23_log1
db24236
db24_log0
db252
db25_log0
db267
db261
db272
db27_log0
2
db2837
db28_log19
56
db298
db29_log7
db30732
db30_log837
db313
db31_log0
db322
db32_log0
2
db338
db330
db330
db343
db340
db352
db35_log0
db362
db36_log0
db3755
db375
db3819258
db38_log1
db3910
db39_log0
db4010
db40_log0
db4110
db41_log1
September 22, 2009 at 6:05 am
Viewing 15 posts - 511 through 525 (of 854 total)