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
>
-Eric
