Some content on this site is available only to logged-in subscribers. Contact Us for information on becoming a subscriber.

InSource.Solutions | InSource Training | InSource Client Portal
InSource Solutions Logo
Log In Sign Up
InSource.Solutions InSource Training InSource Client Portal Log In Sign Up
  • Home
  • Supporting Technologies (i.e. Windows / SQL Server / VMWare / etc.)
  • Supporting Technologies Tech Notes

Changing the Default Location for New SQL Databases

Last updated: March 5th, 2025

Description

  • Author: Brian Schneider
  • Published: March 5th, 2025

Details:

Problem Statement

Software like Wonderware’s Application Server or InTouch Alarm DB Manager will not ask where to create their databases, they will use SQL’s default location. SQL Server by default will store new databases to the drive where SQL Server has been installed. This can be a problem if the installation drive has limited space, or if policies require new databases to be stored elsewhere. Note: This only changes the location for new databases, and will not affect databases which already exist.

Solution Details

Tested with SQL Server 2005 and SQL Server 2008

This solution involves modifying settings within SQL Server Management Studio. As such, you may require administrator assistance.

Solution Steps:

  • On the SQL Server computer, open the SQL Server Management Studio by going to Start > Programs > Microsoft SQL Server and selecting the Management Studio option.
  • If prompted for a username and password, enter an administrative user’s credentials.
  • Once logged in, under the Object Explorer tree you should see your server listed. Right click on it and select Properties.

  • Under Server Properties, go to the Database Settings page. On this page, you can now change the default locations for your databases and log files.

  • Once the user presses OK to save the changes, any new databases created will go to this new location.
sql locating database setting
Give feedback about this article

Recommended articles

TN - 1240 Creating a Watchlist Using an Import File

Read More

TN 1242 Aveva Historian Storage Locations and Best Practices

Read More

TN 1393 Deleting Tags from AVEVA Insight

Read More
Support Icon

CONTACT SUPPORT

How to reach us

10800 Midlothian Turnpike Tpke, Suite 209, Richmond, VA 23235

1.877.INSOURCE

Technical Support - 1.888.691.3858

Contact Us

  • InSource Solutions
  • InSource Training
  • InSource Client Portal
  • Log In
InSource Solutions Logo

© 2025 InSource Solutions. All Rights Reserved.

Knowledge Base Software powered by Helpjuice

Expand