Thanks for your point Peter,
All these do make sence, and of course they have to.
Maybe I wasn't quite clear in my question. Let me explain.
Networker gives you an option of restoring the batadase in "Read-Only" mode,
so that "logs can be applied later".
My question was how and from where? (tape backups, SQL Server itself
maybe?).
Let's say we restore the full backup and the first trancastion log from
Networker SQL User. Action is a normal restore but with the option to put
the batabase in read only mode, so we can open it up and check if the data
we want is there. If not, we're probably in need of applying some more logs.
Is this possible?
On our initial tests when going about the second restore, and selecting a
more recent incremental (log) backup, the full backup was aplied again with
all the subsequent logs until the point I specified.
I wouldn't mind this behaviour, since that does sound as a proper behaviour,
but our SQL server guy showed me how this could be done from SQL Server's
Entrprise Manager.
I understand that the Networker's SQL Module (or any database module in that
sence) is not an RDBMS, but I was just wondering if it provides some kind of
functionality to cover some situation as I described above.
(or maybe I confused concepts and the procedure wrong :-o)
Thanks again for your feedback,
Panos
-----Original Message-----
From: Peter Ondruska
To: Legato NetWorker discussion; Tsiamis, Panagiotis
Sent: 2/9/2002 7:54 ??
Subject: Re: [Networker] SQL Module question
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.
=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=
|
