Re: [Networker] Problem restoring SQL Database...

I mean instead of restoring the entire database, is it possible to restore
individual files(.mdf or .ldf) in the database??


----- Original Message ----- 
From: "Athanasios Douitsis" <aduitsis AT NOC.NTUA DOT GR>
To: <NETWORKER AT LISTSERV.TEMPLE DOT EDU>
Sent: Friday, January 13, 2006 2:39 PM
Subject: Re: [Networker] Problem restoring SQL Database...


> On Fri, Jan 13, 2006 at 09:19:50AM +0530, Srinivas Rao wrote:
>
> > 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?
>
> Hi,
>
> As I indicated in my previous mail, a database is an abstract data
stucture, you don't
> have to take files and paths into account. So, I cannot understand what
you mean by saying
> that you want to restore an individual file in the database.
>
> Cheers,
> Athanasios
>
> >
> > 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

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