Move SQL Server 2008 R2 database files to a new folder location - Stack Overflow

Move SQL Server 2008 R2 database files to a new folder location - Stack Overflow

瀏覽:918
日期:2025-05-02
You can use this code to change the path. But you have to manually move the files to the new location. The WITH ROLLBACK IMMEDIATE speeds up the offline procedure by disconnecting any current connections. ALTER DATABASE SET OFFLINE ......看更多