Moving Database Installation path in SQL Server 2008
Posted on 2010-03-28
During my last installation I have mistakenly chosen the wrong drive for installation. The after effect being the drive I have chose happen to be one of the SQL partitiion residing in it.Now I have to move the default files that got created during the installation from this drive so I can keep the drive just for paritition data.The folders that were been created were Backup,Data,Log,Jobs,FTData,Repldata.
I am more worried about Data,Log,Jobs,FTData, as the rest of them are empty.Also all the system database have been installed in this drive.
Can someone help with a script or something to move these files and folders to the local drive.
?And remember this is SQL Server 2008 on Windows 2008 cluster.
Thanks in ADVANCE.