[Networker] Problem restoring SQL Database...
2006-01-12 03:05:19
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.
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
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- [Networker] Problem restoring SQL Database...,
Srinivas Rao <=
|
|
|