right now we are trying to restore a DB backup and overwrite the existing one, but whenever we see there are connection to the database, the restore doesn't work, it is so weird that it happens and I didn't try it before.
the backup option is :
RESTORE DATABASE [xxx]
FROM DISK = N'C:\temp\yyy\xxxVA_02.BAK'
WITH FILE = 1,
MOVE N'VMSVA_02' TO N'D:\Database\MDF\xxxVA_02.mdf',
MOVE N'VMSVA_02_Indexes' TO N'D:\Database\MDF\xxxVA_02_Indexes.ndf',
MOVE N'VMSVA_02_Audit' TO N'D:\Database\MDF\xxxVA_02_Audit.ndf',
MOVE N'Partition_1' TO N'D:\Database\MDF\Partition_1.ndf',
MOVE N'Partition_2' TO N'D:\Database\MDF\Partition_2.ndf',
MOVE N'Partition_3' TO N'D:\Database\MDF\Partition_3.ndf',
MOVE N'Partition_4' TO N'D:\Database\MDF\Partition_4.ndf.ndf',
MOVE N'Partition_5' TO N'D:\Database\MDF\Partition_5.ndf.ndf',
MOVE N'VMSVA_02_log' TO N'D:\Database\LDF\xxxVA_02_log.ldf',
STATS = 10
any way to disable/kill the existing DB connection and let the restore works well ?