Viewing 15 posts - 24,766 through 24,780 (of 49,552 total)
I'm going to stand by earlier conclusion. Unrepairable, no more that can be done (we're past what's detailed in Paul's blog posts)
If you want to risk buying one of the...
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
July 21, 2011 at 10:54 am
GilaMonster (4/14/2009)
If you're getting them currently, call MS's customer support. If they're old and the problems aren't still occurring, there's no reason to keep the files around.
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
July 21, 2011 at 9:01 am
halifaxdal (7/21/2011)
Ignacio A. Salom Rangel (7/21/2011)
Best guess : It's cleanly shutdown + offline + torn page detection which adds up perfectly.
Thanks for letting us know. Do yuo thing then...
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
July 21, 2011 at 8:59 am
GilaMonster (7/21/2011)
What does that CheckDB (with the database name) give 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
July 21, 2011 at 8:54 am
The restored DB is exactly the same as the old DB. Restore does not change table fragmentation in any way
What's changed is how fragmentation is calculated. SQL 2000 and SQL...
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
July 21, 2011 at 8:29 am
halifaxdal (7/21/2011)
Error 5173: Cannot associate files with different databases.
Could not restart database 'CheckListDB', reverting back to old status.
ALTER DATABASE statement failed.
Log file 'D:\Program Files\Microsoft SQL Server\MSSQL\data\CheckListDB_Log.LDF'...
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
July 21, 2011 at 8:13 am
halifaxdal (7/21/2011)
5. bring it online ------------------Success!!!!! different than last time, but when I open the tables, I see only system tables
Are you absolutely sure that you're querying the correct database,...
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
July 21, 2011 at 8:04 am
Ignacio A. Salom Rangel (7/21/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
July 21, 2011 at 8:02 am
A restore recreates the DB exactly as it was at time of backup. If an index is fragmented at time of backup, it'll be fragmented in the restored database.
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
July 21, 2011 at 7:54 am
halifaxdal (7/21/2011)
Ignacio A. Salom Rangel (7/21/2011)
Try to do it all over again and see if it works this time, something may have happened since yesterday.
Gail, are you on the same...
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
July 21, 2011 at 7:52 am
Looks like it's unrecoverable. If you still can't access the DB in emergency mode then there's no way to access it at all. That was last chance.
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
July 21, 2011 at 7:50 am
And that's after setting the status to 32767?
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
July 21, 2011 at 7:26 am
If the server crashes, all open transactions are rolled back on restart. It's called crash recovery.
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
July 21, 2011 at 7:14 am
The joys of working essentially for yourself. Anything I want (book, hardware, course, exam) I get, I just have to find the budget for it myself.
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
July 21, 2011 at 7:08 am
Fal (7/21/2011)
hor_netuk (7/21/2011)
I know times are hard, but a job alert email subscription delivered me the attached vacancy today. For the record, I won't be applying. 😛Hornet
Might be alright...
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
July 21, 2011 at 2:55 am
Viewing 15 posts - 24,766 through 24,780 (of 49,552 total)