Networker

Re: [Networker] NMSQL problem

2011-12-07 04:57:07
Subject: Re: [Networker] NMSQL problem
From: Eivind Antonsen <ean AT EXELLO DOT NO>
To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
Date: Wed, 7 Dec 2011 09:54:57 +0000
Hi

I deleted one of the savesets in mention and it did indeed disappear from 
available backups in the restore list.
So it would seem this is the Metadata.

Regards
Eivind

From: akshay bhumkar [mailto:akshay.bhumkar AT gmail DOT com]
Sent: 2. desember 2011 13:44
To: Eivind Antonsen
Cc: EMC NetWorker discussion
Subject: Re: [Networker] NMSQL problem

ok now, if you want to test then delete this incremental saveset and try to 
browse the SQL db for restore.

NOTE: take a copy of res and mm before you delete this saveset or else you need 
to scan this saveset back to repopulate in media database.

Thanks & Regards

Akshay Bhumkar
+91-9342420444
@k$h@y


On Fri, Dec 2, 2011 at 6:08 PM, Eivind Antonsen <ean AT exello DOT 
no<mailto:ean AT exello DOT no>> wrote:
Hi

The incremental saveset show up in the list

MSSQL:                         1457011164 02.01.2012 02.01.2012 incr BTK301L3   
cb      <--
MSSQL:                         4242051320<tel:4242051320> 02.12.2012 02.12.2012 
full LB0072L3   cb
MSSQL:                         3956838669 02.12.2012 02.12.2012 full LB0072L3   
cb
MSSQL:                         3688403279 02.12.2012 02.12.2012 full LB0072L3   
cb
MSSQL:                         3671626067 02.12.2012 02.12.2012 full LB0072L3   
cb
MSSQL:                         3570962811 02.12.2012 02.12.2012 full LB0072L3   
cb
MSSQL:                         3487076764 02.12.2012 02.12.2012 full LB0072L3   
cb
MSSQL:                         3436745160<tel:3436745160> 02.12.2012 02.12.2012 
full LB0072L3   cb
MSSQL:                         3386413557 02.12.2012 02.12.2012 full LB0072L3   
cb
MSSQL:                         3369636345<tel:3369636345> 02.12.2012 02.12.2012 
full LB0072L3   cb
MSSQL:                         3352859133 02.12.2012 02.12.2012 full LB0072L3   
cb
MSSQL:                         3336081923 02.12.2012 02.12.2012 full LB0072L3   
cb

Regards
Eivind

From: akshay bhumkar [mailto:akshay.bhumkar AT gmail DOT 
com<mailto:akshay.bhumkar AT gmail DOT com>]
Sent: 2. desember 2011 13:27
To: EMC NetWorker discussion; Eivind Antonsen

Subject: Re: [Networker] NMSQL problem

Please run the following command and let me know the result. I think that 
incremental saveset is the metadata which holds the information for the main 
saveset, so that data can be browsable while you perform recovery from NMSQL 
GUI from the client. If this incr MSSQL: saveset isn't present, you will not be 
able to browse the savesets.

mminfo -aq "client=<clientname>,savetime>12/01/2011" -r 
name,ssid,ssbrowse,ssretent,level,volume,sumflags

Thanks & Regards

Akshay Bhumkar
+91-9342420444<tel:%2B91-9342420444>
@k$h@y

On Fri, Dec 2, 2011 at 5:51 PM, Eivind Antonsen <ean AT exello DOT 
no<mailto:ean AT exello DOT no>> wrote:
Hi

Deleted group and clients
Created new group and clients

On 7 clients the incr saveset now goes to the Offiste pool
On 1 client the incr saveset still goes to the Default pool

And, the incr savesets are still not visible in group summary, but is present 
on media and visible during backup in the sessions window.

The incr saveset is MSSQL: and size is about 600 Bytes

Regards
Eivind

-----Original Message-----
From: EMC NetWorker discussion [mailto:NETWORKER AT LISTSERV.TEMPLE DOT 
EDU<mailto:NETWORKER AT LISTSERV.TEMPLE DOT EDU>] On Behalf Of Eivind Antonsen
Sent: 2. desember 2011 13:12
To: NETWORKER AT LISTSERV.TEMPLE DOT EDU<mailto:NETWORKER AT LISTSERV.TEMPLE 
DOT EDU>
Subject: Re: [Networker] NMSQL problem

Hi

On the default media the incr saveset is MSSQL:
Not index:

Regards
Eivind


-----Original Message-----
From: EMC NetWorker discussion [mailto:NETWORKER AT LISTSERV.TEMPLE DOT 
EDU<mailto:NETWORKER AT LISTSERV.TEMPLE DOT EDU>] On Behalf Of akshay bhumkar
Sent: 2. desember 2011 12:45
To: NETWORKER AT LISTSERV.TEMPLE DOT EDU<mailto:NETWORKER AT LISTSERV.TEMPLE 
DOT EDU>
Subject: Re: [Networker] NMSQL problem

Ken should be right. However, I am interested to know what is the saveset 
showing for incremental backup?

Sent from my Galaxy S...
On Dec 2, 2011 5:12 PM, "Kenneth Larsen" <kel AT steria DOT dk<mailto:kel AT 
steria DOT dk>> wrote:

> Sounds like index saves actually, runnning to the deafult pool
>
> to prevent that behaviour, add a backup server instans to the group,
> and backup only 1 file. should do the trick..If I am right that is...
> :)
>
> Cheers,
>
> **************************************************
> Med venlig hilsen / Regards
> Kenneth Larsen
> System Konsulent
>
> Steria A/S
> Tonsbakken 16-18
> 2740 Skovlunde
> Mobile: +45 2630 6261<tel:%2B45%202630%206261>
> email: kel AT steria DOT dk<mailto:kel AT steria DOT dk>
> www.steria.dk<http://www.steria.dk>
> **************************************************
>
>
>
> From:   akshay bhumkar <akshay.bhumkar AT GMAIL DOT COM<mailto:akshay.bhumkar 
> AT GMAIL DOT COM>>
> To:     NETWORKER AT LISTSERV.TEMPLE DOT EDU<mailto:NETWORKER AT 
> LISTSERV.TEMPLE DOT EDU>,
> Date:   02-12-2011 12:27
> Subject:        Re: [Networker] NMSQL problem
> Sent by:        EMC NetWorker discussion <NETWORKER AT LISTSERV.TEMPLE DOT 
> EDU<mailto:NETWORKER AT LISTSERV.TEMPLE DOT EDU>>
>
>
>
> Ok then, delete all the instances of one client and create it again
> and test the backup.
>
> Sent from my Galaxy S...
> On Dec 2, 2011 4:51 PM, "Eivind Antonsen" <ean AT exello DOT no<mailto:ean AT 
> exello DOT no>> wrote:
>
> >  Hi****
> >
> > ** **
> >
> > Already done that, same result****
> >
> > ** **
> >
> > Thanks****
> >
> > Eivind ****
> >
> > ** **
> >
> > *From:* akshay bhumkar [mailto:akshay.bhumkar AT gmail DOT 
> > com<mailto:akshay.bhumkar AT gmail DOT com>]
> > *Sent:* 2. desember 2011 12:21
> > *To:* Eivind Antonsen; EMC NetWorker discussion
> > *Subject:* Re: [Networker] NMSQL problem****
> >
> > ** **
> >
> > For testing try the backup of one client in a new group "test" and
> > check the behaviour. ****
> >
> > Sent from my Galaxy S...****
> >
> > On Dec 2, 2011 3:16 PM, "Eivind Antonsen" <ean AT exello DOT no<mailto:ean 
> > AT exello DOT no>> wrote:****
> >
> > Hi all
> >
> > Experiencing strange behavior with NMSQL.
> >
> > Server: 7.6.2.681
> > Clients: 7.6.2.681
> > NMSQL: 5.2.2
> >
> > Group: DBOffiste
> > Clients: 8
> > Pool: Offsite
> >
> > Clients in the group have been configured with schedule DBOffsite
> > (Full
> on
> > Thu, skip rest of week)
> > Browse/retention: year/year
> > The group is selected on the pool resource.
> > Clients are only member of one group.
> >
> > The group starts as scheduled, and writes Full backups to the
> > Offsite
> pool.
> > But, for each client it also writes a small incremental backup to
> > the Default pool, with year/year browse/ret.
> >
> > As the backup run I follow it in the sessions window in monitoring.
> > The incremental is listed as belonging to the DBOffsite group in
> sessions
> > window, but when I open the group results only Full backups are listed.
> >
> > Any ideas ?
> >
> > Thanks
> > Eivind
> >
> > To sign off this list, send email to listserv AT listserv.temple DOT 
> > edu<mailto:listserv AT listserv.temple DOT edu>
> > and type "signoff networker" in the body of the email. Please write
> > to networker-request AT listserv.temple DOT edu<mailto:networker-request AT 
> > listserv.temple DOT edu> if you have any problems
> > with this list. You can access the archives at
> > http://listserv.temple.edu/archives/networker.html or via RSS at
> > http://listserv.temple.edu/cgi-bin/wa?RSS&L=NETWORKER****
> >
>
> To sign off this list, send email to listserv AT listserv.temple DOT 
> edu<mailto:listserv AT listserv.temple DOT edu> and
> type "signoff networker" in the body of the email. Please write to
> networker-request AT listserv.temple DOT edu<mailto:networker-request AT 
> listserv.temple DOT edu> if you have any problems with
> this list. You can access the archives at
> http://listserv.temple.edu/archives/networker.html or via RSS at
> http://listserv.temple.edu/cgi-bin/wa?RSS&L=NETWORKER
>
>
>
>
>
>
>
> ----------------------------------------------------------------------
> --------------
> About Steria: www.steria.com<http://www.steria.com>
>
> Steria delivers IT enabled business services which help organisations
> in the public and private sectors operate more efficiently and
> profitably. By combining in depth understanding of our clients’
> businesses with expertise in IT and business process outsourcing, we
> take on our clients’ challenges and develop innovative solutions to
> address them. Our more than 20.000 people, working across 16
> countries, support the systems, services and processes that make
> today’s world turn, touching the lives of millions around the globe each day.
> Founded in 1969, Steria has offices in Europe, India, North Africa and
> SE Asia and revenue of €1.69 billion. 20% of Steria’s capital is owned
> by its employees. Headquartered in Paris, Steria is listed on the
> Euronext Paris market.
>
> Think before you print - Steria is committed to supporting a
> sustainable world and is Certified Carbon Neutral for Flight and Fleet
> Travel
>

To sign off this list, send email to listserv AT listserv.temple DOT 
edu<mailto:listserv AT listserv.temple DOT edu> and type "signoff networker" in 
the body of the email. Please write to networker-request AT listserv.temple DOT 
edu<mailto:networker-request AT listserv.temple DOT edu> if you have any 
problems with this list. You can access the archives at 
http://listserv.temple.edu/archives/networker.html or via RSS at 
http://listserv.temple.edu/cgi-bin/wa?RSS&L=NETWORKER

To sign off this list, send email to listserv AT listserv.temple DOT 
edu<mailto:listserv AT listserv.temple DOT edu> and type "signoff networker" in 
the body of the email. Please write to networker-request AT listserv.temple DOT 
edu<mailto:networker-request AT listserv.temple DOT edu> if you have any 
problems with this list. You can access the archives at 
http://listserv.temple.edu/archives/networker.html or via RSS at 
http://listserv.temple.edu/cgi-bin/wa?RSS&L=NETWORKER

To sign off this list, send email to listserv AT listserv.temple DOT 
edu<mailto:listserv AT listserv.temple DOT edu> and type "signoff networker" in 
the body of the email. Please write to networker-request AT listserv.temple DOT 
edu<mailto:networker-request AT listserv.temple DOT edu> if you have any 
problems with this list. You can access the archives at 
http://listserv.temple.edu/archives/networker.html or
via RSS at http://listserv.temple.edu/cgi-bin/wa?RSS&L=NETWORKER


<Prev in Thread] Current Thread [Next in Thread>