Friday, October 19, 2012

Move Databases

NET START MSSQLSERVER /f /T3608
or
NET START MSSQL$instancename /f /T3608


use sqlcmd commands or SQL Server Management Studio to run the following statement.

ALTER DATABASE database_name MODIFY FILE( NAME = logical_name , FILENAME = 'new_path\os_file_name' )

use database_name

select file_name(1)


NET STOP MSSQLSERVER


NET START MSSQLSERVER.