February 3, 2004 at 9:26 am
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 ??
February 4, 2004 at 8:13 am
Do I need to reinstall sql server on the other drive and then do a backup of each of the databases and restore it to the new location ?? Or the steps are coompletely different. I was trying to copy the database using the database wizard and it doesn't accept the destination server to be the same server. I have not worked with sql server and I need to complete this task asap, any advice will be highly appreciated.
Thanks in advance.
February 4, 2004 at 2:43 pm
Hope this link will be helpfull for you:
Cheers,
ON
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy