Viewing 15 posts - 35,026 through 35,040 (of 49,552 total)
Brian Fischer (1/2/2010)
I still have yet to try some of Gila's other suggestions like:Change page verify to Checksum
Run a checkDB with data purity
Run DBCC UpdateUsage
None of those will do 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
January 2, 2010 at 9:02 am
Are you sure it's the correct log backup?
How are you doing the restores?
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 2, 2010 at 5:21 am
ComITSolutions (1/2/2010)
Is there any other way to the size of LDF file?
Any other way to do what?
Did you read the article I referred you to?
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 2, 2010 at 5:13 am
In simple recovery the log is auto-truncated on checkpoints and transaction log backups cannot be run. C00ler, why are you recommending a switch to full recovery?
Pols, is the replication working?...
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 2, 2010 at 2:22 am
venktsrinivas.gv (1/1/2010)
Pls refer any books with good authour
On what exactly? There are lots of good books with good authors on all sorts of aspects of SQL.
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 2, 2010 at 2:11 am
ComITSolutions (1/2/2010)
You are bang on target. The schedule for back up was disabled. Now by activating schedule the log file size can be reduced???
Full backup or log backup?
If log backup,...
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 2, 2010 at 2:04 am
Please run the following and post the full and complete output.
DBCC CheckDB(<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS
Do you have a clean backup of this database? A backup without corruption?
Take a look...
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 1, 2010 at 12:23 pm
There isn't supposed to be a msdb.log file, so that's not the problem. The MSDB transction log is MSDBLog.ldf
Can you do as the message said and check the SQL error...
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 1, 2010 at 7:00 am
CirquedeSQLeil (12/31/2009)
Try the DBCC UpdateUsage that Gail also suggested.
Won't help performance. That just fixes incorrect metadata.
Somehow I suspect this query is going to need a rewrite to get...
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 1, 2010 at 1:41 am
Happy new year everyone.
Still 5 hours to midnight, but I'm off to a party.
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
December 31, 2009 at 9:41 am
ss-457805's script shows indexes, and only ones where the table has more than 1000 rows. In fact, it will filter out column statistics (stats not associated with indexes) because they...
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
December 31, 2009 at 9:31 am
Per books online (under sys.database_principals)
INFORMATION_SCHEMA and sys
Every database includes two entities that appear as users in catalog views: INFORMATION_SCHEMA and sys. These entities are required by SQL Server. They are...
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
December 31, 2009 at 9:17 am
Create a maintenance plan, drop the 'update statistics' task. Make sure the settings are for all stats and full scan. Save it and run it or schedule it for 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
December 31, 2009 at 9:13 am
Run the stats updates regardless. It's one of the things that has to be done with a 2000-2005 upgrade, it's also the one thing that so many people don't do....
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
December 31, 2009 at 8:57 am
So this is a very recent upgrade? In that case you absolutely must run a statistics update on all tables. The stats from SQL 2000 are not great and 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
December 31, 2009 at 8:35 am
Viewing 15 posts - 35,026 through 35,040 (of 49,552 total)