October 13, 2009 at 10:03 pm
Hi,
I have given data files location S:\mssql.1\mssql\sysdb in installaiton.
After installaiton i have cheked my system dbs are in S:\mssql.1\mssql\sysdb\........\data location.
I need to move my sysstem db to S:\mssql.1\mssql\sysdb.
can i move master, model ,msdb and temp db to S:\mssql.1\mssql\sysdb.
can i need to move resouce db also?.i have read Microsoft artical
in that resource db should be in master location.
i tried to move resouce db i got error.
Could you please let me know the solutionin sql 2005 ans sql 2008
October 16, 2009 at 8:21 am
mohinidba (10/13/2009)
Hi,I have given data files location S:\mssql.1\mssql\sysdb in installaiton.
After installaiton i have cheked my system dbs are in S:\mssql.1\mssql\sysdb\........\data location.
I need to move my sysstem db to S:\mssql.1\mssql\sysdb.
can i move master, model ,msdb and temp db to S:\mssql.1\mssql\sysdb.
can i need to move resouce db also?.i have read Microsoft artical
in that resource db should be in master location.
i tried to move resouce db i got error.
Could you please let me know the solutionin sql 2005 ans sql 2008
Yes, resource and master must be on same location and of course, you need to follow some steps for that.
This article describe the process very well: http://msdn.microsoft.com/en-us/library/ms345408%28SQL.90%29.aspx
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply