Activity overview
Latest activity by RodC
SQL Backup Pro thinks it is SQL Backup Lite
I am using the SQL Backup Pro that came with my purchase of SQL Toolbelt.
After a short period of working, SQL Backup Pro now thinks that is it SQL Backup Lite and will not link to my Windows 2008 ...
Sorry for the delay in getting back. I was called away to a number of meetings.
There are no events in the log for SQL Backup, but there are ones from SQL Agent for each backup task. I have copied a sample at the bottom of this post.
Looking into this further, there seems to be a license problem.
We purchased SQL Tool Belt which comes with SQL Backup Pro, but it now seems to think that we have SQL Backup Lite.
I have sent a support email off and am waiting for a reply.
Sample Event Log Entry.
SQL Server Scheduled Job 'SQL Backup transaction log job created 29/06/2010 3:13:22 PM' (0x49E7F2A14C5BE34A945B63E7E6221DBA) - Status: Failed - Invoked on: 2010-07-28 09:00:00 - Message: The job failed. The Job was invoked by Schedule 16 (Schedule 1). The last step to run was step 1 (execute master..sqlbackup).
/ comments
Sorry for the delay in getting back. I was called away to a number of meetings.
There are no events in the log for SQL Backup, but there are ones from SQL Agent for each backup task. I have copied ...
I am getting what appears to be a similar error.
I have a windows server 2008 R2 machine running
SQL Server 2008 Enterprise Edition (64 bit)
With SQL Backup 6.3.0.48 installed.
Backups just stop. The service on the machine still looks like it is running, but backups and notifications stop.
I don't need to stop the service through task manager, it restarts cleanly via the services manager.
My SQL Backup GUI reports all of the scheduled jobs, they just don't happen. / comments
I am getting what appears to be a similar error.
I have a windows server 2008 R2 machine running
SQL Server 2008 Enterprise Edition (64 bit)
With SQL Backup 6.3.0.48 installed.
Backups just stop. T...
Not sure who Keith is, but for my case, the entities I am comparing are views from a Microsoft CRM database.
The Left side is a back up that was restored into a separate sql database and the right side is the "live" database.
The views are identical (and explicit) in field order. The SQL data compare field list is not in the same order as the view.
I am attempting to exclude a number of columns from the comparison as the comparison returns false positives if these fields are included.
Each view can have several hundred columns and the full (uncompared) dataset can have millions of rows.
I have been able to unmap the columns, but it is a real trial when I have to go to the top of the column list each time and carefully scroll through to find the next column to unmap. At which point the column list reorders itself and I have to start at the top again.
It would be good if there was some way to order the columns (like the result set allows) and for the column list to stay in that order. / comments
Not sure who Keith is, but for my case, the entities I am comparing are views from a Microsoft CRM database.
The Left side is a back up that was restored into a separate sql database and the right ...
I applied the patch and the issue is still there.
Here are three screenshots that show the problem [image] [image] [image]
As you can see, I unmapped the CreatedOn field and the fields all reordered themselves in an arbitory manner.
I think it would be better if they all where presented in alpha order and stayed that way.
Cheers. / comments
I applied the patch and the issue is still there.
Here are three screenshots that show the problem
As you can see, I unmapped the CreatedOn field and the fields all reordered themselves in an arbit...
Column Mapping Issue
When I am unmapping columns, each time I unmap one column, the whole column list reorders itself in some arbitrary manner. This is quite annoying when I have tables with 100's of fields (Thank you ...