Viewing 7 posts - 1 through 7 (of 7 total)
Be sure to run "CHECKPOINT" before dropping the cleanbuffers. Otherwise it may not have the desired effect.
January 4, 2005 at 7:55 am
It sounds like we have two choices:
- Give in to MSFT. Do only simple backups of msdb.
- Set msdb to full recovery mode before each transaction log backup
I am tempted...
November 23, 2004 at 8:38 am
We're having the same problem with a server:
2004-10-20 16:09:10.47 server Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows...
October 26, 2004 at 8:01 am
Milo,
Did you get anywhere? We are having this identical problem on our servers.
Same version of OS you have installed on the server.
SQL Enterprise Server Edition.
2004-10-20 16:09:10.47 server Microsoft SQL Server ...
October 26, 2004 at 7:59 am
Did you solve the DBCC SHOWCONTIG problem?
I've been working on getting DBCC SHOWCONTIG for every database in the server for the last day.
Problem #1: Getting DBCC SHOWCONTIG to execute in...
June 17, 2004 at 7:09 am
>>Have you done a dbcc checktable?
It passed. And I discovered this instance of the table had 0 rows.
I inserted one row and DBCC SHOWCONTIG worked.
Mystery solved: 0 row tables do...
June 17, 2004 at 6:43 am
Yes: DBCC SHOWCONTIG ('TRANSACTIONS') with all_indexes did not return any results.
No variant of it returned results for this table (and some other tables in my database). The only noticeable similarity...
June 17, 2004 at 6:22 am
Viewing 7 posts - 1 through 7 (of 7 total)