MSSQL database backup, monitoring and permissions

Availability for the Always-On Enterprise

MSSQL database backup, monitoring and permissions

Veeam Logoby sandsturm » Thu Aug 24, 2017 1:56 pm


I am planning to migrate the backup for our MSSQL databases onto veeam. Actually I couldn't answer the following two questions:
- is there somewhere a report where I can see which databases are backed up and which are not, if there were failures? Our database admins want to have such a report...
- what permissions are required in minimum on the sql server/database to be able to backup and restore databases?

thx and regards
Posts: 53
Liked: 1 time
Joined: Mon Mar 23, 2015 8:30 am

Re: MSSQL database backup, monitoring and permissions

Veeam Logoby vClintWyckoff » Thu Aug 24, 2017 2:42 pm

1.) You can configure notifications in your backup job where you have enabled the SQL Server transaction log backup - This is under Storage, Advanced. Your DBA will receive a report that looks like this:


2.) Here's a few links from the Veeam HelpCenter that would be useful to you when running SQL backup with Veeam Backup & Replication 9.5 (latest version)
[*]Required Permissions -
Posts: 500
Liked: 109 times
Joined: Sat Oct 27, 2012 1:22 am
Location: Technical Evangelist
Full Name: Clint Wyckoff

Return to Veeam Backup & Replication

Who is online

Users browsing this forum: Bing [Bot], Google [Bot], Google Feedfetcher, Majestic-12 [Bot], mickey.friedman, pickan and 67 guests