Activity overview
Latest activity by MasterCephus
Matching Columns in Generation
I need to generate data for a table and the situation exists where two fields are dependent on each other. For example, say I have two fields:
* ProductID
* ProductDescription
and I have a referen...
Find out how many licenses I have used
We bought 5 SQLToolbelt licenses about a year ago. We've used the Backup licenses on a couple of servers, but I am not sure how many. Is there a way I can find out how many I have left?
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...
Upgrade from 5.4.0.55 to 6.2.0.143 failes
So I upgraged the GUI to version 6.2 and then I click on the little icon on my server to upgrade my server (the GUI and the server are not on the same machine).
It then warns me about the 14 day tr...
Erasing backup files locally & remotely
I am fixing to set up a backup job for production servers and I want to make sure that I understand exactly how to do what I want to do. I want to keep about 2 days backups on the local share and ...
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...