Activity overview
Latest activity by essamughal
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...
Hi;
Thanks for explaining me that in details.
1- Now, my question is that now is the data size in the database is 2 GB then where the 8 GB is used in my case. I can see 3 GB would be in Log but where the 5 GB is used.
2- How can I reduce that size of the database which seems useless since I have only 2 GB data in my database.
Thanks / comments
Hi;
Thanks for explaining me that in details.
1- Now, my question is that now is the data size in the database is 2 GB then where the 8 GB is used in my case. I can see 3 GB would be in Log but whe...
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/...
Thanks Petey!
I created a rule for myself now, to delete SUCCESS email and move ERROR emails into a particular folder.
I hope you all will improve this funcationality since it is making sense to have.
Thanks / comments
Thanks Petey!
I created a rule for myself now, to delete SUCCESS email and move ERROR emails into a particular folder.
I hope you all will improve this funcationality since it is making sense to ha...
Thanks for letting me that, so I need to have MAILTO always in my statement, since I don't need email in case of SUCCESS and my job is running every 5 to 15 minutes and I'll be getting hunderds of emails in a day. So that, I removed MAILTO and used MAILONERROR parameter so that I can get email only when I get an error.
Do you have any suggestion and solution for that case ! OR I have to use MAILTO always and delete email if SUCCESS appears in subject?
Thanks / comments
Thanks for letting me that, so I need to have MAILTO always in my statement, since I don't need email in case of SUCCESS and my job is running every 5 to 15 minutes and I'll be getting hunderds of ...
As I mentioned the functionality was working in earlier version and if you see I got the following email from the same job which I created for log restore and now the MAILONERROR feature is not working in the same case when LSN is not correct. I think it might help you finding out the problem with this feature now. The explaination which you gave is making sense but it is not true for the following case since I got emails in July and in June as well.
*********************************************** Subject: ERROR - log restore [abcSTANDBY] on 7/31/2006 4:12:02 PM
SQL Backup log file
7/31/2006 4:12:01 PM: Restoring abcSTANDBY (transaction logs) from:
H:\LogShipping\logshipping\LOG_(local)_ABC_20060731_014500.sqb
7/31/2006 4:12:01 PM: RESTORE LOG [abcSTANDBY] FROM DISK = 'H:\LogShipping\logshipping\LOG_(local)_ABC_20060731_014500.sqb' WITH STANDBY = 'H:\UNDO_abcSTANDBY.DAT', MAILTO = 'essa@ilogic.com', LOGTO = 'H:\RestorLog.txt', ERASEFILES = 7, FILEOPTIONS = 1, PASSWORD = 'XXXXXXXXXX', MOVETO = 'H:\LogShipping\Processed\'
7/31/2006 4:12:01 PM: Server: Msg 3013
RESTORE LOG is terminating abnormally.
7/31/2006 4:12:01 PM: Server: Msg 4305 The log in this backup set begins at LSN 33292000001276900001, which is too late to apply to the database. An earlier log backup that includes LSN 32933000001371500001 can be restored.
***********************************************
Please, have a look into that problem, this is one of the feature of Red-Gate tool which convinced us to purchase the tool.
Thanks / comments
As I mentioned the functionality was working in earlier version and if you see I got the following email from the same job which I created for log restore and now the MAILONERROR feature is not wor...
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 ...
Hi Petey;
Thanks for your reply. I had to remove quotes from each variable as well.
Here is correct syntax for others who want to do the same task.
DECLARE @exitcode int
DECLARE @sqlerrorcode int
Declare @L_RESTORE_DATABASE_COMMAND nvarchar(4000)
Declare @L_DATABASENAME varchar(100)
Declare @L_DISK_PATH varchar(500)
Declare @L_MOVETO_PATH varchar(500)
Declare @L_STANDBY_UNDO_PATH varchar(500)
Declare @L_DATAFILE_NAME varchar(100)
Declare @L_MOVE_DATA_PATH varchar(500)
Declare @L_LOGFILE_NAME varchar(100)
Declare @L_MOVE_LOG_PATH varchar(500)
Declare @L_PASSWORD varchar(100)
SET @L_DATABASENAME = '[abc]'
SET @L_DISK_PATH = '''\\abc\E$\Dump\*.sqb'''
SET @L_MOVETO_PATH = '''\\abc\E$\Dump\Processed\'''
SET @L_STANDBY_UNDO_PATH = '''E:\UNDO_abc.DAT'''
SET @L_DATAFILE_NAME = '''abc_Data'''
SET @L_MOVE_DATA_PATH = '''E:\SecondarySiteDatabase\abc.mdf'''
SET @L_LOGFILE_NAME = '''abc_Log'''
SET @L_MOVE_LOG_PATH = '''E:\SecondarySitedatabase\abc_log.LDF'''
SET @L_PASSWORD = '''abc'''
SET @L_RESTORE_DATABASE_COMMAND = '-SQL "RESTORE DATABASE ' + @L_DatabaseName +
' FROM DISK = ' + @L_DISK_PATH +
' WITH MOVETO = ' + @L_MOVETO_PATH + ' , ' +
' STANDBY = ' + @L_STANDBY_UNDO_PATH + ' , ' +
'MOVE ' + @L_DATAFILE_NAME + ' TO ' + @L_MOVE_DATA_PATH + ' , ' +
'MOVE ' + @L_LOGFILE_NAME + ' TO ' + @L_MOVE_LOG_PATH + ' , ' +
' REPLACE, PASSWORD = ' + @L_PASSWORD + '" -E -I '
Print @L_RESTORE_DATABASE_COMMAND
Exec master..sqlbackup @L_RESTORE_DATABASE_COMMAND , @exitcode OUTPUT, @sqlerrorcode OUTPUT
Thanks / comments
Hi Petey;
Thanks for your reply. I had to remove quotes from each variable as well.
Here is correct syntax for others who want to do the same task.
DECLARE @exitcode int
DECLARE @sqlerrorcode int
D...
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...