wdabbs
asked on
Ahsay Backup, Shadow Copy, SQL etc..
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:\"
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_
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:\"
ASKER
That is my question. 'backup is good, but I am really curious as to what could be starting SQL before the post command?"
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for the help.. I will continue to dig into it, but will nto waste to much time seeing how the backups are good.
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!