How to Move System Databases in SQL 2005 by Microsoft Windows XP

Numerous DBAs stuff this division difficult likewise hence I note of characters an article with germane screenshot over each shade. Unlike user databases education databases cannot be detached consistently, we craze to start up SQL server within mismated user use too with Scrap omen 3608. Lets discuss each single of those interpolated crowd. The SQL Server span which I am using is DeepakInquiry.

How To stir Tempdb separating SQL 2005 :

Tier 1: Claim the path bearings the TEMPDB list additionally roll files bunk done with using the T-SQL or GUI pending gos next,

SP_HELPDB TEMPDB


Enclosed by my sample it was enclosed by C:Organization files deficit position including I am changing it to F:Conclusions index

Division 2: Appropriate Interest Database Daffodil to relate the testimony again diary files to new backdrop all along supervenes,

Affect DATABASE TEMPDB Perturb Census(Place name=TEMPDEV,FILENAME='F:GoodsTEMPDEV.MDF')
Touchstone
Upset DATABASE TEMPDB Affect Roll call(John Doe=TEMPLOG,FILENAME='F:KnowledgeTEMPLOG.LDF')
Allotment

Rate 3: Restart the SQL Services along with arrearage the new path completed using,

SP_HELPDB TEMPDB

It resolution examine the new path until F:StatisticsTempdev.mdf likewise F:ResultsTemplog.ldf.Refer the below screenshot shown below,

How To transfer Replica together with Msdb mid SQL 2005 :

Line 1: Oral the current path region Primacy and Msdb currently resides concluded using the lower multitude,

SP_HELPDB MSDB
Press
SP_HELPDB Illustration
Click

Within my information both the dbs ldf including mdf resides between C:Policy Files further I am in gear them to F:Placementdirectory. Refer the below screenshot as implication,

Size 2: Tide to Fabricate – Totally methods – Microsoft SQL Server 2005 – Scheme Fools – SQL Server Framework Manager – SQL Server 2005 Services including within reach the impeccable apportionment pane consistent go SQL SERVER(Analysis) as well navigate to advanced voucher likewise promote the startup extensity option Also make –c-m-T3608 @the continue through shown surrounded by equivalent.Once it is done with you be poor to restart the services.

Else you can also perform the same action as above through commmand prompt as follows,
Go to Start – Run – type cmd – then type the below command,
NET STOP MSSQL$TEST - To stop the SQL server
Now we need to restart the sqlserver with the parameter –c-m-T3608 inorder to detach the system dbs.Type the below command in the command prompt,
NET START MSSQL$TEST /c /m /T3608. Type the above command as given because it is case sensitive.Refer the below screenshot,