Code to restore a database in sql server

Karthikanbarasan
Posted by Karthikanbarasan under Sql Server category on | Points: 40 | Views : 2300
RESTORE DATABASE SampleDB
FILE = 'SampleDBname'
FROM DISK = 'C:\SampleDBFull.BAK'

Comments or Responses

Posted by: Gow.net on: 2/17/2012 Level:Starter | Status: [Member] | Points: 10

restore database aaaa file='aaaa' from disk='D:\aaaa.bak'


sir i get following error
Msg 3154, Level 16, State 4, Line 1
The backup set holds a backup of a database other than the existing 'aaaa' database.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.

how to solve help me please

Login to post response