-
- Novice
- Posts: 8
- Liked: 1 time
- Joined: Dec 12, 2014 9:43 pm
- Full Name: Jeremy Wright
- Contact:
Where are Master, Model, MSDB in SQL Item Restore
Why can't I find the SQL System databases in the SQL Explorer. If I want to recover Master must I do it at the file level?
-
- Veeam Software
- Posts: 21163
- Liked: 2148 times
- Joined: Jul 11, 2011 10:22 am
- Full Name: Alexander Fogelson
- Contact:
Re: Where are Master, Model, MSDB in SQL Item Restore
Yes, system DBs are not shown in Veeam Explorer for SQL and can be restored via FLR.
-
- Enthusiast
- Posts: 63
- Liked: 8 times
- Joined: Jan 16, 2014 11:12 pm
- Full Name: Jon Dufour
- Contact:
[MERGED] SQL Master and MSDB question
The DB admin at my place of work is telling me master and msdb databases are not being backed up, according to some SQL report he is running.
When I start a SQL application restore, those particular DB's do not list and the rest of the databases do. But, myself not being a DBA and not knowing specifically how those system databases work, should I be seeing them in the restore list or do they truly get skipped over?
I do see them in a windows file restore, which I would expect.
Just need some more knowledge on this, thanks!
When I start a SQL application restore, those particular DB's do not list and the rest of the databases do. But, myself not being a DBA and not knowing specifically how those system databases work, should I be seeing them in the restore list or do they truly get skipped over?
I do see them in a windows file restore, which I would expect.
Just need some more knowledge on this, thanks!
-
- Veeam Software
- Posts: 21163
- Liked: 2148 times
- Joined: Jul 11, 2011 10:22 am
- Full Name: Alexander Fogelson
- Contact:
Re: Where are Master, Model, MSDB in SQL Item Restore
Jon, please see above. System databases are excluded by default in VESQL, however you should be able to restore database files and then open them manually.
-
- Enthusiast
- Posts: 63
- Liked: 8 times
- Joined: Jan 16, 2014 11:12 pm
- Full Name: Jon Dufour
- Contact:
Re: Where are Master, Model, MSDB in SQL Item Restore
Perfect, thanks Foggy!
-
- Veteran
- Posts: 296
- Liked: 25 times
- Joined: May 22, 2015 7:16 am
- Full Name: Paul
- Contact:
Re: Where are Master, Model, MSDB in SQL Item Restore
Does this mean the DBA team still have to use SQL backup tools to backup the system databases to disk and then they will be backed up as files as part of the Veeam backup job?
Thanks
Thanks
-
- Chief Product Officer
- Posts: 32201
- Liked: 7569 times
- Joined: Jan 01, 2006 1:01 am
- Location: Baar, Switzerland
- Contact:
Re: Where are Master, Model, MSDB in SQL Item Restore
Actual database files are included in the image-level backup, as any other file on the system - so no need for other backups.
Who is online
Users browsing this forum: Bing [Bot], caspar32 and 33 guests