Viewing 15 posts - 27,856 through 27,870 (of 49,552 total)
ALZDBA (2/9/2011)
I hope you get your laptop fixed very soon.
Laptop's fine (fortunately). It's my desktop PC that bluescreened. Not major concerned if it is memory, it's getting a CPU, motherbard,...
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
February 9, 2011 at 12:27 pm
IO subsystem problems. Bad sector is a good potential candidate for the cause.
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
February 9, 2011 at 12:24 pm
clare.xia (2/9/2011)
SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0x6f9014c7; actual: 0x6f903ecb). It occurred during a read of page (2:0)...
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
February 9, 2011 at 12:01 pm
ALZDBA (2/9/2011)
GilaMonster (2/9/2011)
To put things in context, my desktop (which I'll be using for this) blue screened this morning then, on reboot failed POST repeatedly.
Am hoping it's a once-off, or...
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
February 9, 2011 at 11:16 am
Jack Corbett (2/9/2011)
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
February 9, 2011 at 11:15 am
The transaction log is corrupt, specifically the log header. I'm guessing that's the root cause of this.
Export all the data from MSDB and then either copy over from another server...
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
February 9, 2011 at 11:13 am
jeff.mason (2/9/2011)
Brandie Tarvin (2/9/2011)
GilaMonster (2/8/2011)
Craig Farrell (2/8/2011)
LOL! True enough, Saint Gail, Patron Saint of the "Oh Crap, my drives just died!"
LoL.
On that topic, who's joining me tomorrow night?...
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
February 9, 2011 at 7:25 am
Ninja's_RGR'us (2/9/2011)
Well at my rates, 4 days of work would be worth that 1000$ for that single incident.
Depends whether the person is willing to fess up to the manager 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
February 9, 2011 at 6:51 am
MysteryJimbo (2/9/2011)
I'm pretty sure when a drop command is issued, the pointer is removed from the GAM/SGAM but the data pages themselves are not touched.
Correctish, but without the allocation pages...
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
February 9, 2011 at 6:49 am
Ninja's_RGR'us (2/9/2011)
I've got no clue on how the heck they are doing this, but I can't wait to see if it works for the OP!
If it's run soon enough, before...
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
February 9, 2011 at 6:38 am
If you mean database mirroring, no. Database mirroring was introduced in SQL 2005.
If you mean something else, please clarify.
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
February 9, 2011 at 4:48 am
neil.bower (2/9/2011)
Is there an alternative that would include the tables on the linked server too?
Not built in.
Maybe try something like RedGate's SQL Dependency Tracker
http://www.red-gate.com/products/sql-development/sql-dependency-tracker/
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
February 9, 2011 at 4:39 am
It'll do exactly the same thing as taking a normal log backup, then deleting the .trn file.
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
February 9, 2011 at 3:05 am
Point in time recovery is possible in bulk-logged recovery, unless there is a minimally-logged operation within the log over that period.
In a minimally-logged operation, the actual changes are not...
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
February 9, 2011 at 2:55 am
If you implement log shipping you will need to remove the DB from the log backup job. You can write your own log shipping, but it will be a lot...
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
February 9, 2011 at 12:51 am
Viewing 15 posts - 27,856 through 27,870 (of 49,552 total)