Restore

Hi,
I made a full database backup. Later I restored this
backup to a new database, but I lost a lot of records.
The first transaction log is bigger than the new one but
after the restore I lost many records.
Can anyone help me?Maybe this is what you are seeing...if I backup my main
database at 1:00 pm and then restore that backup to second
database as 5:00 pm, I won't have the transactions that
occurred between 1:00 pm and 5:00 pm. To get those other
transactions, I need to backup the log on the main database
at 5:00 pm and then apply, restore the log on the second
database.
-Sue
On Tue, 14 Oct 2003 13:05:44 -0700, "nelva"
<nelvitaweb@.mixmail.com> wrote:
>Hi,
>I made a full database backup. Later I restored this
>backup to a new database, but I lost a lot of records.
>The first transaction log is bigger than the new one but
>after the restore I lost many records.
>Can anyone help me?