how to change default data directory for SQL 2005

Hi, I've installed SQL 2005 and failed to change the default data
location during installation. Now I want to change it. Can I do this
without having to uninstall and reinstall? And furthermore, is there a
system stored procedure I can use to move existing data and log files
(master, msdb, AdventureWorks, etc.)? I seem to remember doing just
this with SQL 2000 some time back.

Thanks,
EricYou can specify the default database file locations using SQL Server
Management Studio. Right-click the server in the object explorer and select
Properties-->Database Settings.

The SQL 2005 Books Online includes detailed steps on moving database files.
There is a different procedure for system vs. user databases.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"Eric Bragas" <ericbragas@.yahoo.comwrote in message
news:1159469015.718736.156300@.d34g2000cwd.googlegr oups.com...

Quote:

Originally Posted by

Hi, I've installed SQL 2005 and failed to change the default data
location during installation. Now I want to change it. Can I do this
without having to uninstall and reinstall? And furthermore, is there a
system stored procedure I can use to move existing data and log files
(master, msdb, AdventureWorks, etc.)? I seem to remember doing just
this with SQL 2000 some time back.
>
Thanks,
Eric
>

|||Thanks, Dan. This answers my question completely.

-Eric