Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

ARCserve and Shutting Down SQL Database for WSUS

Posted on 2007-12-03
7
Medium Priority
?
2,004 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

 
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

Technology Partners: 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!

Question has a verified solution.

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

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.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

715 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