SQLSERVERMOVINGSYSTEMDATABASES(二)
he value for the error log must follow the –e parameter, as shown here:
?
-dE:\Data\master.mdf
?
-lE:\Data\mastlog.ldf
?
-eE:\Data\LOG\ERRORLOG
?
3. Stop the instance of SQL Server and physically move the fies for to the new location.
?
4. Restart the instance of SQL Server.
?
5. Verify the fie change for the master database by running the following query:
?
SELECT name, physical_name AS CurrentLocation, state_desc FROM sys.master_files
?
WHERE database_id = DB_ID('master');
?
144 Microsoft SQL Server 2012 Internals
?
Finally, if you are also changing your drive letters or folders, you need to verify and perhaps change the location of the SQL Server Agent error log fie and the confiured database default locations setting. The Database default locations setting is defied on Server Properties | Database Settings.