Subject | Problem with "alter database begin backup" |
---|---|
Author | kimon_the_athenian2 |
Post date | 2008-03-06T15:52:55Z |
I want to backup my database so that some data is omitted from the
backup. I'm trying to do it like this:
1. issue "alter database begin backup"
2. copy database file to temp file
3. issue "alter database end backup" on original database
4. delete unwanted data in temp database
5. backup temp database
I get error on step 5:
is my temp database file
I read from FB 2.0.3 relnotes about nbackup responsibilities :
How to do this by hand?
(i'd like to avoid shipping nbackup.exe)
best greetings,
Aivar
backup. I'm trying to do it like this:
1. issue "alter database begin backup"
2. copy database file to temp file
3. issue "alter database end backup" on original database
4. delete unwanted data in temp database
5. backup temp database
I get error on step 5:
> I/O error for file"C:\_POSSU\POSSU3\TEMP\$20080306174036359$.TMP" (NB withoud ".delta")
> "C:\_POSSU\POSSU3\TEMP\$20080306174036359$.TMP.delta"
> Error while trying to open file
> The system cannot find the file specified.
> internal gds software consistency check
> (Error: can't actualize backup state)
is my temp database file
I read from FB 2.0.3 relnotes about nbackup responsibilities :
> 2. to fix up the database after filesystem copyCan it be my problem that i didn't make this change?
> (physically change nbak_state_diff to
> nbak_state_normal in the database header)
How to do this by hand?
(i'd like to avoid shipping nbackup.exe)
best greetings,
Aivar