Viewing 15 posts - 28,141 through 28,155 (of 49,552 total)
paul.knibbs (1/26/2011)
The explanation given for that doesn't ring true. What usually happens to cause that comment, in my experience, is that the specifications were extremely...
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
January 26, 2011 at 5:47 am
That is still cut off at the end.
Please run the following and post the full and complete 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
January 26, 2011 at 5:24 am
I suggest that you limit yourself in future to practice tests which are approved by Microsoft.
http://www.microsoft.com/learning/en/us/certification/exam.aspx#tab2
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
January 26, 2011 at 3:59 am
seany1977 (1/26/2011)
ooohhhh Thanks for the information and advice Steve. When I refer to Brain dumps I mean Transcenders, Test King etc are they the same thing?
Transcender, no (at least...
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
January 26, 2011 at 3:56 am
anilkullam (1/26/2011)
Even if this doesn't work, the last option could be issuing the command DBCC shrinkfile ('DB_file',500) with TRUNCATE_ONLY
Truncate_only is ignored when shrinking log files. It has no effect whatsoever....
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
January 26, 2011 at 3:37 am
andy.l (1/26/2011)
Log Space used is 50%.
Which means that the log needs to be at least 2.5 GB in size. Shrink it below that and it will just grow again.
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
January 26, 2011 at 3:36 am
seany1977 (1/26/2011)
Brain dumps are good for knowing 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
January 26, 2011 at 3:30 am
Why do you want to shrink it?
How full is the log? (DBCC SQLPERF(LogSpace)
Check in sys.databases and see what the current value is for log_reuse_wait_desc for this database.
Full recovery I assume....
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
January 26, 2011 at 2:47 am
In that case you need to schedule your log backups at least every 20 minutes. Make sure that they, like your full backups, are copied off the server to some...
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
January 26, 2011 at 2:45 am
Err... 50% of what?
Data loss allowance is typically measured in minutes or hours, it's a measurement of time. It affects how often you schedule the backups, the granularity...
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
January 26, 2011 at 2:22 am
Personally I'd follow the 'single responsibility' rule. If there is nothing in common between what's done on an insert and what's done on an update, they do not belong in...
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
January 26, 2011 at 1:53 am
The errors from the check integrity task are cut off. Please run the following and post the full and complete 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
January 26, 2011 at 1:48 am
Dave Ballantyne (1/25/2011)
Any volunteers to read through a draft of an article for me ?Thanks....
Topic?
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
January 26, 2011 at 1:41 am
tjryberg (1/25/2011)
The only reason I posted was the thought of having to purchase a seperate server just for witness.
You don't need a dedicated server. It can run on 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
January 26, 2011 at 1:03 am
I don't recall such a file. SQL writes errors to it's error log. Files are called ERRORLOG, ERRORLOG.1, etc (current one is ERRORLOG, others are older files). Found in 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
January 26, 2011 at 1:01 am
Viewing 15 posts - 28,141 through 28,155 (of 49,552 total)