I haven't worked with MSSQL for a very long time (and asume it is very
similar to Oracle). You need to understand what your database log files are
for. They record changes made to database and therefore "restoring" log
files has no effect. If you ment restoring database to a specific point in
time (that is not until "now") you have to restore the database from last
backup and than _apply_ the logs, that is to apply changes made to the
database after the database backup. p.

----- Original Message -----
From: "Tsiamis, Panagiotis" <TsiamisP AT UNISYSTEMS DOT GR>
To: <NETWORKER AT LISTMAIL.TEMPLE DOT EDU>
Sent: Monday, September 02, 2002 6:16 PM
Subject: [Networker] SQL Module question


> Hello all,
> We have installed the SQL Server module v.3.1 on Networker v.6.1.1 on
Win2K
> platform.
> We did some tests on the Northwind batabase, i.e. full backup, change the
> db, incremental backup (log backup), change the db, incremental backup,
and
> so on.
> We proceed to the restore by restoring the full backup and one
incremental.
> Worked fine!
> When we went on to restore the rest of the log backups, Networker restored
> the full and the first incremental again, and then proceeded to the rest
of
> the logs.
>
> Is there a way to tell Networker to restore (replay?) the log backups only
> (as in SQL Server's Enterprise Manager)? Is there some option we just
missed
> or there's another way to go about it (backup/restore procedure)?
> We're going to backup a database of 150+ GB so it would rather time
> consuming to just restore them to few hours back in case they need it
> (fingers crossed... :-).
>
> Thanks in advance,
>
> Panos
>
> --
> Note: To sign off this list, send a "signoff" command via email
> to listserv AT listmail.temple DOT edu or visit the list's Web site at
> http://listmail.temple.edu/archives/networker.html where you can
> also view and post messages to the list.
> =*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=
>

--
Note: To sign off this list, send a "signoff" command via email
to listserv AT listmail.temple DOT edu or visit the list's Web site at
http://listmail.temple.edu/archives/networker.html where you can
also view and post messages to the list.
=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=