SQL Server Application Item Restores

Availability for the Always-On Enterprise

Re: SQL Server Application Item Restores

Veeam Logoby FTBZ » Wed Jan 25, 2017 9:41 am

And not in the 9.5 and not in the 9.5 U1? :roll: :shock:
FTBZ
Influencer
 
Posts: 19
Liked: 2 times
Joined: Thu May 05, 2016 11:51 am

Re: SQL Server Application Item Restores

Veeam Logoby ASmagin » Thu Feb 09, 2017 8:42 am 1 person likes this post

I`ve investigated same issue:
For some VMs SQL DBs also were not visible through Enterprise Manager Portal. Also those DBs not returned by Veeam Powershell (as it should):
Code: Select all
$restorepoint = Get-VBRApplicationRestorePoint -SQL -Name "YOURSQLVM"
Get-VBRSQLDatabase -ApplicationRestorePoint $restorepoint[0] | ft servername, name

Result was null.

Despite results of backup job were successful, In backup job logs (located C:\ProgramData\Veeam\Backup\_JOBNAME_) I`ve found error for AAIP account: "Win32 error:Logon failure: the user has not been granted the requested logon type at this computer."
2 reasons for such error:
1) account for AAIP was denied for logon locally (by GPO) - similar issue here
2) account for AAIP doesn`t have sysadmin role permissions on SQL (add.info - here)

After I`ve granted sysadmin role permissions and allow logon locally for AAIP account, SQL databases became visible in Enterprise Manager Portal, and veeam powershell now returns DBs correctly

Hope, this workaround helps you
ASmagin
Lurker
 
Posts: 1
Liked: 1 time
Joined: Thu Feb 09, 2017 8:11 am

Previous

Return to Veeam Backup & Replication



Who is online

Users browsing this forum: Bing [Bot], Bunce and 1 guest