tnt1232007 revised this gist 4 months ago. Go to revision
1 file changed, 5 insertions
mssql.sql(file created)
| @@ -0,0 +1,5 @@ | |||
| 1 | + | USE master; | |
| 2 | + | SELECT file_id, name as [logical_file_name], physical_name from sys.database_files | |
| 3 | + | ALTER DATABASE DBNAME MODIFY FILE (name='logical_name', filename='D:\Database\physical_name.mdf'); | |
| 4 | + | ALTER DATABASE DBNAME SET OFFLINE WITH ROLLBACK IMMEDIATE; | |
| 5 | + | ALTER DATABASE DBNAME SET ONLINE; | |
Newer
Older