title: “veeam doesn’t put ‘Database was restored’ in the errorlog” description: "" lastmod: “2020-02-24” date: “2015-09-17” tags: [ “veeam” ] categories:

• “2015” aliases: ["/2015/09/17/veeam-doesnt-put-database-was-restored-in-the-errorlog/"] draft: No publishdate: “2015-09-17” weight: markup: “md” url: /2015/09/17/veeam-doesnt-put-database-was-restored-in-the-errorlog/

I’m doing some testing of veeam restores, and I just noticed this.

Whereas normal ‘vanilla’ disk to disk restores report about themselves in the Sqlserver errorlog

2015-09-17 12:07:08.28 spid1028    Starting up database 'my_little_db'.
2015-09-17 12:07:08.29 spid1028    The database 'my_little_db' is marked RESTORING and is in a state that does not allow recovery to be run.
2015-09-17 12:07:08.54 spid1028    Starting up database 'my_little_db'.
2015-09-17 12:07:08.88 spid1028    CHECKDB for database 'my_little_db' finished without errors on 2015-09-16 17:00:01.930 (local time). This is an informational message only; no user action is required.
2015-09-17 12:07:08.88 Backup      Restore is complete on database 'my_little_db'.  The database is now available.
2015-09-17 12:07:08.89 Backup      Database was restored: Database: my_little_db, creation date(time): 2015/07/22(13:56:48), first LSN: 83:4401:37, last LSN: 83:4417:1, number of dump devices: 1, device information: (FILE=1,TYPE=DISK: {'D:mssql_backupmy_little_dbmy_little_dbbackup_2015_09_16_174516_8366043.bak'}). Informational message. No user action required.

…veeam restores only show ancillary messages

2015-09-17 12:04:39.79 spid815     Setting database option SINGLE_USER to ON for database my_little_db.
2015-09-17 12:04:43.11 spid1026    Starting up database 'my_little_db'.
2015-09-17 12:04:43.17 spid1026    CHECKDB for database 'my_little_db' finished without errors on 2015-09-16 17:00:01.930 (local time). This is an informational message only; no user action is required.
2015-09-17 12:04:43.26 spid1025    Setting database option AUTO_CLOSE to OFF for database my_little_db.

This is perhaps more of a feature of VSS then veeam itself.

The future members of the Pogues first met when MacGowan (vocals), Peter “Spider” Stacy (tin whistle), and Jem Finer (banjo) were together in an occasional band called The Millwall Chainsaws in the late 1970s after MacGowan and Stacy met in the toilets at a Ramones gig at The Roundhouse in London in 1977.[6] MacGowan was already with The Nips, though when they broke up in 1980 he concentrated more on Stacy’s Millwall Chainsaws, who changed their name to The New Republicans.[citation needed]. Shane and Stacy performed their first gig as The New Republicans at Richard Strange’s Cabaret Futura in London’s Rupert Street Soho in the early months of 1981. Also on the bill that night were Soft Cell.

Some other stuff

The Pogues were an English or Anglo-Irish[a] Celtic punk band fronted by Shane MacGowan and others, founded in King’s Cross, London, in 1982,[1] as Pogue Mahone—an anglicisation by James Joyce of the Irish phrase póg mo thóin, meaning “kiss my arse”. Fusing punk influences with instruments such as the tin whistle, banjo, cittern, mandolin and accordion, the Pogues were initially poorly received in traditional Irish music circles—the noted musician Tommy Makem called them “the greatest disaster ever to hit Irish music”—but were subsequently credited with reinvigorating the genre.[2] The band later incorporated influences from other musical traditions, including jazz, flamenco, and Middle Eastern music.

some text

$Arguments
foreach ($A in $Arguments) {$A}
foreach ($A in $Arguments) {$A[3]}
foreach ($A in $Arguments) {$Arguments[3]}
foreach ($A in $Arguments) {$i++; $i}
foreach ($A in $Arguments) {$i++; if ($i -gt 0){$i=0;write-host "$String"; $String= ""} $String = $String + $A + " " }
foreach ($A in $Arguments) {if ($i -gt 0){$i=0;write-host "$String"; $String= ""} $String = $String + $A + " " ; $i++}
foreach ($A in $Arguments) {if ($i -gt 1){$i=0;write-host "$String"; $String= ""} $String = $String + $A + " " ; $i++}
$i = 0; foreach ($A in $Arguments) {if ($i -gt 1){$i=0;write-host "$String"; $String= ""} $String = $String + $A + " " ; $i++}

I’ve watched a couple of new-ish films recently in which the biggest star gets killed off quite early on. The only equivalent I can think of is Janet Leigh in Psycho. It’s a bit of a surprise, in any case.

After my laptop was upgraded from Windows 10 to Windows 11 I got the following when I tried to do anything much in #Powershell

“Cannot dot-source this command because it was defined in a different language mode. To invoke this command without importing its contents, omit the ‘.’ operator.”

This was because, for some reason, the upgrade had re-pointed the System Environment variables TEMP and TMP.

The new folders pointed to by those variables are nobbled by our Software Restriction Policy. I amended the two variables to point at folders from which software is allowed to run and everything started working again.

This is the standard bit

$Token = 'whatever-the-token-is' | ConvertTo-SecureString -AsPlainText -Force

$Body = @{ content = 'Testing again. 1 , 2, 1, 2' h = 'entry' 'post-status' = 'draft' }

You then put ‘?mp-destination=’ followed by the URL of the test micro.blog on the end of the base URL as in the gist below. (The markdown conversion is nausing up the URL if I type it in here - sorry!

invoke-restmethod [micro.blog/micropub](https://micro.blog/micropub?mp-destination=https://mattypenny-test.micro.blog) -Method post  -Authentication Bearer -Token $Token -Body $Body

url                                                              preview                                                 edit
---                                                              -------                                                 ----
[mattypenny-test.micro.blog/2024/02/1...](https://mattypenny-test.micro.blog/2024/02/18/testing-again.html) [micro.blog/account/p...](https://micro.blog/account/posts/143155/preview/3875601) [micro.blog/account/p...](https://micro.blog/account/posts/143155/edit/3875601)

Dec 23, 2016

TodayILearned that Angelina Jolie has a Christopher Marlowe quotation as a tattoo goinswriter.com/austin-kl… via @jeffgoins ¹

Nov 28, 2016

TodayILearned that the pincers of a scorpion are called ‘pedipalps’ and that baby scorpions are ‘scorplings’ abc.net.au/radio/pro…

Nov 23, 2016

jkjjhjhj

Welcome to your test blog! You can create new posts here to test theme and design changes.

Here are instructions for disabling wsh. This is particularly used by DBAs to run RDA (Remote Diagnostic Agent) to gather Oracle and Oracle-related diagnostics.

• Run regedit

• Go to HKEY_LOCAL_MACHINE\Software\Microsoft\Windows Script Host\Settings\Enabled (the Microsoft doc says to create it if its not there)

• Set the value to 0

That’s it. You get the message:

Windows Script Host access is disabled on this machine. Contact your administrator for details.

If you try to use it.

If it needs to be re-enabled, then you set the value to 1 - we often need to use it on the database servers to get diags for Oracle, but we should disable it each time after use.

The MS reference is:

Ms ref

BJS is the scheduling tool we use on our Windows servers. Its produced by Camellia Software:

• Camellia website
  
  ….and it’s very good.
  
  I had a problem this morning though.
  
  

BJS jobs would go into ‘Awaiting Exec’ state for up to 45 minutes before running.

The Log file would show:


* BATCH JOB SERVER
* A Camellia Software Product - www.CamelliaSoftware.com
* Copyright 1994-1998
* Version 2.1 - A Build 529
* ***** J O B L O G

JOB NO. 0737


Job Name: BIG Backup PWHC Open
Username: xxx
Submitted by:

Server: bigserver
Source File: \bigserverD$BJSbig_backup_pwhc_open.bat
Output Directory: D:BJSBJSWORK
*
***

>
> 11/04/05 08:00:29 PM Job scheduled for execution
>
> 11/04/05 08:45:00 PM Job started execution
>

The reason for this was/is that there is a setting under Server-Administer-Change Service Parameters called ‘Maximum Batch Job Processes’. This limits the number of jobs you can run at any one time. It should be set to twice the number of jobs you might want to have running conccurrently.

There is also a setting against Job Class which does something similar - under Server-Administer-Job Class Maintenance

A case of RTFM….