February 2, 2016 at 5:44 pm
Hi,
We currently have a 2 node active/passive cluster setup in production. Now we want to move to mount points.
I'm thinking belo steps will work. Does below steps makes sense? Please advise.
1. After creating mount points, do we need to reinstall the SQL Server? or
2. Stop sql service and move mdf and ldf files of all user databases to new mount points and keep the installation on existing drive
3. Start the sql service.
February 3, 2016 at 8:15 am
gary1 (2/2/2016)
Hi,We currently have a 2 node active/passive cluster setup in production. Now we want to move to mount points.
Just the user databases you are moving?
gary1 (2/2/2016)
I'm thinking belo steps will work. Does below steps makes sense? Please advise.1. After creating mount points, do we need to reinstall the SQL Server? or
If you're moving all other folders belonging to the instance, an uninstall and reinstall will be the best route
gary1 (2/2/2016)
2. Stop sql service and move mdf and ldf files of all user databases to new mount points and keep the installation on existing drive
You don't need to stop sql server to move user database files, you do realise you need to run the
ALTER DATABASE ... MODIFY FILE command for each database file you wish to move!
gary1 (2/2/2016)
3. Start the sql service.
Don't need to stop and start the services.
You need to clarify first exactly what it is you're intending to move to the mounted volumes
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 3, 2016 at 10:18 am
Thanks Perry,
I don't want to uninstall and install SQL Server. I want to move only user databases to new mount points.
Currently, installation and System databases are default location E:\Microsoft SQL Server\MSSQL10_50.SP\MSSQL\DATA
Please advise.
February 4, 2016 at 5:14 am
gary1 (2/3/2016)
Currently, installation and System databases are default location E:\Microsoft SQL Server\MSSQL10_50.SP\MSSQL\DATA
and these are not moving, correct?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 4, 2016 at 5:16 am
gary1 (2/3/2016)
I want to move only user databases to new mount points.
Providing the answer to my last post is Yes, read this article[/url] for info on moving database files in sql server
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply