Viewing 15 posts - 32,881 through 32,895 (of 49,552 total)
A db_owner can do anything to the database, including drop it.
May 14, 2010 at 3:06 am
The mdf is corrupt, no matter what the tool tells you. You've got damage at least to the metadata, that's preventing the DB from going into emergency mode. There could...
May 14, 2010 at 3:02 am
Fal (5/13/2010)
I'd suggest that Gail is otherwise busy right now, so give her some time to get back to you.
Sleeping actually. I'm in one of the european time zones, so...
May 14, 2010 at 2:24 am
Sunil Padarath (5/13/2010)
I get this error when i run set to emergency
Msg 602, Level 21, State 33, Line 1
Could not find an entry for table or index with partition...
May 14, 2010 at 2:23 am
And you're certain there were no other backups made?
What's the restore script that you used?
May 14, 2010 at 2:15 am
CirquedeSQLeil (5/13/2010)
Of course if you want something closer, Mauritius would be a great place to go!!
Little expensive though, and flights around the time of the WC are more expensive than...
May 13, 2010 at 12:37 pm
CirquedeSQLeil (5/13/2010)
GilaMonster (5/13/2010)
BrainDonor (5/13/2010)
May 13, 2010 at 12:16 pm
That I could understand, different SET options so different plans and one entry per plan. However ...
rdouglas66 (5/13/2010)
May 13, 2010 at 12:11 pm
8kb (5/13/2010)
I see. And when I modified the query to include a device_id in the where clause then it used the non-clustered index.
Yup, because now the index is seekable...
May 13, 2010 at 10:39 am
GabyYYZ (5/13/2010)
To all South Africans on the forum here, are you guys excited about next month or is everyone holding their breath?
I'm considering finding a hole and pulling it in...
May 13, 2010 at 10:39 am
fawwad (5/13/2010)
ok so please tell me then what should i do ?
No idea, I don't understand what you're trying to do here. Maybe a bit more of an explanation of...
May 13, 2010 at 10:34 am
Live being server A or B?
If B, then yes, you can restore a diff providing the full backup was restored WITH NORECOVERY, leaving the DB offline and allowing for...
May 13, 2010 at 9:53 am
Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 13, 2010 at 9:49 am
Viewing 15 posts - 32,881 through 32,895 (of 49,552 total)