SQL 2014 installation

Need to change  folder names of system database,  to keep consistent across all the server.  I need to make this change.   This is new server not yet used by any application.   After installation, i was told to  change folders for system database.  only master, msdb and model.  Temp db is separate driver, so need to change tempdb. 

any suggestion 

Thanks

V

April 30th, 2015 10:13pm

so, do you need change tempdb database to a different folder or rename the existing folder??

if it just renaming, which it sounds like ... just alter the database settings and stop the sql server--rename the folder and start the sql server. something like this 

USE [MASTER]
GO
Alter database TempDB
MODIFY File (Name= 'TempDev', FileName = 'E:\TempDBData\TempDev.mdf',SIZE = 4096MB , FILEGROW =500MB)
GO
Alter database TempDB
MODIFY File (Name= 'TempLog', FileName = 'E:\TempDBLog\TempLog.ldf',SIZE = 1024MB , FILEGROW =250MB)

it should be same for model and msdb. but if master after stopping and renaming the folders.. in the configuration manager -- properties-- in the file path - you need to specify the new path or changed path.

Free Windows Admin Tool Kit Click here and download it now
April 30th, 2015 10:26pm

Simple follow:

Move System Databases      

https://msdn.microsoft.com/en-us/library/ms345408.aspx?f=255&MSPPError=-2147217396

Video for the same:

https://www.youtube.com/watch?v=QAlgpxjJCiM


May 1st, 2015 12:02am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics