Viewing 15 posts - 32,911 through 32,925 (of 49,552 total)
Didn't you know, RAID means that you don't need backup. *cough*
The upgrade error message worries me....
May 13, 2010 at 3:22 am
That's not how they'd appear in the log (msg number would be folowed by the message itself), but I suppose good enough.
Now, about that upgrade message. Please don't tell me...
May 13, 2010 at 3:20 am
Alert: 3 year old thread.
Even as a single user, you cannot guarantee that SQL will return data in a particular order without an ORDER BY. If, however there is an...
May 13, 2010 at 3:11 am
BrainDonor (5/13/2010)
May 13, 2010 at 3:01 am
Upgrade? Please don't tell me that you're trying to attach this to a different version of SQL to what it was originally attached.
Messages and error numbers appear mangled. Please post...
May 13, 2010 at 3:00 am
The clustered index (primary key) is on the ping_time, device_id column. The only where clause predicate you have is on the ping_time column. Hence it makes sense to use the...
May 13, 2010 at 2:56 am
Consultants don't want to work for free? How unfair of them. They should remember there are people stuck in jobs they can't do, and drop everything to give these people...
May 13, 2010 at 2:48 am
Looks like the diff doesn't belong to that full backup. Maybe there was a full backup somewhere in between.
Which of the backups are you trying to restore, in which order?
p.s....
May 13, 2010 at 2:35 am
Open the SQL error log, find all errors relating to this DB (from the time of the attach) and post them.
May 13, 2010 at 2:32 am
What's the state of the database? Query sys.databases (a view) and check the value of the status_desc column.
May 13, 2010 at 2:28 am
Sunil Padarath (5/12/2010)
this was in production environment and we do not have a backup.
Why the hell not? How can you, as the DBA, possibly justify having no backups of a...
May 13, 2010 at 2:12 am
Restore from backup.
Your transaction log is damaged and the database was not cleanly shut down. SQL's hitting the corruption while trying to do it's restart-recovery (which is essential to get...
May 12, 2010 at 3:40 pm
lcaruso (5/12/2010)
...and I was about to ask if the exec plan estimator was dumber than a DBA...
Depends on the DBA...
I'm calling from an external program in a loop for every...
May 12, 2010 at 3:00 pm
dma-669038 (5/12/2010)
... but these tables are small (under 20000 records) and i would not expect the optimiser to use an index on them....
I would. 20000 is not small and it's...
May 12, 2010 at 2:55 pm
Viewing 15 posts - 32,911 through 32,925 (of 49,552 total)