Re: Move DB File Locations - SQL 05

I agree with Andrew, there's no particular performance gain in moving system
databases other than tempdb. However, should you decide to move the master
database, please be aware that the Resource database must also be moved to
the same location as the master .mdf file.

The procedure for moving system databases in SQL Server 2005 is documented
in Books Online in the December 2005 version. See Moving System
Databases.(http://msdn2.microsoft.com/en-us/library/ms345408(en-US,SQL.90).aspx)
--
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights

"Andrew J. Kelly" <sqlmvpnooospam@xxxxxxxxxxxx> wrote in message
news:eJTYw9MKGHA.2628@xxxxxxxxxxxxxxxxxxxxxxx
There is no impelling reason to move Master, Model or MSDB but you may
want to move tempdb data file to the raid 10 and the log file to the Raid
1 along with the user db files. These should help:


http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs
http://www.databasejournal.com/features/mssql/article.php/3379901
Moving system DB's
http://www.support.microsoft.com/?id=314546 Moving DB's between
Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server
Databases to a New Location with Detach/Attach
http://www.support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.sqlservercentral.com/columnists/cBunch/movingyouruserswiththeirdatabases.asp
Moving Users
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs
after a Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or
Permission Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
http://www.support.microsoft.com/?id=320125 Moving a Diagram
http://www.support.microsoft.com/?id=274463 Copy DB Wizard issues 2000


--
Andrew J. Kelly SQL MVP


"Dan" <Dan@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F6CA7F35-FB64-435F-9B21-76ADB7E9E5E0@xxxxxxxxxxxxxxxx
I just installed SQL Svr 2005 STD and the default install put all my data
and
log files into a default location (c:\Program Files\...), but I want to
move
my log files to a RAID 1 D: drive, and my Data Files to a RAID 10 E:
drive.

What is the best way to get this done?

Should I change to location of these files for all the system databases
(master, model, tempdb, msdb)?




.

Relevant Pages

  • Re: Backing up my SQL 2000 trial edition
    ... http://www.databasejournal.com/features/mssql/article.php/3379901 Moving ... http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases ... Restore ... for SQL Server ...
    (microsoft.public.sqlserver.setup)
  • Re: Created default db onto wrong drive... need to move/create on
    ... like sp's and DTS packages are stored in the databases themselves and will ... >> http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs ... >> for SQL Server ...
    (microsoft.public.sqlserver.setup)
  • Re: moving data in a database to another file on a SAN
    ... Will that work if SQL Server is not moving, ... If I move the data from the D drive to the E drive (on the SAN), will I be able to delete the file on the D drive in database/properties/data files? ... > Moving SQL Server Databases ...
    (microsoft.public.sqlserver.server)
  • Re: Copy database tables/data from one marchine to another.
    ... http://www.support.microsoft.com/?id=314546 Moving DB's between Servers ... Errors After Restoring Dump ... for SQL Server ... > I have an instance of SQL Server 2000 running on machine A. I want to export three databases on machine A and import them into machine B. There is no internet connectivity between the two machines. ...
    (microsoft.public.sqlserver.dts)
  • Einsteins Ellipsoids
    ... predicts that a moving object is ... w.r.t. the moving system (in which the object is at ... rest) instead of the stationary system. ... He simply writes the algebraic description of a sphere ...
    (sci.physics.relativity)