Comments
Sort by recent activity
Just checking. I sent the info to Support under F0066394 just now after replying earlier under Waiting on API message when running a 7.1.0.214 Backup.
HTH
Chris / comments
Just checking. I sent the info to Support under F0066394 just now after replying earlier under Waiting on API message when running a 7.1.0.214 Backup.
HTH
Chris
So as not to leave this thread without answers I was told that OLR has some limitations and I was able to use SSIS to export the data once I had created a database from the backup.
This is no longer an issue for me.
Chris / comments
So as not to leave this thread without answers I was told that OLR has some limitations and I was able to use SSIS to export the data once I had created a database from the backup.
This is no longe...
Looks like I am running 1.2.0.32 of Object Level Recovery Pro.
Chris / comments
Looks like I am running 1.2.0.32 of Object Level Recovery Pro.
Chris
This happened again today on a test server. I checked the regkey I mentioned and could see the serial number present before I registered again.
I am now more curious as to what makes SQLBackup think it is running a Trial.
Chris / comments
This happened again today on a test server. I checked the regkey I mentioned and could see the serial number present before I registered again.
I am now more curious as to what makes SQLBackup thin...
Thanks to Steve I will use a different method to activate after a version upgrade and I also know if a server, standalone or clustered, has a license file.
For W2K3 look in "%ALLUSERSPROFILE%\Application Data\Red Gate\Licenses\" for a v9_0.lic file where v9 is the version. In my case it would be v7_0.lic. The ALLUSERSPROFILE turns out to be C:\Documents and settings\All Users
For W2K8 look in C:\Program Data\Red Gate\Licenses for the v7_0.lic file. The Program data folder is hidden by default.
My new activation method will be by using the GUI Tools/Utilities/Product Activation and use this on both nodes.
Chris / comments
Thanks to Steve I will use a different method to activate after a version upgrade and I also know if a server, standalone or clustered, has a license file.
For W2K3 look in "%ALLUSERSPROFILE%\Appli...
Thanks again Brian. It has always been a little difficult with the 7 hours between where I am (Western Canada) and Cambridge (I was born in Essex close by). You have usually had an answer either the following day or pretty soon after so the current delays are noticable, at least to me.
I wait to get a response early next week.
Chris / comments
Thanks again Brian. It has always been a little difficult with the 7 hours between where I am (Western Canada) and Cambridge (I was born in Essex close by). You have usually had an answer either th...
Thanks Brian.
Will my question raised on Tuesday be answered soon?
Chris / comments
Thanks Brian.
Will my question raised on Tuesday be answered soon?
Chris
Not sure if this makes any difference but the OLD job started at 8.00pm and the NEW one starts at 10.00pm. Could network and server workload be different at 10pm than 8pm?
Just a thought.
Chris / comments
Not sure if this makes any difference but the OLD job started at 8.00pm and the NEW one starts at 10.00pm. Could network and server workload be different at 10pm than 8pm?
Just a thought.
Chris
When we restore a database we force the users off with alter database set single user with rollback immed and on SQL2005 there would be problems with orphaned DTC spids so this would go on for ever. This got fixed by later builds of SQL2005. If by chance you have a long running transaction on a database that has multiple CPU's that rollback is single threaded. So if you try and force a transaction that has run for 5 minutes using 8 CPU's it could take 40 minutes to rollback.
Chris / comments
When we restore a database we force the users off with alter database set single user with rollback immed and on SQL2005 there would be problems with orphaned DTC spids so this would go on for ever...
Thanks Pete.
I was running jobs that looked at the VAS but this was not the problem. Now I have added the sqbmemory check as well and look for situations where the memory goes low.
This is happening every day but at random times so I am unsure what is causing the problems.
Chris / comments
Thanks Pete.
I was running jobs that looked at the VAS but this was not the problem. Now I have added the sqbmemory check as well and look for situations where the memory goes low.
This is happenin...