USE master GO BACKUP DATABASE $(DBNAME) TO DISK='C:\DataPRO_SQL\$(DBNAME)Backup.bak' GO ALTER DATABASE $(DBNAME) SET SINGLE_USER WITH ROLLBACK IMMEDIATE GO sp_Detach_db '$(DBNAME)', FALSE, TRUE GO ALTER DATABASE ISO SET SINGLE_USER WITH ROLLBACK IMMEDIATE GO sp_Detach_db ISO, FALSE, TRUE GO