I have a Server 2008 R2 server running SQL Server 2008 R2 and I need to change the Directory for the LDF and MDF files. The original install from a prior Sys Admin had everything installed on the C Drive 5 years ago. This is a Virtual Server on VMWare 5.5. I know I can create new partitions but I'm looking for best advice to change the directories without causing intense excruciating pain on myself and my end users! I created separate directories on a SAN for the DATA and one for Log files.
Any advice is appreciated. Seems that a lot of online posts offer different scenarios. Let me know what additional info you need. Thanks