Viewing 15 posts - 24,796 through 24,810 (of 49,552 total)
halifaxdal (7/20/2011)
The DB is in suspect modeI tried to set the emergency mode but failed
Hang on, you first said the DB is not in the list, then you said it's...
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 20, 2011 at 10:41 am
So the DB that you created is no longer there? (the one you created in order to swap the files out)
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 20, 2011 at 10:25 am
Did the hack attach work (create new DB, stop SQL, swap files, start SQL)?
Do you see the database in the list?
Is that it's full name?
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 20, 2011 at 10:23 am
Ninja's_RGR'us (7/20/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 20, 2011 at 9:51 am
Grant Fritchey (7/20/2011)
It can only be people who chose to register for one of those other pre-cons... THOSE people.
So at tea break, we run into Rob's session work on reducing...
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 20, 2011 at 9:50 am
Drop the database (make sure you have copies of the damaged data file)
Repeat the hack to get the DB visible, but do not set offline to swap the files, stop...
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 20, 2011 at 9:47 am
Jim Murphy (7/20/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 20, 2011 at 9:43 am
Wow, normally people are complaining that the log file is too big...
Leave the files alone unless you have a really good reason to do otherwise.
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 20, 2011 at 9:30 am
halifaxdal (7/20/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 20, 2011 at 9:15 am
Ninja's_RGR'us (7/20/2011)
Can I register and pay and then not go?
Sure. Massive waste of money, but...
Can we register to precon and not the rest of it?.
I don't believe so. Would be...
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 20, 2011 at 8:36 am
And error 9904 is...???
Was that from attach, or from the hack method from my blog? That's partially valid for SQL 2000, up until the set emergency which has to be...
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 20, 2011 at 8:35 am
Brandie Tarvin (7/20/2011)
Speaking of DVDs, who gets the proceeds of the Summit DVDs? Do the presenters get any cut of that at all?
Proceeds to PASS, presenters don't get anything.
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 20, 2011 at 8:22 am
Ninja's_RGR'us (7/20/2011)
GilaMonster (7/20/2011)
Ninja's_RGR'us (7/20/2011)
GilaMonster (7/20/2011)
Jeff Moden (7/20/2011)
I understand that Gail Shaw will be co-presenting with you...
Yup, Grant and I are doing comed^H^H^H^H^H execution plans as a precon on 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 20, 2011 at 8:21 am
Jeff Moden (7/20/2011)
GilaMonster (7/20/2011)
Jeff Moden (7/20/2011)
I understand that Gail Shaw will be co-presenting with you...Yup, Grant and I are doing comed^H^H^H^H^H execution plans as a precon on the Monday.
If...
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 20, 2011 at 8:12 am
halifaxdal (7/20/2011)
So, I tried to upgrade the database first, I downloaded the upgrade advisor from Microsoft but again another error pops up:
That's not how you upgrade a DB. Upgrade advisor...
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 20, 2011 at 8:08 am
Viewing 15 posts - 24,796 through 24,810 (of 49,552 total)