Comments
Sort by recent activity
I'm trying to use it for the RESTORE HEADERONLY command. I need to extract information from the header in order to do what I need to do.
John / comments
I'm trying to use it for the RESTORE HEADERONLY command. I need to extract information from the header in order to do what I need to do.
John
I ran the exact code you posted above and just replaced the path with a path to one of our files. I'm still getting the same error "Syntax error: 'SINGLERESULTSET' after 'WITH'"
File version of SQBCoreService.exe is 5.1.0.2781
When I go to help > about it says I'm using Red-Gate SQLBackup 5.4.0.55
Windows version is Windows Server 2003 Enterprise Edition x64 SP2
SQL Server is SQL Server 2005 Standard Edition x64 SP3 CU1
(9.0.4207)
Please let me know if you need any other information.
Thanks!
John / comments
I ran the exact code you posted above and just replaced the path with a path to one of our files. I'm still getting the same error "Syntax error: 'SINGLERESULTSET' after 'WITH'"
File version of SQ...
About 5 min after I posted it I realized I was putting the ending double quote right after the path which was excluding the WITH SINGLERESULTSET command.
Now my problem is that in SQLBackup 6.0+ it works fine but in SQLBackup 5.4.0.55 I'm getting a syntax error saying that there's a syntax error SINGLERESULTSET after WITH. But it says this is supported since 5.3. Can anyone tell me if this is a mistake?
John / comments
About 5 min after I posted it I realized I was putting the ending double quote right after the path which was excluding the WITH SINGLERESULTSET command.
Now my problem is that in SQLBackup 6.0+ it...
We are using SQLBackup version 5.4.0.55 and when I include the WITH SINGLERESULTSET parameter to the end of the command it is still giving me two result sets.
One result set gives me the information about the backup file and the second is giving me exit code information just like when I don't use the WITH SINGLERESULTSET option.
Is there something that I am missing? I need to get this working because we are making some custom restore scripts that require header information.
Thanks,
John / comments
We are using SQLBackup version 5.4.0.55 and when I include the WITH SINGLERESULTSET parameter to the end of the command it is still giving me two result sets.
One result set gives me the informatio...
PS: The full backup is experiencing the same issue as the log backup. / comments
PS: The full backup is experiencing the same issue as the log backup.
The hosting facility was able to upgrade us to version 5.2. This seems to have fixed the problem. I believe the root cause was that in 4.x you can't specify the software to run as a particular service account whereas in 5.x you can (through the SQL Red Gate Agent service). The service account I specified has the proper permissions. I'm thinking that the software in 4.x runs as some other system account that didn't have specific access to the share. / comments
The hosting facility was able to upgrade us to version 5.2. This seems to have fixed the problem. I believe the root cause was that in 4.x you can't specify the software to run as a particular se...
Oh! I didn't even realize that! So basically whatever level I'm clicked on (server, instance, group) that is the level that the setting will apply to. Got it!
Thanks!
Is there any estimated release date for SQLMonitor v2.2? / comments
Oh! I didn't even realize that! So basically whatever level I'm clicked on (server, instance, group) that is the level that the setting will apply to. Got it!
Thanks!
Is there any estimated relea...
RBA,
We are very pleased with the product but we are also seeing that this CPU issue is very bad. Are there some steps we can take to troubleshoot or at least provide your team with the necessary information to investigate some of this?
I ran the ANTS profiler on the environment that's monitoring our dev servers and saw (what i thought was a lot) of exceptions being thrown.
Our other environment was pegged at 99% CPU almost constantly after running for about a week and then when I tried to stop the base monitor process it crashed.
I think if we're going to move forward on this product we'd need to know that this CPU issue was being seriously looked at and there are some hard steps being taken to resolve some of it.
Let me know what information I can provide you to start investigating these issues.
Thanks! / comments
RBA,
We are very pleased with the product but we are also seeing that this CPU issue is very bad. Are there some steps we can take to troubleshoot or at least provide your team with the necessary ...
RBA,
Right now we're just testing so we have 6 servers on one test environment with about 50-120 databases which would be similar to production (except in production we'll have about 20 servers) and we have another test environment with about 10 servers and about 10-25 databases per server which is more similar to our dev environment.
The databases are all fairly small (< 8 GB) but they have a large number of objects in them (procedures, tables, etc...).
So I think once we purchase we're looking to get about 30 servers monitored.
The trace I sent you was for the smaller environment that mimics our testing environment but i'm seeing similar CPU usage on both. / comments
RBA,
Right now we're just testing so we have 6 servers on one test environment with about 50-120 databases which would be similar to production (except in production we'll have about 20 servers) an...
Here's a sendspace link to a saved, short ANTS profiler trace of the base monitor service on my local machine. I also included the html output. http://www.sendspace.com/file/s0o579 / comments
Here's a sendspace link to a saved, short ANTS profiler trace of the base monitor service on my local machine. I also included the html output.http://www.sendspace.com/file/s0o579