• Status: Solved
  • Priority: Medium
  • Security: Private
  • Views: 41
  • Last Modified:

Error while restoring the database in sql sever 2016

Hi,

How to resolve probelm related to restoring of database backup in sql server 2016,backup and restore are of same version.

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.SmoExtended)
An In-Memory OLTP physical database was restarted while processing log record ID
0
java novice
Asked:
java novice
  • 2
1 Solution
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Can you provide more information and some screen shoots so we know how are you trying to restore the database?
0
 
java noviceAuthor Commented:
through SSMS,restore database from device
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
I was expecting that. You're having some issue with your SSMS. Are you using the last version of the SSMS?
Anyway, you can try to open a new query window and run the RESTORE command.
0

Join & Write a Comment

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now