Changing location of data files of a database 1

[dinzana]

I need to change the location of the data files for a database. We are running out of disk space on the c: drive of the SQL Server. My questions are:

1. How is this done?
2. Are there any caveats to this as I have several SSIS packages that are pointing to this particular database?

Thanks in advance.

dinzana

 

[jbenson001]

1. You can detach the database, then copy the .mdf and .ldf files to the new location. Then Attach the database pointing to the files in the new location.

2. It shold not affect your SSIS packages.

Jim

 

[dinzana]

Jim,

Thanks so much for your input. It's good to know that there are folks out there to help with their ideas and knowledge.

Cheers,

dinzana

 

[jbenson001]

No problem.. glad to help..

Also, make sure there is no one connected before detaching the DB.

good luck...

Jim