15 lines
308 B
Transact-SQL
15 lines
308 B
Transact-SQL
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
|
|
|
|
|