Unsolved
This post is more than 5 years old
64 Posts
0
573
February 8th, 2010 14:00
Re-built indexes not allowing restore of SQL database
I am trying to restore a SQL 2000 database to a Windows 2008 64bit server using SQL module version 5.2.1.299. Since the tape the database is on was past its retention period, I used the scanner command and rebuilt the index. I can see them under indexes for that database but when I access the SQL module on that server, I cannot browse to that date (Dec. 31, 2009) It will only see the indexes from the last two weeks, my retention period.
Also when this backup occurred it was on a different server (Windows 2003 with SQL 2000 using the SQL module 4.1) with the same name. Our applications team upgraded the 2000 database to SQL 2008 in January and moved it to a Windows 2008 64bit server running SQL 2008. We renamed the old server and gave the 2008 server the old name of the 2000 one. Not sure if this may be causing the issue.
I've done this in the past with the same database and it worked.
Using Networker 7.5.1
mhaupt2
64 Posts
0
February 9th, 2010 14:00
Update:
I did further testing today trying by rebuilding an index for a small SQL database from a server that was not upgraded. The index was recreated. I can see it in the indexes under Media. But when I open the SQL module on the client and try to browse to Dec 30th, 2009 it doesn't work. It will only allow me to browse back two weeks, my retention period.
Any help is appreciated.
coganb
736 Posts
0
February 10th, 2010 01:00
You should check the media database to see what's in there for this saveset you want to restore. It'll give you a clearer picture of what's going on.
mminfo -q ssid= -r ssid,name,volume,ssbrowse,ssretent,clretent
Also, check out the Knowledgebase article esg98649 How to Browse Recovery after saveset has passed browse period in NetWorker 7.3/7.4/7.5 to make sure that you are doing what you should with this.
-Bobby