[firebird-support] Re: nbackup strategy advice
Hello Paul. Thanks for your advice. My strategy was based on backup data once approach but this would produce to many files I now realize. But I still want to avoid to backup the entire database (N=0) on regular basis. Whats your opinion about this approach? First backup N=0 Every day N=1 for a month (replace file each time) Increment N next month. This would produce 12 files every year. Thanks, Hugo
[firebird-support] Re: nbackup strategy advice
Hello Kjell, Thanks for your time analyzing and explaining my backup strategy and proposing yours. You wrote that my strategy wont work. Maybe i'm missing something or I explained wrong. As I understood your strategy is based on annually full backups (N=0) and maybe you understood that my approach is the same. My intention is that after new year N is again incremented to 13 and NOT starting over again from 0. So after two years N=24 with 24 files. First file is the full backup and the other files contains one month of data. Note that I replace the daily N file with the new one. This way (with understanding of how nbackup works), I avoid to ever having to do a full backup more than once. Whats your thoughts on this? BR, Hugo
[firebird-support] Re: nbackup strategy advice
Hello Thomas, Each shop, for example a restaurant has its own local database on the computer the Point Of Sale software is running on. The shops has ADSL connection with 1MBit upload speed and the database is around 50 MB and growing every day. Uploading such file to our server with this bandwidth disturbs other Internet activities and at night they turn of the system. So im trying to figure out an optimal backup solution. Thanks,
[firebird-support] nbackup strategy advice
Hello, We have a POS applications with hundreds of clients and need some advice on how to backup. Each application has it's own Firebird database. Read about nbackup and thought that this could be a solution since the clients has low bandwidth. My first idea was to daily backup and begin with N=0 and count up the N each day. This would result in probably hundreds of files. Would this be an OK solution? Is it possible to restore a database with 1000 of nbackup files? This would make the restore command extremely long if each file name has to be included. Is it possible to tell nbackup to read all files in a folder? Please advice. BR, Hugo
[firebird-support] Re: server version
Hello Paul, Thanks for your answer. What I want to do is to determine server version from pure JDBC. I probably posted this question in the wrong group. Should have posted it in Firebird-Java group. BR, Hugo --- In firebird-support@yahoogroups.com, Paul Vinkenoog wrote: Hello Hugo, Is there a way to determine which version of Firebird is running before connection to a Database? From within your application, you can connect to the Services Manager and then call isc_service_query(), specifying isc_info_svc_server_version in the request buffer. This is documented in the IB6 API Guide. Many clients (e.g. FlameRobin) can also give you this information without having to connect to a database first. Or, from the OS command prompt: fbsvcmgr [hostname:]service_mgr -user -password -info_server_version This requires Firebird 2.1 or higher on the client machine. Hope this helps, Paul Vinkenoog
[firebird-support] server version
Hello, Is there a way to determine which version of Firebird is running before connection to a Database? I'm looking in org.firebirdsql.management but cant find anything fitting. Thanks, Hugo
[firebird-support] Re: result to file
Hello Norm, I will try your proposal. Thanks! --- In firebird-support@yahoogroups.com, Norman Dunbar Norman@... wrote: Morning Hugo, On 15/11/12 23:02, hugo.larson wrote: Is there any way to execute with isql query and send result to a file without any headers whatsoever? Im using FB 1.5.3 I'm not sure about 1.5 but this works on 2.5 with the employee database: SQL -- Turn headings off. SQL set heading; SQL -- Direct output to a file. SQL output myfile.txt; SQL -- Run query. SQL select * from department; SQL commit; SQL -- Redirect all further output to the screen. SQL output; SQL -- Put headings back on again. SQL set heading; Watch out though, if the output file exists, it will be appended to, not overwritten. HTH Cheers, Norm. -- Norman Dunbar Dunbar IT Consultants Ltd Registered address: Thorpe House 61 Richardshaw Lane Pudsey West Yorkshire United Kingdom LS28 7EL Company Number: 05132767
[firebird-support] result to file
Hello, Is there any way to execute with isql query and send result to a file without any headers whatsoever? Im using FB 1.5.3 Thanks,
