SEO

#1 (**permalink**) 02-29-2008, 08:31 PM

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

#2 (**permalink**) 02-29-2008, 08:31 PM

You 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.com> wrote in message
news:1159469015.718736.156300@d34g2000cwd.googlegr oups.com...
> 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
>

#3 (**permalink**) 03-01-2008, 11:26 AM

Thanks, Dan. This answers my question completely.

-Eric

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

how to change default data directory for SQL 2005