Viewing 15 posts - 27,991 through 28,005 (of 49,552 total)
From the message he missed one or more files. All of the files involved have to be from the same database, you can't mix and match (that includes the log...
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
February 2, 2011 at 6:26 am
sys.dm_db_index_usage_stats is the DMV for that. What in there is confusing you?
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
February 2, 2011 at 5:53 am
Grant Fritchey (2/2/2011)
GilaMonster (2/2/2011)
Grant Fritchey (2/2/2011)
Another reason you might not see a plan in cache was if it was a trivial plan, but that's not the case here.
In SQL 2005...
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
February 2, 2011 at 5:52 am
Nothing else? No details in the referenced hyperlink?
Can you try and attach using t-SQL script? (the dialog can generate the code for you, there's a script button at the top)....
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
February 2, 2011 at 5:06 am
If the file headers are damaged, 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
February 2, 2011 at 5:04 am
Grant Fritchey (2/2/2011)
If you have anyone there helping you, task them immediately with getting your backups prepared for a restore operation.
Backups? What are backups?
sourav_1002001 (2/2/2011)
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
February 2, 2011 at 4:51 am
sourav_1002001 (2/2/2011)
when i tried to attach the .mdf file it is showing the error c:\ [the path]\solarwinds_data.mdf is not a primary database file ,
As far as I know, that implies...
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
February 2, 2011 at 4:49 am
Grant Fritchey (2/2/2011)
Another reason you might not see a plan in cache was if it was a trivial plan, but that's not the case here.
In SQL 2005 even trivial plans...
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
February 2, 2011 at 4:41 am
What is the full error message you get trying to attach 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
February 2, 2011 at 4:40 am
mavelzen (2/2/2011)
The amount of data is (for a database) not that significant IMO, at most 20k rows.
Not significant to a database, but SQL will escalate row locks to table...
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
February 2, 2011 at 4:29 am
What's the full error message? (I don't memorise error numbers)
Do note, there may not be a solution here, depending how bad the corruption is. I'll help as much as I...
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
February 2, 2011 at 4:20 am
Koen (da-zero) (2/2/2011)
Koen (da-zero) (2/2/2011)
This is a weird thread:http://www.sqlservercentral.com/Forums/Topic1057267-391-1.aspx
Ugh. If someone else wants to skip in on this thread.
Apparently English doesn't work...
Maybe gibberish?
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
February 2, 2011 at 4:15 am
Here's your 'hacker''s other question
http://www.sqlservercentral.com/Forums/Topic1057295-391-1.aspx
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
February 2, 2011 at 3:13 am
In most cases, Async network IO waits are cause by applications that are slow to handle the resultset returned by sQL. Can be something like complex processing between each row,...
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
February 2, 2011 at 2:47 am
Can you elaborate on 'No cache plan is generated'? What exactly are you seeing and what's not happening that you think should be happening?
Edit: Could it be this?
A batch...
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
February 2, 2011 at 1:19 am
Viewing 15 posts - 27,991 through 28,005 (of 49,552 total)