Kevin
asked on
How to move tempdb and templog to another drive
Good Afternoon,
I am running SQL Server 2008 R2, at the moment I have my "templog.ldf" and "tempdb.mdf" being saved on the C drive.
I want to follow best practice and have these stored on a separate drive.
I have a separate drive ready for them, but don't know how to tell SQL server how to use the other drive instead of the C.
Kindly advise how I am able to do this.
Regards,
N
I am running SQL Server 2008 R2, at the moment I have my "templog.ldf" and "tempdb.mdf" being saved on the C drive.
I want to follow best practice and have these stored on a separate drive.
I have a separate drive ready for them, but don't know how to tell SQL server how to use the other drive instead of the C.
Kindly advise how I am able to do this.
Regards,
N
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Please disregard i see FILENAME is a parameter.
I will apply tonight and advise of any issues.
Regards,
N
I will apply tonight and advise of any issues.
Regards,
N
ASKER
Thanks again.
ASKER
Just to confirm "FILENAME" (is the "tempdb.mdf" and "templog.ldf") or is it just the word "FILENAME"??
Kindly advise.
Regards,
N