Issues with Un-Installng and Re-Installing SQL Server 2005

Are there any issues with un-installing and re-installing sql server 2005
dev edition? I think it installed SSRS. I know that un-installing and
re-installing sql server 2000 is pretty painless as I've done it many times
with no problems, however, un-installing and re-installing SSRS 2000 is a
MAJOR pain as it leaves many splinters behind that are difficult to deal
with prioer to re-installing SSRS.
My main concern is that I thought I specified the Data files to reside on
the D drive, however, sql server 2005 installed the data files in:
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data
Would it be be painless and trouble free to move the databases to
D:\MSSQL05\Data, and then from SQL Server Management
Studio/Properties/Database Settings/Database Default locations, set it to:
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data?
Thanks.
moondaddy@.nospam.nospamBasially I don't see any issues, besides for the fact that you need to make
sure you have a copy of the database master key.
See Books online on how to export it.If you want to move you would be able
to do a database attach / detach.
I didn't really test it myself on RTM but on September CTP I had quite some
issues with it
Dandy Weyn
[MCSE-MCSA-MCDBA-MCDST-MCT]
http://www.dandyman.net
Check my SQL Server Resource Pages at http://www.dandyman.net/sql
"moondaddy" <moondaddy@.nospam.nospam> wrote in message
news:Oq9jG006FHA.2384@.TK2MSFTNGP12.phx.gbl...
> Are there any issues with un-installing and re-installing sql server 2005
> dev edition? I think it installed SSRS. I know that un-installing and
> re-installing sql server 2000 is pretty painless as I've done it many
> times with no problems, however, un-installing and re-installing SSRS 2000
> is a MAJOR pain as it leaves many splinters behind that are difficult to
> deal with prioer to re-installing SSRS.
> My main concern is that I thought I specified the Data files to reside on
> the D drive, however, sql server 2005 installed the data files in:
> C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data
> Would it be be painless and trouble free to move the databases to
> D:\MSSQL05\Data, and then from SQL Server Management
> Studio/Properties/Database Settings/Database Default locations, set it to:
> C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data?
> Thanks.
> --
> moondaddy@.nospam.nospam
>sql