Can someone tell me how to migrate the sql server instance to a different drive on the same server. There are several user databases including the system databases. I want to move the entire instance from one drive to a new drive and free up the drive space where the current instance is located. Please give me a quick and best option to do this. Also let me know what are the ramnifications.
This databases are used by the business object for repository. DO I need to change any configuration on the business object server after I move the database to the new location ??