Move multiple databases from C: to D: at once

18 votes

5 answers

13015 views

sql-server sql-server-2008-r2 alter-database

                          I have SQL Server 2008 R2 with 323 databases consuming some 14 GB on my C: drive, a fast SSD.

Because I want to reclaim some space on my C: drive, I would like to move them to my D: drive.

I have found this MSDN article , but that seems to be the procedure to move only one database. 

Is there an automatic way or script to move all my databases at once?

Asked by BioGeek (281 rep)

Jul 17, 2013, 06:50 PM
Last activity: Dec 14, 2017, 03:04 PM

Move multiple databases from C: to D: at once

Related Questions