December 23, 2004 at 1:24 pm
I'm going to loading a new server with SQL Server 2000. What do I need to do to have the System databases (master, model,msdb.etc) load into a specific location. Do I have to move them after the fact? I want them to reside on a different drive from the SQL Server files. Any articles that speak to this topic will help. Thanks
December 23, 2004 at 1:43 pm
During the installation it will ask you where to put the data. That's where you specify the db location.
December 23, 2004 at 1:55 pm
Be aware that SQL will create the MSSQL folder and the subfolders beneath that where ever you tell it. So, if you select d:\SQL_Data\ as the location, your master data file will be in d:\SQL_Data\MSSQL\Data\.
Steve
December 24, 2004 at 3:44 am
If you want to move the system databases after you have completed the install, see http://support.microsoft.com/default.aspx?scid=kb;en-us;224071
I strongly recommend you complete all operations on a given database before you start work on the next database. SQL Server expects master, tempdb, model to have specific database id numbers and gets very upset if the database with the id number is not as expected.
You must stop SQL Agent before you move msdb.
You must not detach tempdb. Instead you must use ALTER DATABASE as shown in the KB article.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply