Changing the default SQL 2005 data directory
Default installation of SQL 2005 has the data directory set at C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data. However, if you are looking to setup another RAID volume that separate the database(s) data directory from the default, you may do this by firing up the SQL Server
Management Studio > Right-click the server in the object explorer and select Properties > Database Settings. Change the Data and Log directory to the disk drive that you wish to or any other folders.
If you enjoyed this article please consider sharing it!
Post comment
Categories
Recent Posts
- yum update – TypeError: unsubscriptable object
- Magento with Windows IIS
- Helm3 : File Manager Not Showing any Files
- Helm4 Error on Remove Domain
- SQL 2008 Maintenance Plan Execution Error
Recent Comments
- Superrookie on Cannot create Windows Service for MySQL.Error:0
- Martin on Cannot create Windows Service for MySQL.Error:0
- About MySQL.Error On Windows 7 | Robin Blog - UED, Open source, SEO, Marketing on Cannot create Windows Service for MySQL.Error:0
- Totally Frustrated MySQL Newbie on Cannot create Windows Service for MySQL.Error:0
- Simon on Cannot create Windows Service for MySQL.Error:0
Archives
- September 2009
- May 2009
- April 2009
- March 2009
- November 2008
- August 2008
- July 2008
- May 2008
- April 2008
- March 2008
- January 2008
- December 2007
- November 2007
- October 2007
- September 2007
- August 2007
- July 2007
- June 2007
- March 2007
