Comments
Sort by recent activity
Brian Donahue wrote:
Hi Todd,
If SQL Backup had been previously installed and the trial period expired, then you can request a trial licence key from sales@red-gate.com. Again, this will give you a 14-day trial.
Please let us know if you need anything further.
Well there-in lies the problem. It's a pain to have to keep asking for a trial license [image]
Would be nice to have some kind of license that would basically cripple the software for production use, but allow it to be used on a development server. Maybe limit the backed up DB's to only 2 or something like that. Don't allow it to restore a DB older than 4 hours even. Something like that should make it useless for production but perfect for testing ?? / comments
Brian Donahue wrote:
Hi Todd,
If SQL Backup had been previously installed and the trial period expired, then you can request a trial licence key from sales@red-gate.com. Again, this will give yo...
Yes - I think I might be able to come up with a solution like that. I can code VB6 so I could write a program that would build the list I could check-off and the run the same script over and and over against each DB.
After looking over the Toolkit more it looks like this other solution would work better for me given the .NET requirement. / comments
Yes - I think I might be able to come up with a solution like that. I can code VB6 so I could write a program that would build the list I could check-off and the run the same script over and and o...
Well I looked at the packager as the website says it's for this scenerio but it doesn't look like it really fits my needs. I noticed that the Toolkit only uses .NET languages, that's a bummer - I would have to use the commandline on that I guess. / comments
Well I looked at the packager as the website says it's for this scenerio but it doesn't look like it really fits my needs. I noticed that the Toolkit only uses .NET languages, that's a bummer - I...
I like to quickly pull that list up and look over all my DB's to see how well they are compressing, and that they are getting backed up. Since I know the first and last ones I can easily find the begin and endpoint in the list, however since you limit the rows returned it does not show all mine.
If you allow it to be set as an Option, I could actually set it to exactly the number of DB's that I am backing up and I will get a full list everytime without old one being in there. Then have a paging option to show the next set, that would be pretty cool.
Reporting probably could do it also, but then you would have to run a report etc... I like the speed of being able to just click on the Tab and review the last results. Adds value for me. / comments
I like to quickly pull that list up and look over all my DB's to see how well they are compressing, and that they are getting backed up. Since I know the first and last ones I can easily find the ...
The job finally completed - it took it about 2 hours and 30 minutes to finish after it finished the regular backups. That's a long time to delete some log files! / comments
The job finally completed - it took it about 2 hours and 30 minutes to finish after it finished the regular backups. That's a long time to delete some log files!
From what I remember in the older stuff. If you use multiple threads, it only works for database backups that are in more than one file. Will it actually run multiple DBs at the same time? If so, it doesn't seem that the TSQL code would run right anyway?
Do you have some sample T-SQL code to get this done? / comments
From what I remember in the older stuff. If you use multiple threads, it only works for database backups that are in more than one file. Will it actually run multiple DBs at the same time? If so...
Yes I agree, however the listview displays very quickly with the data in the grid. The + on the tree takes forever to come up. / comments
Yes I agree, however the listview displays very quickly with the data in the grid. The + on the tree takes forever to come up.
It was faster but still takes a good while to load. Why not load the tree with database objects only and go retreive all that other data when you actually click on a database? / comments
It was faster but still takes a good while to load. Why not load the tree with database objects only and go retreive all that other data when you actually click on a database?
I have loaded the patch and it does fix the stored proc. The command line interface still fails however.
Also - when using the GUI it deadlocked on the MSDB table and failed to delete some backup history. I looked at the deadlocks and noticed that SQL Backup was deadlocked against itself. Seems this version is still pretty unstable - when are the fixes going into release?
One other note, when running the GUI it initially took a very long time for it to load. Most likely due to the fact that I had a very long history of backups. Don't forget I'm backing up over 300 databases every night! / comments
I have loaded the patch and it does fix the stored proc. The command line interface still fails however.
Also - when using the GUI it deadlocked on the MSDB table and failed to delete some backup ...
Here is what I think happened. The GUI crashed after I tried to close it (I've sent you guys bug reports on that). That left some jobs running on SQL Server. When I ran the second job it deadlocked with the old job.
Also - on loading the tree at the left. It takes about 5 minutes to load the tree remotely with 353 databases in the tree. I have other products that do the same in about 2 seconds. You might want to find a faster way to retreive the list of databases. / comments
Here is what I think happened. The GUI crashed after I tried to close it (I've sent you guys bug reports on that). That left some jobs running on SQL Server. When I ran the second job it deadloc...