How do I move a SQL database from one drive to another?

Question

12 Answers Change the file locations with an ALTER DATABASE command: USE master; --do this all from the master ALTER DATABASE foo MODIFY FILE (name='DB_Data1' ,filename='X:\NewDBFile\DB_Data1.mdf'); --Filename is new location. . Set the database offline. . Move/Copy the files to the new location. . Bring the database online.

How do I move a database from one drive to another drive?

Right-click the instance and select Properties. In the Server Properties dialog box, select Database Settings. Under Database Default Locations, browse to the new location for both the data and log files. Stop and start the SQL Server service to complete the change.

How do I change the location of a SQL Server database?

In the Object Explorer right-click the SQL Server Database Engine Instance and select Properties from the menu.1In Server Properties dialog box navigate to Database Settings page as shown below. Under Database default locations you can specify the new path for the Data and Log.2Click the …

How do I change my database location?

View or change the default locations for database files1In Object Explorer, right-click on your server and click Properties.2In the left panel on that Properties page, click the Database settings tab.3In Database default locations, view the current default locations for new data files and new log files.

How do I copy a SQL Server database?

On either the source or destination SQL Server instance, launch the Copy Database Wizard in SQL Server Management Studio from Object Explorer and expand Databases. Then right-click a database, point to Tasks, and then select Copy Database.

Expert · Answer