Networker For SQL Server (Roll Forward)

Question

I am running the newest version of Networker, Networker for SQL, and SQL Server 2005. Is there a way to restore a database from a particular day, say two days ago, then roll forward the transactions from the transaction logs (within Networker)?

I know you can browse a particular day and restore from that but I do not see an option to roll forward transaction logs.

mdfields · Answer

What is the point of the transactions logs then if you can not restore data from them? I am new to the SQL backup world so you will have to forgive me.

ble1 · Answer

To put it in another words, you will need to ask SQL admin what data is required for that and restore it. I'm not sure if latest module has any direct switch to it as I didn't work with that version.

ble1 · Answer

Is there such option within MS SQL?

ble1 · Answer

Point in time recovevry. Check rather admin guide for SQL module - around page 80 and after.

mdfields · Answer

Thank you sir! I will research PIT.

mdfields · Answer

The Networker for SQL seem pretty generic. The only option you get is to restore the entire database. Is there a way to only restore certain transaction log files within Networker? When you perform a backup within SQL Server, you get .bak and .trn files for the DB and Transaction Logs. I would assume the Networker Module does something similar, right??

ble1 · Answer

Sounds like traditionall PIT recovery to me. I believe NW will restore what it necessary and SQL will do the rest of the recovery process.

dgreggs1 · Answer

As stated you have to do a PIT restore. Make sure you have the tapes needed for the restore on site. You need the last full backup taken prior to whatever PIT TLog you want to restore to. NetWorker will restore the Full and apply the TLog changes up to the PIT point.

Have the needed tapes loaded and inventoried so NetWorker will know they are available and will load and unload as needed.

NetWorker

Networker For SQL Server (Roll Forward)

Was this post helpful?