Dear Athanasios / James,
Thanks again for your reply.
Since I could not restore the previous version of the database from the tape
to the original location from where it has backedup since the database was
in operational state, I had to restore it to the restore it to the different
path of the same client. But after restoring I found the original database
was got deleted and the restored database came to an operational state.
According to Networker SQL documentation:
If you restore the database in a Normal restore method, you cannot change
the name of the database to be recovered and hence it will get restored in
the original name and the database would be in an operational state.
However the partial restore can rename the database to be recovered hence
the original database will not get affected.
Can you please let me know how to restore an individual file in the
database?
Thanks in Advance,
Srinivas Rao,
Networker Administrator,
Philips Software Centre,
Bangalore, INDIA.
Ph: +91 94482 92416
----- Original Message -----
From: "Rohrich, James" <James.Rohrich AT UOP DOT COM>
To: <NETWORKER AT LISTSERV.TEMPLE DOT EDU>
Sent: Thursday, January 12, 2006 6:45 PM
Subject: Re: [Networker] Problem restoring SQL Database...
Depending upon the version you have, some of the newer versions have a copy
option which allows you to restore a copy of a specific db while leaving the
other in place.
________________________________
From: Legato NetWorker discussion on behalf of Athanasios Douitsis
Sent: Thu 1/12/2006 6:57 AM
To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
Subject: Re: [Networker] Problem restoring SQL Database...
On Thu, Jan 12, 2006 at 06:14:51PM +0530, Srinivas Rao wrote:
> Dear Athanasios,
> Thanks for your reply. My database is working fine but the user wanted
some
> info. from old backup of the same database and hence I had to restore from
> tape backup however the restoration failed due to "database is in use"
> error.
>
> One more query:
> If I restore the database which is existing and operational on the
Networker
> client by using Normal restoration method and relocate it to the different
> path of the same client with the same database name, will it
> delete/overwrite the existing database??
Well, since I don't have any significant experience with that particular
module, I cannot speculate
what would it do. However we are not talking about files here, we are
talking about db data, am I
correct? What would be the purpose of specifying the path?
Cheers,
Athanasios
>
> Thanks in Advance,
> Srinivas Rao,
> Networker Administrator,
> Philips Software Centre,
> Bangalore, INDIA.
> Ph: +91 94482 92416
>
> ----- Original Message -----
> From: "Athanasios Douitsis" <aduitsis AT noc.ntua DOT gr>
> To: "Srinivas Rao" <rsrini AT blr.pin.philips DOT com>
> Cc: <NETWORKER AT LISTSERV.TEMPLE DOT EDU>
> Sent: Thursday, January 12, 2006 5:44 PM
> Subject: Re: [Networker] Problem restoring SQL Database...
>
>
> > On Thu, Jan 12, 2006 at 01:26:11PM +0530, Srinivas Rao wrote:
> >
> > > Hi,
> > > When I try to restore any SQL database from a Networker client running
> with NM-SQL3.1, it is getting failed due to below error:
> > >
> > > [Microsoft][ODBC SQL Server Driver][SQL Server]Exclusive access could
> not be obtained because the database is in use..
> > > [5988] [Microsoft][ODBC SQL Server Driver][SQL Server]RESTORE DATABASE
> is terminating abnormally..
> > >
> > > This be because of somebody is accessing the database I am trying to
> restore.
> > >
> > > But my questions are:
> > > 1. Why the database cannot be restored if it is being accessed at the
> time or restoration?
> > > 2. What is the alternate method to restore the database if it is being
> used(since the NW client is a live production system so SQL services
cannot
> be restarted)?
> > > 3. Although we are restoring database from tape backup, why Networker
> connects to the existing database of NW client to check whether it is
being
> accessed or not?
> > >
> > > Any help would be greatly appreciated.
> >
> > Hi,
> >
> > Obviously because the database may be inconsistent during the phase of
the
> restoration. I would speculate that the restoration process
> > discards everything and rebuilds it from a specific stored checkpoint
> which was made in the past. During the restoration phase, information
> > may be partialy present and that could lead to very peculiar situations.
> About question no 3, any program that uses the database for any
> > purpose needs to do it via the standard way, e.g. connect to the
database
> :-).
> > Lastly, about question 2, I would suggest that you restore the database
> somewhere else and then do things by hand. This will be tiresome though.
> >
> > Cheers,
> > Athanasios
> >
> >
> >
> > >
> > > Thanks in Advance,
> > > Srinivas Rao,
> > > Networker Administrator,
> > > Philips Software Centre,
> > > Bangalore, INDIA.
> > > Ph: +91 94482 92416
> > >
> > >
> > >
> > >
> > > To sign off this list, send email to 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
> if you have any problems
> > > wit 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 and
type
"signoff networker" in the
body of the email. Please write to networker-request AT listserv.temple DOT edu
if
you have any problems
wit 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 and
type
"signoff networker" in the
body of the email. Please write to networker-request AT listserv.temple DOT edu
if
you have any problems
wit 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 and
type "signoff networker" in the
body of the email. Please write to networker-request AT listserv.temple DOT edu
if you have any problems
wit 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
|
