This post is more than 5 years old
1 Message
0
2965
February 27th, 2012 11:00
Restoring SQL server Database with old savesets?
Hi
We use networker 7.5sp3 on windows 2008 and the networker sql module to backup sql server 2008 databases.
My question is, is it possible to restore these databases from a specific point in time if the saveset is still recoverable(not using the last full backup?
We have tried to restore a full database saveset from november 30th 2011 using the networker for sql server but its not possible.
We can only restore the last full backup of this database. Why is that?
If we look at the save set information of the volume it shows several database savesets( like the one from november 30 2011)
still in recoverable status.
Also, using the NMssql module, the only way to restore is by having a new database to dump the data in it???
Is it possible to just recover the mdf, ldf files to a particular directory like using the normal networker user program without needing to setup a new database?
Please someone clarify me this
Thanks
CarlosRojas
1.7K Posts
0
February 27th, 2012 23:00
Hi Okas,
In order to be able to restore any data in a certain PIT you need to have that saveset in status browsable. If that saveset is in status recoverable means that retention and browse policy have expired.
If you use NMSQL GUI to restore any DB you should not be able to browse the backup of that PIT as it is already expired.
You will need to scan that savest in back again by using scanner -i -S SSID Device_name
Example:
scanner -i -S 1234567 \\.\Tape0
That will bring back the savest into a browsable state.
After that I would suggest to run nsrck -L7 client_name to rebuild the indexes for that client.
About the restores, you should be able to restore a SQL DB anywhere, even without the requirement to create a new DB. You should be able to do a restore in an alternate location (either locally on the same SQL server or a remote SQL server with NMSQL installed on it).
I would suggest you to take a look and NMSQL documentation, restore processes are pretty well described in there.
Thank you.
Carlos.
Thierry101
2 Intern
•
326 Posts
0
February 27th, 2012 18:00
hi
is the ssid recoverable and you have selected to restore from that version but it goes to most current good full backup? have you tried from command line specifying the ssid that you wanted to recover?
not sure if you can recover mdf and ldf separately which was backed up by module unless it was dump method using bak or flat files