PowerShell script exchange
Post Reply
masonit
Service Provider
Posts: 220
Liked: 16 times
Joined: Oct 09, 2012 2:30 pm
Full Name: Magnus
Contact:

Find RecoveryModel of MS databases

Post by masonit » Oct 11, 2019 12:45 pm

Hi

When doing backup of a Windows server with MS databases and Application aware with truncating of logs enabled. Is can then see in the logs that Vbr looks up RecoveryModel of the databases. Is it possible to collect this info. Without having to collect it from log files?

\Masonit

Egor Yakovlev
Veeam Software
Posts: 596
Liked: 152 times
Joined: Jun 14, 2013 9:30 am
Full Name: Egor Yakovlev
Contact:

Re: Find RecoveryModel of MS databases

Post by Egor Yakovlev » Oct 11, 2019 12:58 pm

Hi!

Like this?

/Cheers!

masonit
Service Provider
Posts: 220
Liked: 16 times
Joined: Oct 09, 2012 2:30 pm
Full Name: Magnus
Contact:

Re: Find RecoveryModel of MS databases

Post by masonit » Oct 11, 2019 1:09 pm

Not really. :)

I know there is multiple ways of extracting this info. But VBR is already doing it. I just want to collect that info from VBR in an easy way..

\Masonit

Egor Yakovlev
Veeam Software
Posts: 596
Liked: 152 times
Joined: Jun 14, 2013 9:30 am
Full Name: Egor Yakovlev
Contact:

Re: Find RecoveryModel of MS databases

Post by Egor Yakovlev » Oct 11, 2019 1:36 pm 1 person likes this post

Well, theoretically you could parse Veeam logs(default in C:\ProgramData\Veeam\Backup\) to find those lines, but that will require more effort than running a script against actual SQL server.
If you want to know information about production databases, its best to ask a SQL server that hosts those databases, rather one that depends on it. Say someone changes a job in Veeam to stop using guest processing = Veeam will not be aware of SQL changes inside, say someone excludes SQL database from processing = Veeam will not know about its Recovery Model, say someone changes schedule = your "veeam query" will get outdated and will not reflect actual status of production Recovery Model.

\Egor

masonit
Service Provider
Posts: 220
Liked: 16 times
Joined: Oct 09, 2012 2:30 pm
Full Name: Magnus
Contact:

Re: Find RecoveryModel of MS databases

Post by masonit » Oct 18, 2019 8:59 am

Use case is hundreds of ms sql servers. That already is backup by Veeam.

I have now done some testing and I am able to find everything that I am looking for in Veeam logs. In xml format as well! :) I know there is some loopholes, but they are few and ok.

Issue I have now is that sometimes there is no logs because all has been compressed in to a zip file. Is it possible to control this archive behaivure?

\Masonit

Egor Yakovlev
Veeam Software
Posts: 596
Liked: 152 times
Joined: Jun 14, 2013 9:30 am
Full Name: Egor Yakovlev
Contact:

Re: Find RecoveryModel of MS databases

Post by Egor Yakovlev » Oct 18, 2019 9:23 am

Sure. Please take a look a this KB article for more details How to Change the settings related to Veeam Backup & Replication Log Files.

Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests