Code to restore a database in sql server

Posted by Karthikanbarasan under Sql Server category on 2/1/2011 | Points: 40 | Views : 3081

Post Code |

Search Codes |

Code Home

RESTORE DATABASE SampleDB
FILE = 'SampleDBname'
FROM DISK = 'C:\SampleDBFull.BAK'

Alert Moderator

Bookmark It

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

Latest Code Snipptes

writing Custom pagination html code in python and django
Code snippet for setInterval
Azure Function - Connect to MS Dynamics using application user - .NET core 3.1
MS Dynamics 365- Custom action - Read input parameter values from plugin
MS Dynamics 365- Disassociate record from N-N relationship entity
Search box with icon in Navbar in bootstrap 4
Remove HTML tags using Regular Expression in C#
MS Dynamics 365- Close Quote from C# / Custom action
How to show and hide submenu in tabs using jquery
More ...