Help

Start a discussion
UNSOLVED

yoshi2

updated

18 years ago

Y

yoshi2

23 Posts

0

3507

June 20th, 2008 01:00

Cannot change browse date

Hi,

I have a MSSQL saveset whose status is recoverable.

MSSQL:ABC 2467444843 full recoverable 000048L3 clientname 62G 8 Default 4/26/08 5:00:45 AM

I would like to restore this saveset but it is invisible from the client, thus I would like to change the browse time.

I executed nsrmm -S 2467444843 -w 06/30/08 but i got an error message nsrmm: Cannot exceed the browse time of a recoverable save set 2467444843. (Retention policy is forever.)

Also I tried nsrck -L7 -t "4/26/08 5:00:45 AM" clientname but nothing changed.

Since this is a MSSQL saveset I cannot restore it with restore -S ssid. Please help.

Thanks in advance.
Yoshi
  • Z

    zodiaconline

    1 Rookie

    •

    28 Posts

    770

    0

    Posted June 20th, 2008 02:00

    At the client side command line;
    enter recover menu
    then enter "changetime", enter new save time in the format dd/mm/yyyy
    add the files you want to recover with "add" command.
    use "recover" command to recover the files.
  • B

    ble1

    6 Operator

    •

    14354 Posts

    •

    56186 Points

    770

    0

    Posted June 20th, 2008 05:00

    Obviously you can't see it as it is expired from index database. Obviously changing browse policy for such saveset doesn't make sense. You executed nsrck with -t for save time (when it begin) for time on client side - I guess index entry did not exist at that time on server so I would try different time (something within original browse policy). If it fails and you are in hurry, delete it and scan it back.
  • Y

    yoshi2

    23 Posts

    770

    0

    Posted June 22nd, 2008 18:00

    Thank you for the advice.

    I performed nsrck -L7 -t "5/17/08 5:00:30 AM" clientname when index file was not yet expired then the saveset has gotten browsable. Thanks again.

    Yoshi
  • Y

    yoshi2

    23 Posts

    770

    0

    Posted June 23rd, 2008 18:00

    Although the target save set is browsable, it is not seen from client. please help.
  • Y

    yoshi2

    23 Posts

    770

    0

    Posted June 23rd, 2008 18:00

    Hi,

    Although the target saveset is browsable it is not seen from client.
    I have no idea what is wrong...

    Regards
    Hirano
  • B

    ble1

    6 Operator

    •

    14354 Posts

    •

    56186 Points

    770

    0

    Posted June 27th, 2008 03:00

    You did change browse time?
  • Y

    yoshi2

    23 Posts

    770

    0

    Posted June 30th, 2008 19:00

    Hi,

    Seems like if there is a gap between browsable save sets the isolated saveset is not seen from client. Thus I restored the data by designating nsavetime.

    Get nsaveime: mminfo -q ssid=xxxx -r name,ssbrowse,ssretent,fragflags,nsavetime
    Restore data: nsrsqlrc -s servername -c client -d MSSQL:copydbname -t nsavetime MSSQL:dbname

    Regards

Dell Support Resources

Latest Solutions

View More