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