Re: Move DB File Locations - SQL 05
- From: "Andrew J. Kelly" <sqlmvpnooospam@xxxxxxxxxxxx>
- Date: Fri, 3 Feb 2006 09:37:56 -0500
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)?
.
- Follow-Ups:
- Re: Move DB File Locations - SQL 05
- From: Gail Erickson [MS]
- Re: Move DB File Locations - SQL 05
- Prev by Date: Re: Unable to start MSSQLSERVER service on SQL 2005
- Next by Date: Re: Moving SQL 7 DB to SQL 2000 on different machine
- Previous by thread: Re: FallBack certificate initialization failed with error code: 1.
- Next by thread: Re: Move DB File Locations - SQL 05
- Index(es):
Relevant Pages
|
