Database and Log file location
How do I change the default location for database and log files during a SQL 2005 installation?
Software/Hardware used:
Software/Hardware used:
ASKED:
May 26, 2009 7:06 PM
UPDATED:
May 30, 2009 3:20 AM
RELATED QUESTIONS
- Transaction Log - SQL Server 2005
- Replication problem
- Auto backup configuration in SQL2005
- Switching from Bulk-Logged to Simple Recovery Model on SQL Server 2000
- I have Exchange 2007 running on a Windows Server 2003 R2 server for a small business with about 30 email accounts running out of storage space
Answer Wiki:
Here is a <a href="http://www.phwinfo.com/forum/ms-sqlserver-setup/201362-sql-2005-database-default-location-during-setup.html">good discussion </a>which may help you.
When you get to the list of services to install, click the Advanced button. Expand the SQL Server engine menu item, and select database files. Change the folder here. This will set the data file and log files to the same thing. You'll need to change the folder to different folders after the install is finished.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
