Viewing 15 posts - 526 through 540 (of 994 total)
Not you Gail, dmoldovan.
March 3, 2009 at 12:20 pm
I don't know of any programs that will do a better job that CHECKDB with REPAIR_ALLOW_DATA_LOSS - if I could do a better job than that (which I wrote) then...
March 3, 2009 at 11:27 am
Well, saying NEVER is too strong. There's a place for using DBCC REBUILD_LOG if there's no other alternative and you have a damaged log on SQL 2000.
Also - posting a...
March 3, 2009 at 11:20 am
It will at least get the new log file and get the database attached. The next thing I was going to suggest is turning off torn-page protection to see if...
March 2, 2009 at 1:42 pm
Yup - the file header page (page 0 in each data file) in the primary data file is corrupt.
Btw - you're running SQL 2000 and this is the 2005-specific forum...
March 2, 2009 at 1:25 pm
Hmm - you've already lost some cdata by running repair. Can you post the results of running CHECKDB again please so I can see what's still left broken?
DBCC CHECKDB (yourdb)...
February 25, 2009 at 6:56 pm
Unmeasurably small - all it's doing is grabbing the first two bits from each of the 16 sectors, storing them in the page header, and then writing an alternating bit...
February 23, 2009 at 2:17 pm
I believe I tested it but I can't remember for sure.
February 22, 2009 at 2:19 pm
The backupXXX tables in msdb are *purely* for historical purposes. They play no role whatsoever in a restore operation - so you can happily delete everything from them and the...
February 21, 2009 at 10:39 am
Yes, but he said that the server was Express - which most likely will be running on the client PC, hosting a local database. Even so, if the PC gets...
February 20, 2009 at 3:27 pm
And to add to what Gail said, also upgrade to SP4 to pick up fixexs for a number of corruption-causing bugs.
February 20, 2009 at 1:46 pm
There was a bug in 2000 SP3 that could cause the corruption errors you posted - it's fixed in SP4.
February 20, 2009 at 7:24 am
Sounds like he means page splits. Point him at this TechNet Magazine article I wrote which explains some more - http://technet.microsoft.com/en-us/magazine/cc671165.aspx
February 19, 2009 at 1:41 pm
There's nothing the application can do to check the consistency of the transaction log - no such capability exists. If the error message occurs only when the application triggers a...
February 18, 2009 at 2:38 pm
Viewing 15 posts - 526 through 540 (of 994 total)