Comprehensive data protection for all workloads
Post Reply
mamosorre84
Veeam Legend
Posts: 336
Liked: 34 times
Joined: Oct 24, 2016 3:56 pm
Full Name: Marco Sorrentino
Location: Ancona - Italy
Contact:

How to MS SQL - System database restore

Post by mamosorre84 »

Hello,

I read in Veeam documentation:

By default, system databases (master, model, msdb) are skipped from transaction log processing and are not a part of the Veeam Explorer for Microsoft SQL Server restore workflow. To recover these databases, you can use file-level restore.

My question is: using file level restore to recover for example the master db, do I have to replace the mdf and ldf files in the source VM? What are the correct steps?

Thank you

Marco
DGrinev
Veteran
Posts: 1943
Liked: 247 times
Joined: Dec 01, 2016 3:49 pm
Full Name: Dmitry Grinev
Location: St.Petersburg
Contact:

Re: How to MS SQL - System database restore

Post by DGrinev »

Hi Marco,

You should restore necessary DB files by using file level restore and manually replace them. Thanks!
Post Reply

Who is online

Users browsing this forum: Google [Bot] and 126 guests