Link to home
Start Free TrialLog in
Avatar of asmyatt
asmyatt

asked on

SQL 2005 Moving Master/Model/MSDB DB and Log files

Hi Experts,

How do I move db and log files for the master, model, and mdsb databases to a seperate disk drive in SQL 2005?  I hear the process is different than moving the tempdb.  

Also, are these three db moves necessary for improving performance?

Thanks!
ASKER CERTIFIED SOLUTION
Avatar of Barry Cunney
Barry Cunney
Flag of Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of asmyatt
asmyatt

ASKER

The database server is VM.  Can I check the raid disk to see if 1 or 5 via remote desktop? Or is that information only available from my VM Administrator?
SOLUTION
Avatar of Tony303
Tony303
Flag of New Zealand image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial