I tried to restore a database for which i have altready
created backup and backup device.
my device name is : fokaadd
my database backup name is: fokaadd.dat
my database log name is: fokaaddLog.dat

my code for restore is :

        RESTORE DATABASE test
        From fokaadd

It is not restoring and giving a message:

the message is :

Server: Msg 1834, Level 16, State 1, Line 1
The file 'C:\Program Files\Microsoft SQL Server\MSSQL\Data\VBSettings_Data.MDF' cannot be overwritten. It is being used by database 'VBSettings'.

How can I restore my database from backup;
If nay one konws the solution pls send me .


my email address is :

         [email protected]

It looks like your trying to restore your data file, not your back up file.

using this example restores your database and move the file to a new location if necessary.

restore database Test
FROM DISK = 'C:\dbbackups\test_db_200310122203.bak'
with recovery, replace,
MOVE 'test_data' TO 'C:\sqldata\mssql\data\test.mdf',
MOVE 'test_log' TO 'C:\sqldata\mssql\data\test.ldf'

I hope this helps

Also, If your are using the database you may be the culprit and it reports someone is blocking or using it. Use master and restore your database.