Problems with new version
a) After the install, I was unable to connect to our server because of the missing xp_sqlbackup.dll. I know I have permissions to the server. I ran the statement suggested in an earlier message and it still didnâ€™t work (after dropping the existing xp_sqlbackup.dll). Then I tried it again hardcoding the path to the new .dll and it seemed to work this time. So I got past this eventually.
b) I created a scheduled job through your tool to do a backup and it says it was created successfully. When I ran the job, it says it ran successfully but actually didnâ€™t. When I look at the job history I get â€œExecuted as user: NT AUTHORITY\SYSTEM. Error executing extended stored procedure: Invalid # of Parameters [SQLSTATE 01000] (Message 20001). The step succeeded.â€. This doesnâ€™t seem like a â€˜step succeededâ€™. Here is the code generated. This is exactly the script sql backup created.
DECLARE @exitcode int
DECLARE @sqlerrorcode int
exec master..sqlbackup N'-SQL "BACKUP DATABASES EXCLUDE [master, msdb, model] TO DISK = ''C:\BACKUPS\<AUTO>'' WITH NAME = ''<AUTO>'', DESCRIPTION = ''<AUTO>'', ERASEFILES_ATSTART = 5, COMPRESSION = 1, THREADS = 1"', @exitcode OUTPUT, @sqlerrorcode OUTPUT
IF (@exitcode <>0) OR (@sqlerrorcode <> 0)
RAISERROR ('SQL Backup job failed with exitcode: %d SQL error code: %d', 16, 1, @exitcode, @sqlerrorcode)
c) This doesnâ€™t seem like a â€˜step succeededâ€™. One of the problems we had with the 3.0 version of Sql Backup was the lack of error reporting. If the backup failed, the job still reported success. The new version is supposed to report errors but fails on itâ€™s own generated code and still doesnâ€™t tell us.
We are looking at LightSpeed but are hesitant because of the cost but we need a reliable backup tool. We were very excited to see a new version of Sql Backup but not so much now.
Is there a newer version than the default upgrade?
We are running sql server standard ver. 8.00.2039 (sp4) on a NT INTEL x86 platform. OS is NT â€“ 5.0
Thank you for your attention.