Skip to Content
0
Oct 27, 2010 at 09:47 AM

MSSQL 2005 - Change path where LDF and MDF file are stored

95 Views

Dear all.

I need som advice.

I need to change the path where all file *.MDF and *.LDF are store.

Now my configuration store all these files in E:/programs/MSSQL.1/MSSQL/data/

I need to change the above path in something like D:/MSSQL/data/.

What is the best way to do this safely?

--SAPB1 2007 A SP01 PL10

--MSSQL SERVER 2005

Thank's in advance and sorry for my english!!