August 17, 2015 at 2:47 pm
Found out our cluster built before I got here all the drives not done with 1024 KB starting offset, and a 64 KB block size. So drive by drive every weekend will be moving the drives, detach sql database move file, reattach, only a small windows, so having to do each drive of (7) every week. Little worried about system and tempdb databases. This one is a little trickier to do. Anyone gone though this painful process before?
August 19, 2015 at 2:20 pm
tempdb is probably the easiest, simply note the folder path to the database.
Shut down the instance and blow away the volume, recreate it as required.
Set your folder paths up and any NTFS ACLs for the sql server service and then restart the instance, if you got it right tempdb will be recreated
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply