Solved

ARCserve and Shutting Down SQL Database for WSUS

Posted on 2007-12-03
7
1,993 Views
Last Modified: 2010-08-05
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
Comment
Question by:csimmons1324
  • 3
  • 2
  • 2
7 Comments
 
LVL 7

Expert Comment

by:lacrewga
ID: 20397417
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
 
LVL 23

Expert Comment

by:bhanukir7
ID: 20400107
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
 

Author Comment

by:csimmons1324
ID: 20449921
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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 7

Expert Comment

by:lacrewga
ID: 20457534
Try running it from a command window and then look at services and see if it shows stopped there...
0
 

Author Comment

by:csimmons1324
ID: 20459707
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
 
LVL 23

Expert Comment

by:bhanukir7
ID: 20461719
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
 

Accepted Solution

by:
csimmons1324 earned 0 total points
ID: 20465528
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

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article is an update and follow-up of my previous article:   Storage 101: common concepts in the IT enterprise storage This time, I expand on more frequently used storage concepts.
Microservice architecture adoption brings many advantages, but can add intricacy. Selecting the right orchestration tool is most important for business specific needs.
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…

756 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question