Viewing 15 posts - 27,571 through 27,585 (of 49,552 total)
Please note: 6 year old thread
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
March 2, 2011 at 12:56 pm
gsundaram (3/2/2011)
I am trying to migrate from sqlserver 2000 to sqlserver 2008R2, but i am facing this error....possible schema corruption,Run DBCC checkcatalog [Microsoft sqlserver error code:211
So did you do...
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
March 2, 2011 at 12:53 pm
ashok_a2004 (3/2/2011)
you try to check this what's this page : is this data page or index page ?
Neither, per the error message it's an allocation page, a page that tracks...
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
March 2, 2011 at 12:49 pm
Post the complete errors please.
Yes, 'dissapearing' corruption is possible, go read Paul Randal's blog posts on that.
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
March 1, 2011 at 11:46 pm
Depends what kind of crash and how bad. If the server is running and the database is still connected and the log is intact, you can do a tail-log backup....
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
March 1, 2011 at 11:45 pm
Please note: 7 year old thread
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
March 1, 2011 at 11:44 pm
NDA
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
March 1, 2011 at 6:33 pm
There's no way to find dependencies in a trace (they're not parent objects, triggers and constraints have parent objects of the tables they belong to, procedures do not).
You can import...
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
March 1, 2011 at 5:56 pm
GRANT SELECT, INSERT, UPDATE, DELETE ON <Table> TO <User>
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
March 1, 2011 at 5:29 pm
Bulk insert into a view? Why?
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
March 1, 2011 at 5:26 pm
Mirroring is predominantly a high availability/disaster recovery solution. Reporting is a secondary usage of it. If you have mirroring and the primary server fails (shuts down, destroyed, etc), the mirroring...
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
March 1, 2011 at 5:25 pm
Ray Laubert (3/1/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
March 1, 2011 at 5:20 pm
No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1071665-1633-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
March 1, 2011 at 5:18 pm
sqldba_icon (3/1/2011)
DO you know of any good affordable performance tuning consultants?
Yup, the person who posted right before you.
where are you in the world and do you want someone onsite?
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
March 1, 2011 at 4:26 pm
Jeff Moden (3/1/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
March 1, 2011 at 4:25 pm
Viewing 15 posts - 27,571 through 27,585 (of 49,552 total)