Comments
Sort by recent activity
Thanks! I wasn't going to post that information [image]
I was wondering if there was a sales website where I could log in and find that information out. I'll contact your sales team. Thanks! / comments
Thanks! I wasn't going to post that information
I was wondering if there was a sales website where I could log in and find that information out. I'll contact your sales team. Thanks!
installing it manually worked like a charm! / comments
installing it manually worked like a charm!
so I looked at my SQL server machine and both the SQBCoreService is version 5.4.0.55 and xp_sqlbackup.dll is of the same version.
I am thinking that there is some issue with me using the RedGate GUI on one machine and trying to upgrade another machine....not sure why, but I am betting that is the reason.
Can I just run the sqbserversetup.exe manually on the SQL Server? If I run the installer, will it take care of the previous version or do I need to remove it first?
BTW, here are my details:
Host GUI: Windows Server 2003 R2
SQL server: Windows Server 2008
SQL Server: SQL Server 2008 / comments
so I looked at my SQL server machine and both the SQBCoreService is version 5.4.0.55 and xp_sqlbackup.dll is of the same version.
I am thinking that there is some issue with me using the RedGate GU...
can I just copy the sqbserversetup.exe from the program files directory over the SQL server box and run it?
Is there anything special that I need to do to make this successful if I do this manually? Do I need uninstall the existing version first or will the installer do that for me? / comments
can I just copy the sqbserversetup.exe from the program files directory over the SQL server box and run it?
Is there anything special that I need to do to make this successful if I do this manually...
Ok I checked this morning and it deleted the older backup files on both the local and the network share.
Since now I only have last night's backup, it will be a couple of days before I can check to make sure it ran properly, but hopefully this is a good sign. / comments
Ok I checked this morning and it deleted the older backup files on both the local and the network share.
Since now I only have last night's backup, it will be a couple of days before I can check to...
it seems that either place is being deleted.
Here is the last log entry that I have (the last relevant part) that was created on the 15th of this month: 1/15/2009 10:08:42 PM: Copied E:\Backup\FULL\01_15_09_ZachsTempDB.sqb to \\homebackup\crdl\FULL\01_15_09_ZachsTempDB.sqb.
1/15/2009 10:08:42 PM: SQL Backup process ended.
[b]1/15/2009 10:08:43 PM: Deleted msdb entries older than 1/10/2009 10:08:42 PM[/b]
1/15/2009 10:08:43 PM: Deleted local history entries older than 1/10/2009 10:08:42 PM
1/15/2009 10:08:43 PM: Mail sent successfully to: DELETEDEMAIL
the part that is bolded, is that telling that it deleted all backups older than that date? If so, why is it keeping entries for 5 days when I explicitly having it delete backups older than 3 days? I only have enough space to keep around 3 days worth of backups...
If it's defaulting to 5 days, then it would cause the issue I am having of running out of space and appearing that it's not deleting the backups...
Any thoughts? / comments
it seems that either place is being deleted.
Here is the last log entry that I have (the last relevant part) that was created on the 15th of this month:1/15/2009 10:08:42 PM: Copied E:\Backup\FULL\...
grrr...same issue again.
Is there a support phone number I can call and talk to someone about this? This is getting frustrating.
I thought I figured out the issue and it was my fault. I had the backup creating a new folder every backup with the date as the name of the backup. So I thought maybe SQL Backup wasn't smart enough to know that those folders were created by the app and that it didn't look to delete them.
So then I had all the backup files dumped into one folder and each file is named as: <date>_<name>.sqb
and here is the job:
DECLARE @exitcode int
DECLARE @sqlerrorcode int
EXECUTE master..sqlbackup N'-SQL "BACKUP DATABASES [<LIST OF DBS TO BACKUP>] TO DISK = ''E:\Backup\FULL\<AUTO>.sqb'' WITH COMPRESSION = 2, COPYTO = ''\\homebackup\FULL'', ERASEFILES = 3, FILEOPTIONS = 1, INIT, MAILTO = ''mailaddress'', THREADCOUNT = 4, VERIFY"', @exitcode OUT, @sqlerrorcode OUT
IF (@exitcode >= 500) OR (@sqlerrorcode <> 0)
BEGIN
RAISERROR ('SQL Backup failed with exit code: %d SQL error code: %d', 16, 1, @exitcode, @sqlerrorcode)
END
Where do I find the SQL Backup logs to see if there is failure and the type of failure that's going on?
Please help me on this. / comments
grrr...same issue again.
Is there a support phone number I can call and talk to someone about this? This is getting frustrating.
I thought I figured out the issue and it was my fault. I had the b...
Yeah, unless they fix this issue, I am going to have to do the same thing...which I hate because it's just one more thing I have to worry about [image]
Hopefully these guys will figure out the issue. / comments
Yeah, unless they fix this issue, I am going to have to do the same thing...which I hate because it's just one more thing I have to worry about
Hopefully these guys will figure out the issue.
That's interesting...
If that's right (which I am not doubting you, just talking out loud), then there is no way to naturally delete the local files that you create...so the FILEOPTIONS flag is meaningless without doing something manually...
I am fixing to try and run a backup after I remove the archive flag. Coincidentally, the network files have been deleting (when I had the proper FILEOPTIONS flag set) even when the archive flag was set on them... / comments
That's interesting...
If that's right (which I am not doubting you, just talking out loud), then there is no way to naturally delete the local files that you create...so the FILEOPTIONS flag is mea...
ok, all of my backup files are set to that as you said...but how do I automatically turn that off? That seems like a pretty rough manual process to have to go in there every day and uncheck the newly created backup files so they will be deleted when I want them to be deleted. / comments
ok, all of my backup files are set to that as you said...but how do I automatically turn that off? That seems like a pretty rough manual process to have to go in there every day and uncheck the ne...