Viewing 15 posts - 26,176 through 26,190 (of 49,552 total)
Sorry, wasn't clear. The name of the account means little without access to your network. Is it a local machine account? A domain account? What permissions does it have?
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 11, 2011 at 9:50 am
Ninja's_RGR'us (5/11/2011)
MS should really learn to read their own whitepapers... they'd learn a lot :w00t:.
You mean like Sharepoint? Not.
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 11, 2011 at 9:37 am
Ninja's_RGR'us (5/11/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
May 11, 2011 at 9:32 am
Ninja's_RGR'us (5/11/2011)
Hey Gail, if there had been a clustered index on that table. Could we have guessed at the lost data?
Partially, yes. Would involve identifying the previous and next...
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 11, 2011 at 9:24 am
http://www.google.com/search?q=SQL+Mirroring+error+1418
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 11, 2011 at 9:06 am
JoeS 3024 (5/11/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
May 11, 2011 at 8:46 am
tyson.price (5/11/2011)
- Under what security context does the back-end database get run?I don't know the answer to that. Maybe if you worded it differently.
What account does SQL Server run...
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 11, 2011 at 8:27 am
Then, once you've repaired, get this database into a backup plan of some form. Go and look around your environment for other databases that aren't been backed up. If 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
May 11, 2011 at 8:13 am
No. views are just saved select statements.
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 11, 2011 at 8:11 am
Take the DB into single user mode and run the following.
DBCC CheckDB('lpb_greatplainsutils', REPAIR_ALLOW_DATA_LOSS)
You will lose one page of data in the table ADB_OPEN_YEAR. Since it's a heap, not a cluster...
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 11, 2011 at 8:07 am
Where are the indexes, and what types?
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 11, 2011 at 7:54 am
Ninja's_RGR'us (5/11/2011)
DBCC CHECKDB('db-name') WITH TABLERESULTS, NO_INFOMSGS, ALL_ERRORMSGS
Seconded, though personally I prefer the output without TableResults.
No backup? Someone's not doing their job...
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 11, 2011 at 7:43 am
david.holley (5/11/2011)
Right because for ever column you return that you don't need SQLServer is doing unneccessary work.
And potentially ignoring indexes it could otherwise have used.
The other reason for not using...
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 11, 2011 at 7:32 am
Autoshrink on?
Manual shrink jobs?
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 11, 2011 at 7:25 am
JoeS 3024 (5/11/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
May 11, 2011 at 7:23 am
Viewing 15 posts - 26,176 through 26,190 (of 49,552 total)