Viewing 15 posts - 25,321 through 25,335 (of 49,552 total)
durai nagarajan (6/28/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
June 28, 2011 at 2:45 am
Rich Yarger (6/27/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
June 28, 2011 at 2:43 am
Restore the full. Restore the last differential. If you have log backups restore them all in order. Restore all but the last backup WITH NORECOVERY
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
June 27, 2011 at 3:09 pm
Corruption is a hardware issue. Something is mangling the pages outside of SQL Server. Do some diagnostics on the IO subsystem and consider moving that database elsewhere.
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
June 27, 2011 at 3:05 pm
That's a classic sign of database corruption. Please run the following and post the results. Do nothing else.
DBCC CheckDB('<Database Name>') WITH NO_INFOMSGS, ALL_ERRORMSGS
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
June 27, 2011 at 3:01 pm
Steve Jones - SSC Editor (6/27/2011)
Varies quite a bit, suspect that people are just busy this week getting ready for your vacation.
Plus it's always quieter over a weekend.
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
June 27, 2011 at 3:00 pm
DBCC OPENTRAN is database-specific. Sysprocesses is server-wide. Did you run opentran from the right database?
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
June 27, 2011 at 2:56 pm
http://www.google.com/search?q="SQL+Server"+Server-side+trace
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
June 27, 2011 at 2:54 pm
Illegal_Operation (6/27/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
June 27, 2011 at 2:51 pm
No. I meant these:
http://www.sqlservercentral.com/articles/64582/
http://www.sqlservercentral.com/articles/Transaction+Log/72488/
Hard to copy-paste links when posting from an iPad (which I was earlier)
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
June 27, 2011 at 2:49 pm
aatishpatel (6/27/2011)
I would change the database recovery to simple or bulk logged.
Bulk-logged unless you want to break the log chain and leave the DB open to major data loss risks...
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
June 27, 2011 at 2:48 pm
Well i did say 'if that's the only error' and from the repair output it's clear that was not the only error.
If repair allow data loss won't repair, then 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
June 27, 2011 at 2:45 pm
Cluster as in shared storage windows cluster? If so, be prepared for SQl on the active node to be slow or to fail entirely due to the IO load been...
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
June 27, 2011 at 9:10 am
Go look up my two articles on transaction log management and read them please (no, I don't have the links handy)
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
June 27, 2011 at 9:06 am
You can stripe a backup over multiple devices, but you need to figure out how many to get the size you want.
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
June 27, 2011 at 9:03 am
Viewing 15 posts - 25,321 through 25,335 (of 49,552 total)