SQL Backup Restore-only version

Compresses, encrypts, secures and monitors SQL Server backups.

Moderators: JonathanWatts, Chris Auckland, eddie davis, Colin Millerchip, Brian Harris, james.billings, RBA, petey

SQL Backup Restore-only version

Postby nirupam » Tue Jul 03, 2012 3:29 pm

Hi,

We have recently built a setup where the backups of Server1 are restored overnight to Server2. Server1 has SQL Backup full version installed whereas Server2 has the Read-only version. However, it appears not all restore functions are available in the Restore-only version (e.g. disconnect connections before restore).

Is there a way an alert mail can be configured so we get to know when the restore failed?

Thanks in advance.
Nirupam
nirupam
 
Posts: 2
Joined: Tue Jul 03, 2012 12:30 pm

Postby petey » Wed Jul 04, 2012 4:03 am

The read-only version cannot send e-mails out either. To send e-mails when SQL Backup encounter errors, you'll need to use the e-mail notification features in SQL Server Agent.
Peter Yeoh
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 7
petey
 
Posts: 2226
Joined: Sun Apr 24, 2005 12:34 pm

Re:

Postby nirupam » Thu Jul 05, 2012 12:31 pm

petey wrote:The read-only version cannot send e-mails out either. To send e-mails when SQL Backup encounter errors, you'll need to use the e-mail notification features in SQL Server Agent.


Hi Petey,

Thanks for your response.

The problem also was that SQLBackup does not raise an error back to SQL for any failure therefore the failure went unreported in SQL. I have worked around it by using the exitcode and sqlerrorcode output parameters of SQLBackup to fetch the SQLBackup error back to SQL.

Cheers!
Nirupam
nirupam
 
Posts: 2
Joined: Tue Jul 03, 2012 12:30 pm


Return to SQL Backup 7

Who is online

Users browsing this forum: No registered users and 2 guests