April 15, 2016 at 9:02 am
jasona.work (4/15/2016)
Brandie Tarvin (4/15/2016)
Jack Corbett (4/15/2016)
Grumpy DBA (4/15/2016)
(why are mdf and ldf files on the same drive?)mdf and ldf on the same drive happens all the time. Of course when your SAN is configured as one big lun having the mdf's and ldf's on different logical drives doesn't make that much difference (my current location). Fortunately I'm a dev, not a DBA at my current job.
This is true of our 2k8 servers, which were on corporate controlled PODS. With our 2k12 upgrade, we're going back to servers "owned" and managed by our local division which have the drives separated out. But given how many of our servers are virtual, who's to know if these really are separate drives (physical) or just imaginary drives that are on the same drive (logical).
If I eat enough mushrooms, may I can hallucinate corporate infrastructure granting us a different drive for each database. That would be nice. :w00t:
(munching on a slice spinach and mushroom omelet casserole this morning).
Even though all my servers are VMs, when I request them I still go for separate drives (I've gone one step further than in the past, too, with my new 2012 servers: OS drive, App drive, Filestream drive (if needed,) MDF drive, LDF drive, and Audit file drive) mostly for logical separation. Plus, if one drive starts filling up, I don't have to worry as much about the VMware / Storage admins whining about having to cram a humongous (by *their* definition) virtual HD into a LUN...
We didn't exactly have a choice in the matter.
April 15, 2016 at 9:32 am
GilaMonster (4/15/2016)
Brandie Tarvin (4/15/2016)
BLOB_EATER (4/15/2016)
GilaMonster (4/15/2016)
*sigh* http://www.sqlservercentral.com/Forums/Topic1778081-433-1.aspxI don't have backup.
I read "by creating empty DB and taking it offline and deleting and replacing dummy .mdf and .ldf files with my DB".... and just started to shake my head.
I'm trying to figure out where he got that bit of advice so I can avoid that site.
Paul Randal's blog, pluralsight courses, articles and PASS presentations.
It's the last ditch solution for attaching a damaged DB or one where the log file was lost.
Yes last ditch effort. Really should only be done by a professional though. Something tells me this person is not a professional (maybe the struggling with it for 3 days or lack of backups).
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 15, 2016 at 11:06 am
Brandie Tarvin (4/15/2016)
Ed Wagner (4/15/2016)
Brandie Tarvin (4/15/2016)
GilaMonster (4/15/2016)
*sigh* http://www.sqlservercentral.com/Forums/Topic1778081-433-1.aspxI don't have backup.
How does one get incorrect page IDs in the headers?
Seriously. I'm trying to figure out how that one is possible.
I think you're looking for DBCC WRITEPAGE. Please first connect to dev and be careful.
I choose instead to look it up in BOL before doing anything of the sort. So NAH.
But thank you for pointing this out. I'll go grab documentation and see what is out there.
Actually, I don't think you're going to find the official documentation. It's one of those undocumented things.
Paul's blog explains what it does and comes with its own warnings: http://www.sqlskills.com/blogs/paul/dbcc-writepage/
April 15, 2016 at 11:11 am
GilaMonster (4/15/2016)
Ed Wagner (4/15/2016)
For errors in the PFS, GAM, SGAM or IAM pages, are there any viable options for recovery without going to a backup?Depends on how widespread. If just a single GAM/SGAM/PFS, it's probably possible to still select from the tables in that interval and script that data out.
With this one, where multiple GAM/SGAM pages in a row are marked as unreadable, it's a good bet that the 2GB between them is also damaged, and in that case probably not.
Thanks. I'm just getting my feet wet with database corruption. I have a very long way to go.
April 15, 2016 at 11:36 am
SMH
April 15, 2016 at 11:49 am
Eirikur Eiriksson (4/15/2016)
Phil Parkin (4/15/2016)
Anyone have a crystal ball, several hours to kill and feeling masochistic? Dive in!Quick fix in three steps
1. Drop procedure
2. Drop developer
3. Create developer
😎
Do 2 and 3 in one step as an IF EXISTS. In this case the IF clause will fail and it will be able to create the developer.
April 15, 2016 at 11:56 am
jeff.mason (4/15/2016)
Eirikur Eiriksson (4/15/2016)
Phil Parkin (4/15/2016)
Anyone have a crystal ball, several hours to kill and feeling masochistic? Dive in!Quick fix in three steps
1. Drop procedure
2. Drop developer
3. Create developer
😎
Do 2 and 3 in one step as an IF EXISTS. In this case the IF clause will fail and it will be able to create the developer.
You are absolutely right, thank you for the correction 😀
😎
April 15, 2016 at 12:03 pm
About to head off to SQL Saturday Phoenix. Anyone else going?
April 15, 2016 at 12:07 pm
Steve Jones - SSC Editor (4/15/2016)
About to head off to SQL Saturday Phoenix. Anyone else going?
Wish I could, but don't have the PTO time since I need to take May 6th off so I can drive to Prescott, AZ for my daughters graduation from ERAU on May 7th.
April 15, 2016 at 12:07 pm
Eirikur Eiriksson (4/15/2016)
jeff.mason (4/15/2016)
Eirikur Eiriksson (4/15/2016)
Phil Parkin (4/15/2016)
Anyone have a crystal ball, several hours to kill and feeling masochistic? Dive in!Quick fix in three steps
1. Drop procedure
2. Drop developer
3. Create developer
😎
Do 2 and 3 in one step as an IF EXISTS. In this case the IF clause will fail and it will be able to create the developer.
You are absolutely right, thank you for the correction 😀
😎
I can see a much better execution plan being generated already.
Viewing 15 posts - 53,566 through 53,580 (of 66,749 total)
You must be logged in to reply to this topic. Login to reply