At 07:52 AM 30/07/2004 +0100, you wrote:

>Alan McDonald wrote:
>
> > I thought you were saying that the db HAS data but the backup restored does
> > NOT.. ?
>
>The database SIZE is 79Mb, but only the metatdata is visible when
>opening it. In theory the only way that people on site could blank it
>should be backup metatdata only - but that would wipe the size when the
>blank restore happened - creating a blank database.
>
>We are currently looking to what else is on the few machines connected
>to the network. ( Should have had LogManager running here ;) )

Have you had a look at a copy of the restored database on a machine that's
out of the network? Maybe someone trashed isc4.gdb and/or deleted the
sysdba and/or user privileges in rdb$user_privileges...

/heLen