Viewing 15 posts - 1 through 15 (of 18 total)
The database files are on a Netapp WAFL lun, inside a volume, that single volume file was accidentally lost.
A disk block restore was made, but it's obvious that not all...
October 4, 2011 at 7:25 am
The database is a statistics and analysis system, and actually the structure is more important than the data.
Structure as in schema? Can't you derive that from the application(s) accessing the...
October 4, 2011 at 7:22 am
Restore or IO subsystem glitch (since the log was on a disk that's 'very gone', it's not a stretch to think that there are other IO subsystem problems). I think...
October 4, 2011 at 6:48 am
How exactly was the database "wiped" and what exactly was restored? All files from scratch or only some files/blocks?
All your errors stem from the fact that your PFS pages seem...
October 4, 2011 at 6:36 am
skrilla99 (9/15/2011)
But, what I am left wondering is, where are the precision and scale defined?
Just to geek out:
They're stored in the sys.sysrscols base table (accessible only from the DAC, commonly...
September 16, 2011 at 1:52 am
Paul Randal (9/15/2011)
I can think of all kinds of things I'd like to make it say...
Baaaaaaaaahd corruption encountered?
September 15, 2011 at 3:12 pm
GilaMonster (9/15/2011)
Mark S. Rasmussen (9/15/2011)
September 15, 2011 at 3:05 pm
Decimals use a whole byte to indicate whether the number is positive or negative - basically a sign bit taking up a dedicated byte. Next we have 1-4 x 4...
September 15, 2011 at 2:34 pm
No prob! I took the liberty of elaborating a bit more on my blog since you're not the only one unable to find the behavior cleanly documented on the net.
July 18, 2011 at 2:48 pm
That is in no way a stupid question, one that's stumped me too.
Although [SQL Server 2008 Internals] by Kalen Delaney et. al. mentions that SQL Server will store (MAX) data...
July 18, 2011 at 10:11 am
alen teplitsky (5/16/2011)
Mark S. Rasmussen (5/16/2011)
One thing is fixing the corruption, but I'd be very wary of just restoring...
May 16, 2011 at 9:42 am
Interesting story! You don't mention anything about what caused the corruption however?
One thing is fixing the corruption, but I'd be very wary of just restoring the system back the way...
May 16, 2011 at 1:35 am
I ended up fixing this the hard way that I'd hoped to avoid.
I was storing my DataContext in HttpContext.Current.Items. Since I did not do any explicit threading during my request,...
October 14, 2009 at 10:46 am
The performance counter SQLServer:Databases\Transactions/sec will give you the number of transactions per sec. Monitoring this counter over a suitable period of time will give you an average max/min number of...
June 4, 2009 at 8:50 am
You're right Mark; what you're describing is going to perform sub-optimally because it's going to behave like a fragmented disk. If you've got the space/budget you would get the...
March 29, 2009 at 4:41 pm
Viewing 15 posts - 1 through 15 (of 18 total)