Solved

ARCserve and Shutting Down SQL Database for WSUS

Posted on 2007-12-03
7
1,984 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
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 
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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Hello, As I have seen there a lot of requests regarding monitoring and reporting for exchange 2007 / 2010 / 2013 I have decided to post some thoughts together and link to articles that have helped me. Of course a lot of information you can get…
The article will include the best Data Recovery Tools along with their Features, Capabilities, and their Download Links. Hope you’ll enjoy it and will choose the one as required by you.
This tutorial will walk an individual through the process of installing the necessary services and then configuring a Windows Server 2012 system as an iSCSI target. To install the necessary roles, go to Server Manager, and select Add Roles and Featu…
This tutorial will walk an individual through the process of installing of Data Protection Manager on a server running Windows Server 2012 R2, including the prerequisites. Microsoft .Net 3.5 is required. To install this feature, go to Server Manager…

895 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now