People are capable of all kinds of good thinking, but some just don't see what's right in front of their noses.


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 …Continue reading