Comments
Sort by recent activity
I too am running 4.3.0.132. I am interested in upgrading to version 5, but it seems that there may be an issue going from v4.3 to v5 with the upgrader. Support, please post a fix for this, or correct the upgrader so that it works. / comments
I too am running 4.3.0.132. I am interested in upgrading to version 5, but it seems that there may be an issue going from v4.3 to v5 with the upgrader. Support, please post a fix for this, or cor...
Yes, installing the pre-release of 4.3 has fixed the problem. Thanks. / comments
Yes, installing the pre-release of 4.3 has fixed the problem. Thanks.
Thanks for the reply.
I'm sure you have heard this suggestion before, but if you are considering improvements for the GUI, I would recommend that it be configured to interact with a Central SQL Server database instead.
Then there would be no need for it to sync up locally. It would just query from the central database on an as needed basis. That would also have the added benefit of not requiring every GUI user to register new servers whenever new ones are added. / comments
Thanks for the reply.
I'm sure you have heard this suggestion before, but if you are considering improvements for the GUI, I would recommend that it be configured to interact with a Central SQL Ser...
Yes,
Sorting by first and last lsn or by filename would resolve the issue. Until then, I will need to continue to run the manual work around when this becomes an issue. Fortunately it doesn't happen too often.
Two things need to occur for this to happen:
1. Multiple files need to get bunched up together between restores.
2. At least one of the files doesn't have any transactional activity in it, causing the First and Last LSNs to match.
I suppose I could create a job that writes a dummy transaction in the databases between transaction log backups to prevent scenario 2 from occurring, but hopefully this will get fixed soon.
Thanks. / comments
Yes,
Sorting by first and last lsn or by filename would resolve the issue. Until then, I will need to continue to run the manual work around when this becomes an issue. Fortunately it doesn't hap...
The log files of the backups don't seem very helpful. The LSN information is in the sample I posted. Most of the time when there are multiple files in a * wildcard restore. they are indeed restored in the correct order. But sometimes they are not. That makes me wonder how the order to restore them in is sorted. Are they sorted by filename, modify date, create date, or something else at restore time?
I would hope filename, but if that is the case, then I can't explain why sometimes they are restored in the wrong order. Perhaps they are sorted by the date created. If that is the case, I could imagine how the sequence could get messed up if a the copy order is out of sequence.
Does version 5.4 resolve the issue? / comments
The log files of the backups don't seem very helpful. The LSN information is in the sample I posted. Most of the time when there are multiple files in a * wildcard restore. they are indeed restor...
I had the same problem and am using 5.3.0.178. The problem started when the restore job got hung up. After restarting the SQL Agent I started getting the out of sequence problem with multiple log files in the same source folder. The only way I was able to resolve it was by taking the sql agent restore command into a query window and by changing the filename_*.sqb values to match the correct next file name that needed to be restored. Doing that a few times resolved the issue, but it was tedious.
Clearly this bug isn't completely fixed. / comments
I had the same problem and am using 5.3.0.178. The problem started when the restore job got hung up. After restarting the SQL Agent I started getting the out of sequence problem with multiple log...
I did manage to work around the issue by using reg add command in a batch file to chage values after the install in my installation script. But I am of the opinion that any parameter that can be changed in the installation GUI should be available to change using an unattended install.
If a complete list of all available flags could be provided, I may find that useful for other scripting options.
Thanks. / comments
I did manage to work around the issue by using reg add command in a batch file to chage values after the install in my installation script. But I am of the opinion that any parameter that can be c...
Are there any other flags for SqbServerSetup.exe beyond what is shown in the article? In particular, I'm looking for a flag to specify a different non-default installation directory and a different non-default path for the CE database. / comments
Are there any other flags for SqbServerSetup.exe beyond what is shown in the article? In particular, I'm looking for a flag to specify a different non-default installation directory and a differen...