| Subject | Newbies queries on type of data files and recovery options |
|---|---|
| Author | Rohit Coder |
| Post date | 2011-09-28T13:58:51Z |
Hi,
I am a SQL Server and MySQL developer. I am aware of Firebird but never got opportunity to work with it. I want to use Firebird in one of my upcoming project replacing MySQL. While reading the documentation of Firebird, I learned that it supports single as well as multiple database files option. I have few queries in this regard:
1. Which is the recommended data file structure: `Single file` or `Multiple files`?
2. What is the table and data file max-size for version 2.5?
3. What are the common scenarios of a Firebird data file getting corrupt? In case of a single-file structure, I guess no other files need to be backed up?
Regards,
Rohit.
[Non-text portions of this message have been removed]
I am a SQL Server and MySQL developer. I am aware of Firebird but never got opportunity to work with it. I want to use Firebird in one of my upcoming project replacing MySQL. While reading the documentation of Firebird, I learned that it supports single as well as multiple database files option. I have few queries in this regard:
1. Which is the recommended data file structure: `Single file` or `Multiple files`?
2. What is the table and data file max-size for version 2.5?
3. What are the common scenarios of a Firebird data file getting corrupt? In case of a single-file structure, I guess no other files need to be backed up?
Regards,
Rohit.
[Non-text portions of this message have been removed]