Viewing 15 posts - 25,456 through 25,470 (of 49,552 total)
Not the logs themselves (log backups can be mirrored)
If you have two log files, SQL uses them sequentially. There's little-no reason to have multiple log files in SQL.
For the log...
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 16, 2011 at 1:43 pm
sqldba_icon (6/16/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 16, 2011 at 1:17 pm
There's no simple script for that. Try something like RedGate's SQLDataCompare.
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 16, 2011 at 12:55 pm
techzone12 (6/16/2011)
We have an application that uses the database and it's aknown...
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 16, 2011 at 12:54 pm
Sqlchicken (6/16/2011)
Offhand I'd say it looks like you have database corruption on one of your system databases.
TempDB.
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 16, 2011 at 12:46 pm
That's a known bug. Patch your instance to the latest service pack.
The fix is part of SP2 CU3, or just patch to SP4 straight.
(http://support.microsoft.com/kb/939537/ ) Cumulative update package 3...
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 16, 2011 at 12:45 pm
opc.three (6/16/2011)
Not trying to step in front of Gail...my shadow would maybe cover her pinky toe but the thread looked idle...SAVE TRANSACTION is when naming a transaction becomes relevant.
Not what...
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 16, 2011 at 12:06 pm
Post your script.
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 16, 2011 at 11:30 am
jarid.lawson (6/16/2011)
Here's what I understand about computed columns:
Pretty much, yes
I have read this next line many times over, but I'm still not clear about what is being stated here. Can...
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 16, 2011 at 11:28 am
I haven't, I'm busy with deadlock graphs and a performance intervention for a paying client. Maybe someone else has some time (deadlock problems aren't quick)
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 16, 2011 at 11:22 am
Yup. All but the last log backup need to be restored WITH NORECOVERY. The last WITH RECOVERY
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 16, 2011 at 11:20 am
John Aitchison (6/16/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 16, 2011 at 9:15 am
Dynamic SQL, or custom error handling with a temp table or similar (on error insert an error row into the table and then right at the end check whether it...
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 16, 2011 at 8:58 am
Steve Jones - SSC Editor (6/16/2011)
GilaMonster (6/16/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 16, 2011 at 8:56 am
Brandie Tarvin (6/16/2011)
Try naming the Transaction. See if that gets around the error.
Naming transactions does just about nothing. It's a documentation thing (with one minor exception)
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 16, 2011 at 8:08 am
Viewing 15 posts - 25,456 through 25,470 (of 49,552 total)