Change the databases and system DBs folders | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Change the databases and system DBs folders

I am changing my SQL-Server box in production. Meanwhile, I want to change the databases and system DBs folders. What are the impacts? Any good source for this plan? CanadaDBA
You want to do that in old server or in new one?
Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided “AS IS” with no warranties for accuracy.
http://support.microsoft.com/default.aspx?scid=kb;en-us;224071 There are no impacts if you do it right. MeanOldDBA
[email protected] When life gives you a lemon, fire the DBA.
… and it is a good plan on the basis of performance… to seperate system DBs and user databases. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
In New one.
quote:Originally posted by LuisMartin You want to do that in old server or in new one?
Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided “AS IS” with no warranties for accuracy.

CanadaDBA
seperate into different harddisks or different folders?
quote:Originally posted by satya … and it is a good plan on the basis of performance… to seperate system DBs and user databases. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

CanadaDBA
If you can store Tempdb and Transaction log in one physical disk and Database in other physical disk, much better.
Regards differents forlders in same disk, don’t give you more performance.
Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided “AS IS” with no warranties for accuracy.
The doccument says:
1. Move all user DBs;
2. Move Northwind and Pubs;
3. Move msdb;
4. Move master;
5. move model;
6. move tempdb. Is it the order I need to follow? Shouldn’t Model be before Master?
quote:Originally posted by derrickleggett http://support.microsoft.com/default.aspx?scid=kb;en-us;224071 There are no impacts if you do it right. MeanOldDBA
[email protected] When life gives you a lemon, fire the DBA.

CanadaDBA
I followed the documents steps and it worked for me. Actually the steps were like: 1. Detach all user DBs;
2. Detach Northwind and Pubs;
3. Detach msdb;
4. Move master;
5. Move model;
6. Attach msdb;
7. Move tempdb;
8. Attach Northwind, Pubs;
9. Attach all user DBs. Thanks!
quote:Originally posted by FarhadR The doccument says:
1. Move all user DBs;
2. Move Northwind and Pubs;
3. Move msdb;
4. Move master;
5. move model;
6. move tempdb. Is it the order I need to follow? Shouldn’t Model be before Master?
quote:Originally posted by derrickleggett http://support.microsoft.com/default.aspx?scid=kb;en-us;224071 There are no impacts if you do it right. MeanOldDBA
[email protected] When life gives you a lemon, fire the DBA.

CanadaDBA

CanadaDBA
"I am changing my SQL-Server box in production" This is a new scenario for me, y need this .anyone pleaselet me know . Rajiv
SQL-DBA
Follow the KBA referred by Derrick to accomplish the task.
And ensure to maintain all the databases backup before proceeding to process the work. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>