This is where there are 2 choices to complete the task. To change the physical file name or extension.

The master database data and/or log file will be somewhere else.ĭuring this step it will allow the file name to be changed, but it is not advised Inform SQL Server that during the next startup of the service The process to move the master database is as follows.

Move the master database files, but they both follow the same basic steps. Yes! The master database files can be moved. With the SQL Server binaries and have to be moved to the target location post installation.Ĭan the SQL Server master database be moved? Where to store the system database files. Starting with SQL Server 2012, the installer offers a choice about On this author’s laptop that contains only a C: drive. In this post are showing the C: drive only because they are from a local instance This generally means NOT on the C: drive. The master database files should be stored with the other database files of the Therefore, to find a list of user-created tables (thus ignoring system tables), we’ll need to find results where the xtype column (which specifies the object type for that row) is equal to the value U, which stands for user table.Does it make a difference where the SQL Server master database files reside (do they need The SYSOBJECTS table houses a couple dozen columns of data since it must hold information about virtually everything added to the server over time. SYS.SYSOBJECTS contains a row for every object that has been created in the database, including stored procedures, views, and user tables (which are an important to distinguish from system tables.)

Listing Tables in SQL Server 2000įor older versions of SQL Server (such as SQL Server 2000, though this method is also supported in SQL Server 2005 for backward compatibility), you’ll need to query the SYS.SYSOBJECTS metadata view. Below we’ll briefly examine the TSQL statements that can be used to retrieve a table list for both the older SQL Server 2000 and the newer 2005 version or beyond.

Depending on the version of SQL Server you are running, the method for querying and returning a list of all user-created tables may differ slightly.

Master database in sql server