First I took a backup of DB05
BACKUP DATABASE DB05 TO DISK='F:\backup\DB05_20190131.BAK'
Then I restored this DB05 as test
RESTORE DATABASE test from DISK='F:\backup\DB05_20190131.BAK'
My test DB is working fine. But when I am trying to Restore
the same backup as DB05, I faced an Error
Troubeshooted and found a Solution is to move datafile
(Rename datafile) while Restoring DB05.
RESTORE DATABASE db05 FROM DISK = 'F:\backup\DB05_20190131.BAK'
Move N'DB05' to N'F:\data\DB05\DB05.mdf',
Move N'DB05_log' to N'F:\data\DB05\DB05_log.ldf',
NOUNLOAD, REPLACE, STATS = 1
And it is completed without any issue.