Each of my customers has his own database. Sometimes a customer quits. When that happens, I want to archive that database. My idea is:
1) Make a full backup to "\\backupserver\final_backups\FINAL_BACKUP_CUSTOMERNAME.BAK"
2) Detach the database "DBCUSTOMER"
3) Delete the files DBCUSTOMER.MDF and DBCUSTOMER_LOG.LDF
Is this the way to go? And if so, how do I do step 3 with T-SQL?