sqlserverdba
asked on
forgot to change system databases path
I forgot to change the path for system databases at the time of install. Is it possible to change the location of data files and log files of system datbases (master,model, msdb,tempdb). Currently they are in default location - program files.
ASKER
I dont want to move the system databases. can i just change the path of the data files and log files of the system databases like into d drive or e drive?
From the link you gave, is it enough to use this
ALTER DATABASE model MODIFY FILE ( NAME = model , FILENAME = 'd:\data\model.mdf' )
can you please explain?
From the link you gave, is it enough to use this
ALTER DATABASE model MODIFY FILE ( NAME = model , FILENAME = 'd:\data\model.mdf' )
can you please explain?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
im working on it. can you please tell me which system databases (data, log files) do i need to move. Is it enough to move just master (mdf,ldf) and tempdb(mdf,ldf) from c drive to e drive?
or should i move all of them for all the system databases
or should i move all of them for all the system databases
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
here is a link explaining the process in detatil
http://msdn.microsoft.com/en-us/library/ms345408.aspx