RESTORE DATABASE AdventureWorks

FROM DISK = 'C:\BackupAdventureworks.bak'

WITH REPLACE

Try this.

Balasubramaniam