• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2029
  • Last Modified:

ARCserve and Shutting Down SQL Database for WSUS

I am running ARCserve 11.5 SP3 on a Server 2003 box.  This server also is running WSUS to deploy updates to all of my clients.  I am receiving numerous errors during my nightly backup relating to SQL stating that ARCserve cannot back up the files.  One of these errors is:

W3404 Unable to open file. (FILE=C:\WINDOWS\SYSMSI\SSEE\MSSQL.2005\MSSQL\Data\master.mdf, EC=SHARING VIOLATION)

I do not have the Brightstor ARCserve SQL agent installed on this server.  I am assuming that is why ARCserve cannot back up these particular files.  

From what I can think of, there are three things that I can do to resolve this problem.

1 - Purchase and install the SQL Agent.

2 - Filter out the directory will the SQL files are stored so ARCserve excludes them from the backup.

3 - Shutdown the WSUS SQL database while the backup is taking place.

I would hate to shell out the money to purchase the SQL agent just to backup WSUS.  However, if you guys feel this is the best route to go, then I will do it.

If you feel I would be OK with simply shutting down the SQL database, how do I go about doing so?

Thanks,

Chris
0
csimmons1324
Asked:
csimmons1324
  • 3
  • 2
  • 2
1 Solution
 
lacrewgaCommented:
In task scheduler, add (set appropriate times)
To stop...
net stop mssqlserver
To start...
net start mssqlserver

I would run these commands from command prompt to see if working. After first backup with new scripts in place, check backup logs to ensure no errors in backup.
0
 
bhanukir7Commented:
Hi,

one thing you can certainly buy would be VSS license which would let you backup sql, exchange, iis this is a option license and would cost mo

If you dont want to shell out additional license then you can set filters to exclude the *.mdf and *.ldf files.

An alternate method would be create a script which would stop the mssql service and start the mssql service after the backup.

pre-job script which would a net stop mssqlserver
post-job script which would do a net start mssqlserver.

Set a delay of 2 or 3 minutes for the pre and post job scripts.

i.e the job should start after three of running the job script and 3 minutes after the backup job is complete.

bhanu

0
 
csimmons1324IT ManagerAuthor Commented:
I have created two .bat files.  One contains the line "net stop mssqlserver" and the other contains "net start mssqlserver".  I am running these .bat files as my pre- and post- job scripts.  I am still receiving the same errors within my ARCserve logs.

I manually ran the "net stop mssqlserver" .bat file and I did not notice any entry placed within the event viewer.  Should something be showing up there?

Thanks.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
lacrewgaCommented:
Try running it from a command window and then look at services and see if it shows stopped there...
0
 
csimmons1324IT ManagerAuthor Commented:
I just tried running it from the command prompt and received the following:

System error 1060 has occured.
The specified service does not exist as an installed service.
0
 
bhanukir7Commented:
Hi,

check in the services the name for the mssql service and try to run the net stop "service name"

if it is able to stop the service then you can go ahead and include the batch file in the pre-script.

As an alternate you install SQL visual studio if it is SQL 2005 and schedule backups for the database and then
backup the bkf files from arcserve.

bhanu
0
 
csimmons1324IT ManagerAuthor Commented:
I did some digging to see what service are run for WSUS to function properly.  In order to stop WSUS from running you need to execute the following commands:

net stop wsusservice
Iisreset /stop

This can be found here: http://support.microsoft.com/kb/909456

Does anyone see a problem with shutting down IIS?

Thanks,

Chris

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

  • 3
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now