MIS Systems Thread, sims backup in Technical; I am using Symantec Backup exec 11d and have the agent for SQL Server 2000. The sims server seems to ...
28th April 2009, 09:19 PM #1
I am using Symantec Backup exec 11d and have the agent for SQL Server 2000. The sims server seems to be backing up fine including the SQL but it is not backing up the sims.ldf, sims.mdf, ccsfms.ldf and ccsfms.mdf files. I have looked on the symantec support pages but have not found anything.
Is there a setting or a tick box some where that I need to change to get these files to backup?
or is there a different way I should be backing up these files?
IDG Tech News
28th April 2009, 10:24 PM #2
That sounds like you've not got the Open Files backup module for BackupExec
28th April 2009, 10:54 PM #3
Was about to say some naughty user's keeping their SIMS logged in at the time you're backing up - but "open files module" ? Interested
28th April 2009, 11:17 PM #4
I have a script that forces reboots every computer in school before the backups. Saves problems like this....
29th April 2009, 09:27 AM #5
- Rep Power
SQL stop/start batch files, do you have them?
29th April 2009, 12:50 PM #6
Like Steve said, stop MSSQL
Or get the Symantec SQL addin
Or scheduled dbattach to backup SIMS, then exclude the .mdf\.ldf (MSSQL data folder)
29th April 2009, 01:31 PM #7
As others have said, you'll need to either run a script scheduled or run a pre-job / post-job command on the job.
It would be along these lines
NET STOP MSSQL$SIMS2005
NET START MSSQL$SIMS2005
29th April 2009, 01:56 PM #8
You can use Dbattach to backup the SIMS database via a scheduled task
there are various switches that make this simple to do
in your first statement you mention the SQL agent for SQL2000?? Sims should be on SQL 2005
Last edited by Mcshammer_dj; 29th April 2009 at 02:00 PM.
30th April 2009, 08:45 AM #9
Thanks for all the suggestions I do have the Agent for SQL and I have installed the open files backup module on the server. I have checked that I have selected the files in the backup selection list but its still not backing up the sims.ldf/.mdf and ccsfms.ldf/.mdf files. So it looks like I will need to create the batch file to stop and start the SQL.
30th April 2009, 10:31 AM #10
You shouldn't need a batch file as Backup exec has the functionality to stop services as required.
12th May 2009, 11:54 AM #11
Was this ever resolved ? I have EXACTLY the same problem with Backup Exec 11d and SIMS....
Originally Posted by arthur231283
12th May 2009, 11:59 AM #12
There is two backupExec addons
One is open files, the other is MSSQL (2005 NOT MSDE\2000). You need the MSSQL to backup SIMS, the open files can't backup .mdf\.ldf. Both addins are extras.
OK not call addons but AGENTS.
Symantec Backup Exec for Windows Servers: Agents & Options - Symantec Corp.
(Yes, I know v.12 but v.10 is the same licensing model (almost))
Last edited by matt40k; 12th May 2009 at 12:22 PM.
12th May 2009, 02:14 PM #13
- Rep Power
Create two batch files as follows as save them somewhere C:\XXXX\XX.bat,
net start "MSSQL$SIMS"
Note: instance name may be different.
net stop "MSSQL$SIMS"
Doing this blind so forgive me if this is wrong.
Job Monitor - Right click on backup - properties - pre and post commands - type location of the above files you have created - leave default settings - test.
12th May 2009, 09:00 PM #14
Is it safe to stop/start the SQL instance before taking a backup of the SQL database(s)? I was always under the impression you should be doing all backups through dbAttach (or some other method such as BE)
12th May 2009, 09:22 PM #15
You'll need to have SQL running to use dbAttach as it does a live backup.
Originally Posted by Oops_my_bad
By pooley in forum MIS Systems
Last Post: 27th March 2009, 01:33 PM
By ninjabeaver in forum MIS Systems
Last Post: 16th January 2009, 11:40 AM
By ee01akk in forum MIS Systems
Last Post: 29th August 2008, 12:37 PM
By Ell2Cool in forum MIS Systems
Last Post: 29th October 2007, 01:21 PM
By Jawloms in forum MIS Systems
Last Post: 26th October 2007, 04:17 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Tags for this Thread