Networker

[Networker] Problem restoring SQL Database...

2006-01-12 03:05:19
Subject: [Networker] Problem restoring SQL Database...
From: Srinivas Rao <rsrini AT BLR.PIN.PHILIPS DOT COM>
To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
Date: Thu, 12 Jan 2006 13:26:11 +0530
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