+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 21
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 ...
  1. #1
    arthur231283's Avatar
    Join Date
    Sep 2008
    Location
    Dartford
    Posts
    164
    Thank Post
    34
    Thanked 37 Times in 23 Posts
    Rep Power
    18

    sims backup

    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?

  2. #2
    Richie1972's Avatar
    Join Date
    Apr 2006
    Location
    Blackburn
    Posts
    239
    Thank Post
    2
    Thanked 6 Times in 6 Posts
    Rep Power
    18
    That sounds like you've not got the Open Files backup module for BackupExec

  3. #3

    synaesthesia's Avatar
    Join Date
    Jan 2009
    Location
    Northamptonshire
    Posts
    5,885
    Thank Post
    575
    Thanked 1,001 Times in 773 Posts
    Blog Entries
    15
    Rep Power
    461
    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

  4. #4

    FN-GM's Avatar
    Join Date
    Jun 2007
    Location
    UK
    Posts
    15,846
    Thank Post
    877
    Thanked 1,680 Times in 1,460 Posts
    Blog Entries
    12
    Rep Power
    444
    I have a script that forces reboots every computer in school before the backups. Saves problems like this....

  5. #5

    Join Date
    Apr 2009
    Location
    Essex
    Posts
    66
    Thank Post
    7
    Thanked 8 Times in 7 Posts
    Rep Power
    12
    SQL stop/start batch files, do you have them?

  6. #6

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,390
    Thank Post
    368
    Thanked 637 Times in 519 Posts
    Rep Power
    158
    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)

  7. #7
    IrritableTech's Avatar
    Join Date
    Nov 2007
    Location
    West Yorkshire
    Posts
    795
    Thank Post
    84
    Thanked 172 Times in 141 Posts
    Rep Power
    64
    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

    and afterwards

    NET START MSSQL$SIMS2005

  8. #8
    Mcshammer_dj's Avatar
    Join Date
    Feb 2007
    Location
    Portsmouth
    Posts
    936
    Thank Post
    35
    Thanked 164 Times in 132 Posts
    Rep Power
    94
    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 01:00 PM.

  9. #9
    arthur231283's Avatar
    Join Date
    Sep 2008
    Location
    Dartford
    Posts
    164
    Thank Post
    34
    Thanked 37 Times in 23 Posts
    Rep Power
    18
    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.

  10. #10
    Mcshammer_dj's Avatar
    Join Date
    Feb 2007
    Location
    Portsmouth
    Posts
    936
    Thank Post
    35
    Thanked 164 Times in 132 Posts
    Rep Power
    94
    You shouldn't need a batch file as Backup exec has the functionality to stop services as required.

  11. #11

    Join Date
    Jun 2007
    Location
    Cumbria
    Posts
    148
    Thank Post
    11
    Thanked 12 Times in 11 Posts
    Rep Power
    18
    Quote Originally Posted by arthur231283 View Post
    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.
    Was this ever resolved ? I have EXACTLY the same problem with Backup Exec 11d and SIMS....

  12. #12

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,390
    Thank Post
    368
    Thanked 637 Times in 519 Posts
    Rep Power
    158
    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 11:22 AM.

  13. #13

    Join Date
    Apr 2009
    Location
    Essex
    Posts
    66
    Thank Post
    7
    Thanked 8 Times in 7 Posts
    Rep Power
    12
    Create two batch files as follows as save them somewhere C:\XXXX\XX.bat,

    @echo off
    net start "MSSQL$SIMS"
    @echo off
    net stop "MSSQL$SIMS"
    Note: instance name may be different.

    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.

  14. #14
    Oops_my_bad's Avatar
    Join Date
    Jan 2007
    Location
    Man chest hair
    Posts
    1,738
    Thank Post
    438
    Thanked 53 Times in 50 Posts
    Rep Power
    30
    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)

  15. #15

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,390
    Thank Post
    368
    Thanked 637 Times in 519 Posts
    Rep Power
    158
    Quote Originally Posted by Oops_my_bad View Post
    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)
    You'll need to have SQL running to use dbAttach as it does a live backup.

SHARE:
+ Post New Thread
Page 1 of 2 12 LastLast

Similar Threads

  1. Sims Backup - Advice
    By pooley in forum MIS Systems
    Replies: 15
    Last Post: 27th March 2009, 12:33 PM
  2. SIMS Backup Time
    By ninjabeaver in forum MIS Systems
    Replies: 6
    Last Post: 16th January 2009, 10:40 AM
  3. SIMS upgrade backup problem
    By ee01akk in forum MIS Systems
    Replies: 3
    Last Post: 29th August 2008, 11:37 AM
  4. Replies: 4
    Last Post: 29th October 2007, 12:21 PM
  5. SIMS .net backup path
    By Jawloms in forum MIS Systems
    Replies: 2
    Last Post: 26th October 2007, 03:17 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •