Comments
Sort by recent activity
Hi,
You are getting syntax error because filename is not being passed correctly in the command. For the syntax to work .. it should pass it as DISK = ''c:\temp\mybackup.sqb'' which is not happening in the script you have mentioned.
So you can use the below command instead:
declare @filename varchar(100)
declare @todaydate varchar(13)
declare @sql varchar(4000)
set @todaydate=datename(weekday,getdate())+'.sqb'
set @filename = 'c:\temp\'+@todaydate
set @filename = '''' + '''' + @filename + '''' + ''''
set @sql = REPLACE('execute master..sqlbackup ''-SQL "Restore DATABASE [xx] FROM DISK = {0} WITH RECOVERY, REPLACE"''', '{0}' ,@filename)
EXEC(@sql)
Hope this helps.
Regards,
Priya / comments
Hi,
You are getting syntax error because filename is not being passed correctly in the command. For the syntax to work .. it should pass it as DISK = ''c:\temp\mybackup.sqb'' which is not happening...
Hi,
You are not able to restore to any point in time between Friday Tlog and Sunday Full backup because no log backup has been performed between this time (and hence GUI doesn't give you the option).
Depending on disaster recovery requirements of your environment, I would schedule log backups between Fri TLog and Sunday Full backup.
jchertudi wrote:
Seems like there should be a configuration or job so that I can backup the TLOG immediately before the FULL backup, thereby creating 6 logs a week but letting me restore to any point. Possible?
To achieve above, the easiest way in my view would be to -- modify your full backup job/ script. Add a step/ command to do a log backup just before your full backup.
Hope this helps.
Thanks,
Priya / comments
Hi,
You are not able to restore to any point in time between Friday Tlog and Sunday Full backup because no log backup has been performed between this time (and hence GUI doesn't give you the option...
Yes you are right.
Regards,
Priya / comments
Yes you are right.
Regards,
Priya
Hi,
You can use 'EXCLUDE' clause when creating the backup jobs. There is a drop down on the UI (Exclude these) in the 2nd step of Backup and Schedule Backup wizard. Please read the help file if you need more information: http://www.red-gate.com/supportcenter/Content.aspx?p=SQL%20Backup&c=SQL_Backup/help/5.4/SBU_CreatingBackupsSelectDbase.htm&toc=SQL_Backup/help/5.4/toc.htm http://www.red-gate.com/supportcenter/Content.aspx?p=SQL%20Backup&c=SQL_Backup/help/5.4/SBU_BACKUP_cmd.htm&toc=SQL_Backup/help/5.4/toc545257.htm
Thanks,
Priya / comments
Hi,
You can use 'EXCLUDE' clause when creating the backup jobs. There is a drop down on the UI (Exclude these) in the 2nd step of Backup and Schedule Backup wizard. Please read the help file if you...
Hi,
When you run
EXEC master..sqbutility 9997
SQBCoreService_bugreport.txt is generated in the folder where the SQL Backup Agent service is installed.
I would recommend you to open a support incident with support@red-gate.com and send them SQBCoreService_bugreport.txt.
Thanks,
Priya / comments
Hi,
When you run
EXEC master..sqbutility 9997
SQBCoreService_bugreport.txt is generated in the folder where the SQL Backup Agent service is installed.
I would recommend you to open a support incide...
Hi,
Apart from using split files, you can also try different compression levels too. Try using THREADCOUNT also. It is always better to do a backup locally and then use COPYTO to copy the backup files rather than backing to the network directly (depending on external network resources, backup performance becomes less predictable).
Hope this helps.
Regards,
Priya / comments
Hi,
Apart from using split files, you can also try different compression levels too. Try using THREADCOUNT also. It is always better to do a backup locally and then use COPYTO to copy the backup fi...
Hi,
1. You will need one SQL Backup Pro license per cluster node. If your existing license is Pro then you can use the same license key when you cluster your server.
2. SQL Backup Server Component installer (SQBServerSetup.exe) is cluster aware. So the easiest thing would be to uninstall the server components on the servers, then after you have clustered your environment then install the server components again. You must save your data store if you want to preserve the SQL Backup activity history when you uninstall the server components. This data store should ideally be placed on shared disk. Please read the help file for more information: http://www.red-gate.com/supportcenter/Content.aspx?p=SQL%20Backup&c=SQL_Backup/help/5.4/SBU_Clusters.htm&toc=SQL_Backup/help/5.4/toc.htm
Hope this helps.
Regards,
Priya / comments
Hi,
1. You will need one SQL Backup Pro license per cluster node. If your existing license is Pro then you can use the same license key when you cluster your server.
2. SQL Backup Server Component...
adriangodong wrote:
I saw all the files available.
Therefore, something must've been wrong when I browsed the files.
Apparently, you'll have to add a network share to the field called sql server first before you can browse the files. Very confusing.
Point 2, I have to use network share path with one level above the backup directory. Otherwise, the .sqb file behave like empty directories.
For instance, if my sqb is at "\\nas\\backup\database\asd.sqb", I have to add "\\nas\\backup" instead of "\\nas\\backup\database".
Hope those two pain points are addressed in future version.
Hi,
Sorry for the inconvenience. Point 2 has been addressed already. Please try version 5.4 of SQL Backup.
Regarding your first point ... the label has already been changed to make it more clearer. Please try 5.4.
But I agree that there are some usability issues with the existing file browser when adding network share. We did hear this from few more users and hence decided to re-write the file browser completely. This will be released in next version of SQL Backup. So please try 5.4 and also wait for the next release which will have much improved file browser.
Thanks,
Priya / comments
adriangodong wrote:
I saw all the files available.
Therefore, something must've been wrong when I browsed the files.
Apparently, you'll have to add a network share to the field called sql server ...
adriangodong wrote:
Oh, and a notification system for the forum would be useful too.
Hi,
If you go to your profile then you have an option called 'Always notify me of replies'. Please set this on and this should then notify you.
Thanks,
Priya / comments
adriangodong wrote:
Oh, and a notification system for the forum would be useful too.
Hi,
If you go to your profile then you have an option called 'Always notify me of replies'. Please set this ...
adriangodong wrote:
Cool.
We're using network share, the network share root on the file browser does not display anything. Is it possible that the future version uses Windows file browser instead of some custom browser?
Hi,
If you have permissions on the network share then it should display the shared folders on the network. Can you please run the following in query analyzer and let us know if it returns any results:
exec master..sqbdir '\\mynetworkshare\share'
Thanks,
Priya / comments
adriangodong wrote:
Cool.
We're using network share, the network share root on the file browser does not display anything. Is it possible that the future version uses Windows file browser instead...