+ Post New Thread
Page 2 of 2 FirstFirst 12
Results 16 to 21 of 21
MIS Systems Thread, sims backup in Technical; A live backup is what Backup Exec is doing you won't find the files but you should be able to ...
  1. #16
    wesleyw's Avatar
    Join Date
    Dec 2005
    Location
    Kingswinford
    Posts
    2,205
    Thank Post
    223
    Thanked 50 Times in 44 Posts
    Blog Entries
    1
    Rep Power
    30
    A live backup is what Backup Exec is doing you won't find the files but you should be able to restore the dbs to another sql server you just have to specify which during the restore. As for SQL Server backups these are much better tbh..

    Wes

  2. #17

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,342
    Thank Post
    367
    Thanked 624 Times in 509 Posts
    Rep Power
    156
    Only if you have the agent! Which is like 100.

  3. #18
    wesleyw's Avatar
    Join Date
    Dec 2005
    Location
    Kingswinford
    Posts
    2,205
    Thank Post
    223
    Thanked 50 Times in 44 Posts
    Blog Entries
    1
    Rep Power
    30
    I am using Symantec Backup exec 11d and have the agent for SQL Server 2000.
    He has got the SQL Server Agent?

    Wes

  4. #19
    meastaugh1's Avatar
    Join Date
    Jul 2006
    Location
    London/Hertfordshire
    Posts
    889
    Thank Post
    69
    Thanked 85 Times in 70 Posts
    Rep Power
    32
    Quote Originally Posted by arthur231283 View Post
    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?
    I didn't think you should expect to see the live database files as flat files in the backup, even when you have the SQL agent. I believe you should see the SQL instances and databases available to backup/restore as a separate node, similar to how AD and system state are represented.

    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)
    I use dbattach as the primary backup method and the BE SQL agent as secondary. The only SQL services we used to stop/start were the SQL Anywhere services for FMS.

  5. #20

    Join Date
    Apr 2009
    Location
    Essex
    Posts
    66
    Thank Post
    7
    Thanked 8 Times in 7 Posts
    Rep Power
    12
    @ECHO OFF
    COLOR CF
    ECHO YOUR SQL DATABASE IS CURRENTLY BEING BACKED UP, THIS MAY TAKE SEVERAL MINUTES
    DBATTACH /BACKUP /AUTO /SERVER=XXXXX\SIMS2005 /user=sa /password=XXXXXX /DATABASE=sims
    DBATTACH /BACKUP /AUTO /SERVER=XXXXX\SIMS2005 /user=sa /password=XXXXXX /DATABASE=ccsfms
    Schedule that and mark the backup folderfor SQL in your Agents selections so you have both

  6. #21
    sahmeepee's Avatar
    Join Date
    Oct 2005
    Location
    Greater Manchester
    Posts
    795
    Thank Post
    20
    Thanked 70 Times in 42 Posts
    Rep Power
    33
    Quote Originally Posted by jinnantonnix View Post
    Be careful if you do it this way. As you're not doing a 'proper' backup (as far as SQL server is concerned), the log file is never truncated or shrunk. If you don't backup using either an SQL backup task or a backup agent, the log files will grow to humongous sizes. The log file is not truncated until SQL server is sure that the database has been backed up.

    It's always best to use some proper backup solution.
    That said, dbattach (in a batch similar to Steve_T's above) is a Capita-recommended method for your nightly backups. We have been using it for a good while and have never had problems with transaction logs growing. I suspect either: dbattach takes care of the problem -or- the SQL backup which happens before every upgrade or database patch is frequent enough to remove the problem.

SHARE:
+ Post New Thread
Page 2 of 2 FirstFirst 12

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
  •