|
|
Posted by Dan Guzman on 11/23/98 11:59
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.googlegroups.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
>
Navigation:
[Reply to this message]
|