User profile for Matthew Flatt

Hi keymoo, You can either open the SQL Backup GUI, select Tools>Optionss and set the Log file folder location or edit the following registry key on each server : HKLM\Software\Red Gate\SQL Backup\BackupSettingsGlobal\<instance name>\LogFolder I hope this helps. / comments

Hi keymoo, You can either open the SQL Backup GUI, select Tools>Optionss and set the Log file folder location or edit the following registry key on each server : HKLM\Software\Red Gate\SQL Backup\B...

0 votes

Hi, Have you tried restoring/copying over the local copy of that transaction log backup to see if it's also corrupted? If you wish to continue log shipping and have a corrupted backup with no other copies, the database will need to be reseeded. You could try restoring the log to a point in time, it may work but I am unsure if SQL Server goes through the whole restore and then rolls back to that point or only restores up to that point and then stops. If it's the latter and your file is corrupted part way through you may be able to restore to before that corruption point and have the database available. Thanks, / comments

Hi, Have you tried restoring/copying over the local copy of that transaction log backup to see if it's also corrupted? If you wish to continue log shipping and have a corrupted backup with no other...

0 votes

Hi, It looks like you will need to either restore the full backup and all subsequent transaction log backups if you have them up until the corrupted file or reseed the database with a full backup if this is a log shipping scenario. I apologize you encountered this problem. / comments

Hi, It looks like you will need to either restore the full backup and all subsequent transaction log backups if you have them up until the corrupted file or reseed the database with a full backup i...

0 votes

Hi John, What error message did you encounter when originally trying to restore the corrupted file? Did you try converting it to Native format using our sqb2mtf tool and restoring again? Thanks, / comments

Hi John, What error message did you encounter when originally trying to restore the corrupted file? Did you try converting it to Native format using our sqb2mtf tool and restoring again? Thanks,

0 votes

I have created another script which more suits your needs. The script will read file names from a directory and overwrite existing databases/create new databases on a server. If you are interested in this script please e-mail support@red-gate.com and put this forum posting in the subject/content. It is a little big to paste here. Thanks, / comments

I have created another script which more suits your needs. The script will read file names from a directory and overwrite existing databases/create new databases on a server. If you are interested ...

0 votes

Hi jortizv, I have the following script which may help, it doesn't exactly meet your requirements though. The script will go through each database on a server and restore a full backup appending 'Test' to the database name. If your backup SQL Server doesn't have the databases already created, you could retrieve the database names from a text file or something similar. The backup part of the script will need editing depending on logical/physical filenames etc USE master DECLARE @dbname NVARCHAR(260) DECLARE @newdbname NVARCHAR(260) DECLARE cDatabases CURSOR FOR SELECT name FROM sysdatabases WHERE name != 'tempdb' AND name != 'master' AND name != 'msdb' --Databases to ignore DECLARE @datestamp VARCHAR(30) DECLARE @restorepath VARCHAR(500) DECLARE @filename VARCHAR(500) DECLARE @restorestring VARCHAR(1000) DECLARE @exitcode INT DECLARE @sqlerrorcode INT SET @restorepath = 'D:\Backup\' --Directory backups are stored OPEN cDatabases FETCH NEXT FROM cDatabases INTO @dbname WHILE @@FETCH_STATUS = 0 BEGIN SET @newdbname = @dbname + 'Test' SET @filename = @restorepath + 'FULL_SQL2005_' + @dbname + '_*.sqb' -- FULL_SQL2005 relates to my template for naming backups - Only 1 full backup for each database can be in the Backup location. SET @restorestring = '-SQL "RESTORE DATABASE [' + @newdbname + '] FROM DISK = ''' + @filename + ''' WITH RECOVERY, MOVE ''' + @dbname + ''' TO ''D:\Data\' + @dbname + '.mdf'', MOVE ''' + @dbname + '_log'' TO ''D:\Data\' + @dbname + '.ldf''" -E' EXEC master..sqlbackup @restorestring, @exitcode OUTPUT, @sqlerrorcode OUTPUT IF ( @exitcode <> 0 ) OR ( @sqlerrorcode <> 0 ) BEGIN RAISERROR ( 'SQL Backup job failed with exitcode: %d SQL error code: %d', 16, 1, @exitcode, @sqlerrorcode ) END FETCH NEXT FROM cDatabases INTO @dbname END CLOSE cDatabases DEALLOCATE cDatabases I hope this is useful for you. / comments

Hi jortizv, I have the following script which may help, it doesn't exactly meet your requirements though. The script will go through each database on a server and restore a full backup appending 'T...

0 votes

Hi anil_d, Did you take any backups of the LoadTest database? Without a backup to restore from the chances of retrieving your data are most likely slim. You could try a data recovery tool specific to SQL Server but I do not have any recommendations and have not used any products myself. I apologise I can't be of more help. Thanks, / comments

Hi anil_d, Did you take any backups of the LoadTest database? Without a backup to restore from the chances of retrieving your data are most likely slim. You could try a data recovery tool specific ...

0 votes

Hi Derek, Could you please e-mail us the script that you are trying to run? If you could also include a SQL Compare snapshot of the source and destination that would be useful. Please e-mail them to support@red-gate.com quoting Call reference number F0016496. Thanks, / comments

Hi Derek, Could you please e-mail us the script that you are trying to run? If you could also include a SQL Compare snapshot of the source and destination that would be useful. Please e-mail them t...

0 votes

Hi, Thanks for your feedback. I've logged this in our bug track system. We will consider this for inclusion in a future version of SQL Response. Thanks, / comments

Hi, Thanks for your feedback. I've logged this in our bug track system. We will consider this for inclusion in a future version of SQL Response. Thanks,

0 votes

Hi, Unfortunately we don't have anything that matches your specific requirements. Have you tried our Log Shipping Monitor Tool? This won't send you a daily e-mail reporting the status but it could be looked at to quickly see if everything is working correctly. You can download it from : http://labs.red-gate.com/index.php/Log_Shipping_Monitor I hope this helps, / comments

Hi, Unfortunately we don't have anything that matches your specific requirements. Have you tried our Log Shipping Monitor Tool? This won't send you a daily e-mail reporting the status but it could...

0 votes

How can we help you today?

Matthew Flatt

Comments