Viewing 15 posts - 24,901 through 24,915 (of 49,552 total)
http://msdn.microsoft.com/en-us/library/aa260447%28v=sql.80%29.aspx
info: reserved, for internal use only. Hence just ignore 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
July 14, 2011 at 5:58 am
Brandie Tarvin (7/14/2011)
EDIT: Oh, hey! Gail is here! Maybe she can remember what blog post I'm crucifying with my poor memory. @=)
No such blog post.
Maybe you're thinking of this: http://www.sqlservercentral.com/articles/Transaction+Log/72488/
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
July 14, 2011 at 5:49 am
Fixing that error requires Allow_data_loss because of the types of repairs. If those are the only errors, then it can fix without actually discarding anything
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
July 14, 2011 at 5:48 am
Ninja's_RGR'us (7/14/2011)
Steve Jones - SSC Editor (7/14/2011)
GilaMonster (7/13/2011)
Jim Murphy (7/13/2011)
Gail, aren't you a moderator still? Maybe you can just whack that whole thread in Steve's absence.
I've never been a...
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
July 14, 2011 at 5:46 am
Steve Jones - SSC Editor (7/14/2011)
GilaMonster (7/13/2011)
Jim Murphy (7/13/2011)
Gail, aren't you a moderator still? Maybe you can just whack that whole thread in Steve's absence.
I've never been a moderator...
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
July 14, 2011 at 5:42 am
chandan_jha18 (7/14/2011)
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (DB).
There's your answer right there.
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
July 14, 2011 at 5:18 am
Roust_m (7/14/2011)
GilaMonster (7/14/2011)
MCITP SQL 2008 Database Administrator.
This requires that you have already written 70-432 MCTS: SQL Server 2008,...
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
July 14, 2011 at 5:17 am
anuraj2k (7/14/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
July 14, 2011 at 3:02 am
Seriously, it's still bad management. Increase the frequency of log backups or identify the reason why the log is growing.
Large log files don't cause bad performance. A badly configured one...
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
July 14, 2011 at 2:56 am
Please run the following and post the full results
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
July 14, 2011 at 2:48 am
There are 2 SQL 2008 MCITP certifications. Each one requires 2 exams.
MCITP SQL 2008 Database Administrator.
This requires that you have already written 70-432 MCTS: SQL Server 2008, Implementation 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
July 14, 2011 at 2:40 am
That's terrible log mismanagement. You're breaking the log chain, you will not be able to do log backups, so no point in time recovery until, you take another full backup.
That...
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
July 14, 2011 at 2:35 am
If you were marking the transaction that spans the databases I'd agree.
Just having schedules transactions in each individual database every 10 min that mark the log and do nothing else...
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
July 13, 2011 at 4:18 pm
Jeffrey Williams-493691 (7/13/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
July 13, 2011 at 4:16 pm
No.
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
July 13, 2011 at 3:56 pm
Viewing 15 posts - 24,901 through 24,915 (of 49,552 total)