Viewing 15 posts - 29,281 through 29,295 (of 49,552 total)
ChrisM@home (11/19/2010)
If your birthday's next week I'll eat my hat. Or the remains of my finger.
Your hat is safe. 2 and a half weeks away.
p.s. What's special about next week?
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
November 19, 2010 at 2:28 pm
Tom.Thomson (11/19/2010)
You mean you want to be a year older? :laugh:
I'd be a year older anyway (unless someone's planning on rolling back 2010), I just wouldn't be able to celebrate...
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
November 19, 2010 at 11:02 am
Grant Fritchey (11/19/2010)
GilaMonster (11/19/2010)
Irreparably suspect, no backups.http://www.sqlservercentral.com/Forums/Topic1023390-146-1.aspx
Doesn't say much for my mood that I slightly enjoyed posting that last message there. Wrong, I know.
That's it. We're cancelling Christmas for 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
November 19, 2010 at 9:37 am
Alvin Ramard (11/19/2010)
GilaMonster (11/19/2010)
Irreparably suspect, no backups.http://www.sqlservercentral.com/Forums/Topic1023390-146-1.aspx
Doesn't say much for my mood that I slightly enjoyed posting that last post. Wrong, I know.
Mine was wrong too, but I couldn't resist....
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
November 19, 2010 at 9:26 am
Alvin Ramard (11/19/2010)
In which order do you recommend they do this? Restore old backup first? Or update resume first?
1) Update resume
2) Inform management of the situation (including the reason...
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
November 19, 2010 at 9:23 am
Irreparably suspect, no backups.
http://www.sqlservercentral.com/Forums/Topic1023390-146-1.aspx
Doesn't say much for my mood that I slightly enjoyed posting that last message there. Wrong, I know.
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
November 19, 2010 at 9:15 am
Sqlsavy (11/19/2010)
I tried detaching and attaching but got error while attaching
Quite frankly that was stupid. Once detached a suspect database cannot be reattached without a complex workaround. Never, never,...
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
November 19, 2010 at 9:08 am
Restore from backup. This is not repairable. The last backup that you have is the only real option you have remaining at this point.
Perhaps both the junior DBA and whoever...
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
November 19, 2010 at 8:39 am
What messages are in the SQL error log? (It's a text file, called ERRORLOG. Where it will be depends on where you installed 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
November 19, 2010 at 7:26 am
WayneS (11/19/2010)
Hmm, Jeff is in EST... which means we're in the same time zone. So, I guess 3am is really late - guess he doesn't sleep.:w00t::-P
Or he's like me. Up...
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
November 19, 2010 at 7:23 am
You have no recent backup of a production database???? Whoever's the DBA there is not doing their job.
Ok, the message you posted after the emergency mode repair is normal after...
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
November 19, 2010 at 7:06 am
GSquared (11/19/2010)
Tell him you have a prior appointment with your Stress Management Professional, which your parole officer insists you attend, after that incident with the katanas...
<evil grin> I'll save 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
November 19, 2010 at 6:46 am
Grant Fritchey (11/19/2010)
Bokken's too likely to break.
Not mine. I've got a nice solid white oak bokken. At the tsuba it's thicker than my jo.
Advantage with the jo is 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
November 19, 2010 at 6:38 am
Brandie Tarvin (11/19/2010)
And here's a big ol' U.S. standard baseball bat.
Jo. Bokken. Katana. Baseball bat.
Decisions, decisions....
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
November 19, 2010 at 6:14 am
Gianluca Sartori (11/19/2010)
Gail: You can't afford my weekend rate. Can you?
The PM would say 'of course we can' to that, then leave it up to accounts to dispute the need...
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
November 19, 2010 at 6:05 am
Viewing 15 posts - 29,281 through 29,295 (of 49,552 total)