Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Ahsay Backup, Shadow Copy, SQL etc..

Posted on 2009-07-10
4
Medium Priority
?
1,600 Views
Last Modified: 2012-05-07
We run remote backups for clients, using AhsayOMB software. For some reason, we get errors once in a while, stating that the backup has been completed with errors. Part of our backup is to Stop SQL(Pre Command) during the job, then to start it back up (Post Command). For some clients and only every so often (although one client gets it all through the week and not on the weekends?) the backup generates an error when going to start the SQL service back up. The backup is good, but I am really curious as to what could be starting SQL before the post command?  My suspicion is that its some kind of interaction between VSS Writer and Shadow Copy but then why does it not error every time?  

Backup Job  Info  2009/07/09 10:12  Start [ Windows 2003 (SERVER), AhsayOBM 5.2.2.1 ]
 2  Info  2009/07/09 10:12  Start running pre-commands
 3  Info  2009/07/09 10:12  [Pre-backup Command-1] net stop mssql$lytec_sql /y
 4  Info  2009/07/09 10:12  [Pre-backup Command-1] The MSSQL$LYTEC_SQL service is stopping.
 5  Info  2009/07/09 10:12  [Pre-backup Command-1] The MSSQL$LYTEC_SQL service was stopped
successfully.
6  Info  2009/07/09 10:12  [Pre-backup Command-1]
7  Info  2009/07/09 10:12  Finished running pre-commands
 8  Info  2009/07/09 10:12  Starting to create Shadow Copy Set &
 9  Info  2009/07/09 10:12  Shadow Copy Set created successfully
 10  Info  2009/07/09 10:12  Generate incremental delta since "2009-07-06-15-34-46"
 11  Info  2009/07/09 10:12  Downloading delta information ... "F:\LytecData\Backup\
Lytec_Daily_Backup.bak"
 12  Info  2009/07/09 10:22  [Summary] 44.9M / 704.33M (Delta file size/ full file size),
delta ratio=6%
13  Info  2009/07/09 10:24  Generate incremental delta since "2009-07-06-15-34-46"
 14  Info  2009/07/09 10:24  Downloading delta information ... "F:\LytecData\MSSQL$LYTEC_SQL\
Data\Whitby Family Clinic.dat"
 15  Info  2009/07/09 10:31  [Summary] 28.96M / 729.25M (Delta file size/ full file size),
delta ratio=3%
 16  Info  2009/07/09 10:33  Start running post-commands
 17  Info  2009/07/09 10:33  [Post-backup Command-1] net start mssql$lytec_sql
 18  Error  2009/07/09 10:33  [Post-backup Command-1] The requested service has already been
started.
 19  Error  2009/07/09 10:33  [Post-backup Command-1]
 20  Error  2009/07/09 10:33  [Post-backup Command-1] More help is available by typing NET
HELPMSG 2182.
 21  Error  2009/07/09 10:33  [Post-backup Command-1]
 22  Info  2009/07/09 10:33  Finished running post-commands
 23  Info  2009/07/09 10:33  Deleting Shadow Copy Volume for "F:\"
0
Comment
Question by:wdabbs
[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
  • 2
  • 2
4 Comments
 
LVL 21

Expert Comment

by:za_mkh
ID: 24823298
Well the error message is not an error message:
 17  Info  2009/07/09 10:33  [Post-backup Command-1] net start mssql$lytec_sql
 18  Error  2009/07/09 10:33  [Post-backup Command-1] The requested service has already been started.
All Line 18 tells you is that, the SQL service that you were trying to start in Line 17, is already started ... to me I would look at how the SQL service was started since Line 5 says that it was stopped ? So if was stopped, what started it? Some other process or the process mentioned on Line 8?
If everything works, and your backups are good ... I would also say ... leave it alone! It works!


 
0
 

Author Comment

by:wdabbs
ID: 24823342
That is my question. 'backup is good, but I am really curious as to what could be starting SQL before the post command?"
0
 
LVL 21

Accepted Solution

by:
za_mkh earned 2000 total points
ID: 24823434
Can't believe I missed your last sentence in your original post! Talk about me trying to state the bleeding obvious :}
You would  need check your server / the VSS option to work that out ...
Look at the event logs ... that could give a clue as to what starts the service again ...
0
 

Author Comment

by:wdabbs
ID: 24823481
Thanks for the help.. I will continue to dig into it, but will nto waste to much time seeing how the backups are good.
0

Featured Post

Independent Software Vendors: 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

When converting a physical machine to a virtual machine using VMware vCenter Converter Standalone or vCenter Converter Enterprise, if an adapter type is not selected during the initial customization the resulting virtual machine may contain an IDE d…
In this article, I will show you HOW TO: Install VMware Tools for Windows on a VMware Windows virtual machine on a VMware vSphere Hypervisor 6.5 (ESXi 6.5) Host Server, using the VMware Host Client. The virtual machine has Windows Server 2016 instal…
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 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…

618 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