USE master -- Single user ALTER DATABASE MonolinkFigaroBackup SET SINGLE_USER WITH ROLLBACK IMMEDIATE EXEC sp_addumpdevice 'disk', 'mydump', 'C:\data\MONOLINK\FIGARO\DAILY_DB_BACKUP\MonolinkFigaroBackup.BAK' RESTORE DATABASE MonolinkFigaroBackup FROM mydump WITH REPLACE, RECOVERY, MOVE 'MonolinkFigaroBackup' TO 'C:\data\SqlServer\MonolinkFigaroBackup.mdf', MOVE 'MonolinkFigaroBackup_log' TO 'C:\data\SqlServer\MonolinkFigaroBackup_1.ldf' EXEC sp_dropdevice 'mydump' -- Multi user ALTER DATABASE MonolinkFigaroBackup SET MULTI_USER USE MonolinkFigaroBackup EXEC sp_changedbowner 'Monolink_Figaro' GO