Red Gate forums :: View topic - SQL Backup Restore-only version
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Backup 7
SQL Backup 7 forum

SQL Backup Restore-only version

Search in SQL Backup 7 forum
Post new topic   Reply to topic
Jump to:  
Author Message
nirupam



Joined: 03 Jul 2012
Posts: 2

PostPosted: Tue Jul 03, 2012 3:29 pm    Post subject: SQL Backup Restore-only version Reply with quote

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
Back to top
View user's profile Send private message
petey



Joined: 24 Apr 2005
Posts: 2301

PostPosted: Wed Jul 04, 2012 4:03 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
nirupam



Joined: 03 Jul 2012
Posts: 2

PostPosted: Thu Jul 05, 2012 12:31 pm    Post subject: Re: Reply with quote

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
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group