December 14, 2011 at 2:55 pm
Hello,
We have our tlogs on our OS drive and our data on a separate drive. I should say all data except the msdb and master dbs. Not sure why they are on the OS drive. Anyway we only had room for two drives and had read separating the logs and data can be beneficial. We have several heavy insert/update jobs throughout the day so it made sense to separate the I/O.
However now we are in the situation where the OS drive is indicating it is going to fail. We don't have a raid setup so the plan is to shutdown sql server, clone the failing OS drive, restore it to a good drive and reboot with the new drive, restart sql server. It seems we'd be fine as long as sql server isn't running. So the data files on the separate drive would still be in sync with the logs on the replaced OS drive along with the msdb and master dbs. I'm a little worried about sql server rejecting the tlog for some reason once the OS is back up and the db going into suspect mode. Can anyone offer any advice as to whether this should work or that we are overlooking something that would keep us from doing it this way?
Thanks,
Gunner
December 14, 2011 at 3:20 pm
As long as SQL is cleanly shut down and the new drive has the same letter that should work a treat, done it myself a few times as part of OS upgrades.
I would of course still backup all the databases first and make sure I had all the info I would need to do a reinstall!
---------------------------------------------------------------------
December 14, 2011 at 4:09 pm
George, thanks for the reassurance. Now that you mention OS upgrades it reminds me of a situation we did something similar that I had forgotten about. I'm feeling better about this now!
Thanks again,
Gunner
December 14, 2011 at 4:41 pm
george sibbald (12/14/2011)
As long as SQL is cleanly shut down and the new drive has the same letter that should work a treat, done it myself a few times as part of OS upgrades.I would of course still backup all the databases first and make sure I had all the info I would need to do a reinstall!
I second that. Usually a simple process, but just be safe.
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
December 14, 2011 at 8:39 pm
We do have plan B, just really hoping it doesn't come to that 🙂
December 15, 2011 at 11:04 am
FYI - everything went smoothly. Thanks again for the input.
December 15, 2011 at 11:08 am
Excellent - thanks for the feedback.
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
December 16, 2011 at 3:25 am
no probs
---------------------------------------------------------------------
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply