Viewing 15 posts - 40,366 through 40,380 (of 49,571 total)
I'm confused.
murthykalyani (3/13/2009)
Server: Msg 8939, Level 16, State 98, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc...
March 15, 2009 at 12:00 pm
It means that you corrupted a page that gets checked during the attach. That's why I said "if it attaches successfully". Restore a backup, detach and write over in a...
March 15, 2009 at 5:18 am
RBarryYoung (3/14/2009)
OK, this is the most disturbing thing that I have read in a while. Read it closely. Brrrr...
Hey, look on the bright side. Jonathan and Jacob got...
March 15, 2009 at 2:14 am
murthykalyani (3/14/2009)
I didn't run dbcc checkdb instead I ran DBCC checktable with options mentioned by you and gave this error
Please run a full checkDB. I want to make sure that...
March 15, 2009 at 2:08 am
JacekO (3/13/2009)
March 15, 2009 at 2:02 am
Disclaimer: Do not do this to a production database. Do not do this to any database that you care about.
Right, now that's out of the way.
Detach the database, open the...
March 14, 2009 at 9:29 am
GSquared (3/13/2009)
GilaMonster (3/13/2009)
Am I being too harsh here?
Nope.
I've been caught with errors like that before, and you've called me out the same sort of way. I've never taken it...
March 14, 2009 at 3:49 am
ohernandez (3/13/2009)
It exists other option to do it without this problem.
BACKUP LOG TO DISK = ....
March 14, 2009 at 3:34 am
Please run a full checkDB and post the results here
DBCC CHECKDB (< Database Name > ) WITH NO_INFOMSGS, ALL_ERRORMSGS
Do you have a clean backup?
The 'invalid encryption key' confuses me. Are...
March 14, 2009 at 3:34 am
Lynn Pettis (3/13/2009)
Anyone else care to join the fray??
Sorry, no. I've 'engaged' that one before and the threads never end without insults getting thrown around. He takes criticism and correction...
March 14, 2009 at 3:17 am
zbakhramov (3/13/2009)
We have a windows server 2003 with sql server 2000 running in the vmware ESX server and SAN.
Disk queue length is a near-impossible to interpret properly on a SAN....
March 13, 2009 at 1:17 pm
kwilthew (3/13/2009)
The tape backup only picks up the backup files.
In that case, your admin shouldn't be complaining about wasted space. SQL's backups only contain the used space so...
March 13, 2009 at 9:20 am
Viewing 15 posts - 40,366 through 40,380 (of 49,571 total)