Will moving the mdf files effect SSRS and SSIS?

Question

question

cacapo asked Sep 16, '13

Will moving the mdf files effect SSRS and SSIS?

Our drive where all of our database files are stored is full and cannot be expanded so we are planning to move all of the database files to a new drive. We already know how to re-point the database to the correct file in Management Studio but are unsure on how SSRS and SSIS will react to this change. Will we need to redeploy all of the reports and packages or will they continue to work once the databases are working correctly? Any articles and/or proof found on this are welcome. I tried finding this on Google but just kept finding the same stuff on how to move the mdf file.

ssis sql-server-2008-r2 ssrs-2008-r2

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Fatherjack ♦♦ commented · Sep 17, 2013 at 11:59 AM

Dont forget to mark the answer as correct by clicking the tick mark so that others know the question is resolved and the answerer gets the credit. Thanks

0 ·

Answer 1 · 2013-09-16T19:50:28Z

KenJ answered Sep 16, '13

Database pathing is completely transparent to client applications. If the databases remain on the same instance, this will have no impact on SSRS or SSIS unless the SSIS package is creating, detaching, attaching or restoring a database or file/filegroup to a particular path.

3

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

cacapo commented · Sep 16, 2013 at 07:55 PM

Okay so as long as we keep them on the same server all of the different applications referencing the databases should be fine?

0 ·

KenJ commented · Sep 16, 2013 at 07:58 PM

Yes. I've moved hundreds of databases, including reporting server databases, with no effect on the applications.

0 ·

cacapo commented · Sep 16, 2013 at 08:06 PM

Alright that's good to hear. Thanks.

0 ·

question