Comments
Sort by recent activity
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...
Looking at the GUI, I see a Backup Folder location textbox and a File name format textbox.
Do I make this change at the file name format and name it like you said:
<Type>\<DATETIME mm-dd-yyyy>\<DATABASE>
or do I do it at the Backup Folder location: [image] \Backup\<TYPE>\<DATETIME mm-dd-yyyy>
then have the file name format as:
<DATABASE>
??? / comments
Looking at the GUI, I see a Backup Folder location textbox and a File name format textbox.
Do I make this change at the file name format and name it like you said:
<Type>\<DATETIME mm-dd-yyyy>\<DAT...
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\...
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.
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...
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...
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...