May, 2012
Move DB files to new location
In my opinion, we should perform database migration/movement programmatically in order to achieve an automated task, freeing up human resources from tedious tasks. SQL Server 1) ALTER DATABASE <dbname> SET SINGLE_USER WITH ROLLBACK IMMEDIATE; 2) ALTER DATABASE <dbname> SET OFFLINE; 3) ALTER DATABASE <dbname> MODIFY FILE 4) ( 5) Name = <dbname>_Data, 6) Filename …
0
25
May