Posts
Sort by recent activity
SQL Backup Pro Version for Remote Log shipping?
Hi;
We have been using SQL Backup Standard edition for log shipping to ship log one of the remote server. The way it is implemented right now, is as follows;
1- Used Red-Gate Stored procedure to cr...
Database Data Size confusion?
Hi;
I have a database on production total size is 10 GB approx, MDF = 7 GB and LDF = 3 GB, when red-gate takes backup it sends email as
10/18/2006 1:36:49 AM: Backup data size : 2.076 GB
10/18/...
MAILONERROR is not working in restore
Hi;
I have an issue with MAILONERROR feature, it is not working in my Restore job, the job was failed due to missing log file but the email was not sent and I did not know the job was not working o...
SQL Backup Syntax Error in Version 4.5
Hi;
I am wondering if some other DBA got the same problem, I have restore job running in production and last week I installed newer version of SQL Backup i.e. 4.5 and since then my restore job was ...
Error Code 870 Parameters?
Hi;
I am trying to parameterise all the values in the command for sqlbackup stored procedure.
DECLARE @exitcode int
DECLARE @sqlerrorcode int
Declare @L_RESTORE_DATABASE_COMMAND nvarchar(4000)
Decl...
Can we change Email message subjects or Body?
Hi;
Is it possible to change the Subject or the body of the email thru SQL Backup API? :?:
For Example: In case of Restore terminating Abnormally for any reason, let suppose Logs were in out of se...
Sequence of the Log i.e. LSN and Restore?
Hi Petey;
I am again here to bug you.
Okay, I am performing some test case of sequence of the log to restore. I am working on Log Shipping implemented by Scripts generated by SQL Backup Version 4. ...
How can I capture SQL Server Error thru SQL Backup SP?
Hi ;
I am trying to capture SQL Server Error raised thru the SQL Backup Extended SP. What I found It retures 1 in case of successful restore and if there is any error then it returns 0, which is fi...
Encryption: The password is not encrypted anymore
Hi Brian;
I am testing Version 4 now, what I noticed in encryption, in version 3 the password was encrypted in script as well. But, now it is not encrypted anymore.
In version 3 it was :
PASSWORD =...
Secondary Server instance is not in the Restore to list?
Hi ;
I just downloaded Version 4 and I tried the thing which I noticed, I have to instance on the same machine and I want to setup log shipping between two servers. But, the problem is that when I ...