Is it possible through only T-SQL to physically move the data and log files of a database from one drive to another drive (on the same server)?

2 votes

2 answers

449 views

sql-server t-sql sql-server-2016 alter-database

                          I know you can alter the database to update their data and log file paths in the database properties, but is there also a way to script out the actual physical move of the files themselves?...maybe through a database command?
                        

Asked by J.D. (40903 rep)

Dec 16, 2019, 06:56 PM
Last activity: Dec 17, 2019, 10:34 AM

Is it possible through only T-SQL to physically move the data and log files of a database from one drive to another drive (on the same server)?

Related Questions