Viewing 15 posts - 32,881 through 32,895 (of 49,552 total)
A db_owner can do anything to the database, including drop it.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 14, 2010 at 2:15 am
Toast. As in 'your database is ...'
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 13, 2010 at 3:15 pm
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 13, 2010 at 12:37 pm
CirquedeSQLeil (5/13/2010)
GilaMonster (5/13/2010)
BrainDonor (5/13/2010)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 13, 2010 at 10:34 am
No.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 13, 2010 at 10:08 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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 13, 2010 at 9:49 am
Viewing 15 posts - 32,881 through 32,895 (of 49,552 total)