Backup and restore

select Name
from sys.database_files
go

backup database fiscalpos to disk = 'C:\fiscalData\fp.bak'
go

EXEC('RESTORE FILELISTONLY FROM DISK = ''C:\fiscalData\fp.bak''')

RESTORE DATABASE ARHIVA
FROM DISK = 'C:\fiscalData\fp.bak'
WITH MOVE 'xx' TO 'C:\fiscalData\Arhiva.mdf',
MOVE 'xx_log' TO 'C:\fiscalData\Arhiva.ldf'
go

ALTER DATABASE ARHIVA SET READ_ONLY WITH NO_WAIT