Gail Shaw

Forum Replies Created

Viewing 15 posts - 27,151 through 27,165 (of 49,552 total)

RE: last backup date query

Steve Jones - SSC Editor (3/23/2011)
Typically you want to be aware of issues, not making checks to see what has run. That's a bit of a waste of your time....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

March 23, 2011 at 9:28 am

#1302549
RE: SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0x59f6e189; actual: 0x59fae189). It occurred during a read of page (1:40) in database ID 22 at offset 0x00000000050000 in file 'd:\data\ms\sample.mdf'

Sure you can back up the corrupt DB. Totally useless because the corruption will be included in the backup, but you can do it.
You have two options here.
1) Rename the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

March 23, 2011 at 9:11 am

#1302538
RE: 'IS NOT NULL' in LEFT OUTER JOIN

WayneS (3/22/2011)
Check out this 4-part article[/url] by MVP Gail Shaw. (Read the other parts as well - VERY useful information!)
Except this query isn't doing an existence check....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

March 23, 2011 at 9:01 am

#1302534
RE: Differential Restore Problem

That's why I was asking about other product backups. The SAN snapshot may count as a full backup and hence be the base for the diff (taken between the native...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

March 23, 2011 at 8:57 am

#1302531
RE: SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0x59f6e189; actual: 0x59fae189). It occurred during a read of page (1:40) in database ID 22 at offset 0x00000000050000 in file 'd:\data\ms\sample.mdf'

Not repairable, not good.
Do you have a full backup that's restorable? Do you have log backups from that point up until present?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

March 23, 2011 at 8:53 am

#1302524
RE: SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0x59f6e189; actual: 0x59fae189). It occurred during a read of page (1:40) in database ID 22 at offset 0x00000000050000 in file 'd:\data\ms\sample.mdf'

Restore VerifyOnly checks the header and metadata of the backup and not much else. It's perfectly possible for restore verifyonly to succeed and restore to fail. The only way to...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

March 23, 2011 at 8:47 am

#1302519
RE: Shrink Database in Simple Recovery Mode

Brandie Tarvin (3/23/2011)
The act of consuming the cookies (I.E., sticking the data into the data file) makes the affected part of the plate available for checkpointing.
Data doesn't move from...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

March 23, 2011 at 8:35 am

#1302506
RE: How often do you really need dynamic t-SQL?

belgarion (3/22/2011)
Sure, the expense might be a few extra CPU cycles or a few milli-seconds added to a query but servers are dead cheap nowadays and developers are much more...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

March 23, 2011 at 8:33 am

#1302504
RE: How often do you really need dynamic t-SQL?

Discussed here - http://sqlinthewild.co.za/index.php/2011/03/18/q-a-from-24-hours-of-pass-session/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

March 23, 2011 at 8:28 am

#1302498
RE: Shrink Database in Simple Recovery Mode

An extreme simplification, but accurate enough. Though there's nothing 'good' or 'bad' about active or inactive VLFs.
I'd maybe say rather that the cookies are the active VLFs, the empty spaces...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

March 23, 2011 at 8:03 am

#1302469
RE: SQL Server is terminating because of fatal exception e06d7363

Call Customer Support and log a case with them. Make sure you're on the latest service pack first.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

March 23, 2011 at 7:21 am

#1302442
RE: Bulk log recovery

They are enough for doing a restore to the time the log backup was taken, not for doing a point-in-time restore to any random time.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

March 23, 2011 at 5:30 am

#1302399
RE: Are the posted questions getting worse?

Brandie Tarvin (3/23/2011)
jcrawf02 (3/22/2011)
After reading that thread, I want cookies. Thanks a lot, Brandie.
Hee. I am so evil. @=)
I want cookies too, and I love that analogy.
Still bad info being...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

March 23, 2011 at 5:10 am

#1302382
RE: Bulk log recovery

I don't understand your question.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

March 23, 2011 at 5:09 am

#1302381
RE: Shrink Database in Simple Recovery Mode

muthukkumaran (3/23/2011)
Truncating the log file will reduce the logical log (VLF) file size. By default, SQL server truncates the transaction log file OR deletes the logical file (VLF) automatically and...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

March 23, 2011 at 5:07 am

#1302380

Viewing 15 posts - 27,151 through 27,165 (of 49,552 total)