Solved

ARCserve and Shutting Down SQL Database for WSUS

Posted on 2007-12-03
7
1,990 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

VM backup deduplication is a method of reducing the amount of storage space needed to save VM backups. In most organizations, VMs contain many duplicate copies of data, such as VMs deployed from the same template, VMs with the same OS, or VMs that h…
Are you looking to recover an email message or a contact you just deleted mistakenly? Or you are searching for a contact that you erased from your MS Outlook ‘Contacts’ folder and now realized that it was important.
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…

856 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