November 8, 2007 at 3:07 am
Hello,
I need move my SQL Server 2005 installation (Database Engine, Analysis Services) from one disk to another.
C:\Program Files\Microsoft SQL Server\MSSQL.1\
C:\Program Files\Microsoft SQL Server\MSSQL.2\
to
D:\SQL2005\MSSQL.1\
D:\SQL2005\MSSQL.2\
May you help me how do this?
--
Regards
November 8, 2007 at 6:13 am
as far as I know you can't move an install - too many registry keys - I'd advise you to uninstall and re-install ( after detaching your databases of course )
You can move the databases including system to anothe rlocation and the error logs but not the whole install.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
November 9, 2007 at 3:04 am
If the objective of doing the move is to get your data on to another disk, this can be done without moving the SQL Server program libraries. Perhaps the easuiest way to move databases is DETACH, move the physical files, then ATTACH - see BOL for syntax.
If your objective in the move is to get your program libraries away from C:\, then I agree with Colin. Although in theory you should be able to move the program files and hack the registry, if you get something wrong that causes a problem at a later date you may have put yourself outside of Microsoft support. It is far lower risk to uninstall and reinstall.
1) Detach your user databases
2) Stop SQL
3) Copy the system databases to a temporary location
4) Uninstall SQL
5) Install SQL on the new drive
6) Apply exactly the same SPs and HFs as your old install
7) Stop SQL
8) Replace the nerw system databases with those saved from your old system (this avoids the need to re-create logins, SSIS, etc, etc)
9) Start SQL
10) ATTACH your user databases
11) Test everything is working as required!!!
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
November 9, 2007 at 6:19 am
make sure you include the msqlsystemresource files too otherwise you might have some problems.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply