Hello,
i am currently testing to migrate FB2.5 databases into FB3 databases. Cant tell how many hours i recoded SP, triggers and and and... but database is working for me now.
Then i came to the point to backup the FB3 databases on a running system. Yes, i read the manuals and release notes and searched google. Unfortunately that didnt help. People refer to release notes and quick start quide or telling that something has changed for security reasons. Fact is database file is locked if any user is connected nowadays so i cant do my backups as before. I can understand that new feature. Company i work for is a 24/7 business. So i have to plan backups on a running system. I cant tell them to stop working for even 1.5 hours because backup is running.
In the past i used nbackup but i had issues with deadlocks and missing transactions. So i used gbak for last two years. Worked perfect for me. I tried different commands, settings and configurations for example service manager, IP, localhost, ports, password, transportable thrusted auth, SharedDatabase, adding users, dbadmi, new virtual machines and other Windows OS. Nothing worked for me as long as one user stays connected.
I also tried using a gbak 2.5 version with a FB3 database. That backup started after i tried to use default sysdba password even if i changed password before.
Operating system is Windows Server 2012 R2. Firebird 3.0.0.32483 SuperServer. Backup routine, database file and backup file should be located on the same machine for the moment.
"C:\Program Files\Firebird\Firebird_3_0\gbak.exe" -b -v -t -se service_mgr employee e:\xxx.bak -user SYSDBA
works if no one is connected else i always get error "file is used by another process".
Hopefully i will find some answers, suggestions or advices.
Regards and thanks
Thomas
__._,_.___
Posted by: dondondonjesus@yahoo.com
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu there.
Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu there.
Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
.
__,_._,___
No comments:
Post a Comment