+ Post New Thread
Results 1 to 3 of 3
MIS Systems Thread, Move to SQL 2008 and backups in Technical; We have recently had sims moved to sql2008. I currently use backup exec 12 on a backup server with agents ...
  1. #1

    Join Date
    Oct 2008
    Posts
    1
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Move to SQL 2008 and backups

    We have recently had sims moved to sql2008. I currently use backup exec 12 on a backup server with agents across the servers. I currently now can't backup the full instance of Sims under sql2008, I think i'll have to move to backup exec 12.5 for sql2008 support? Currently I have set maintence plans to do a daily DB backup run, I then backup this folder to the backup exec every night. What are peoples opinions on this is it worth moving up a version of backup exec to backup the full instance or am i covered with the current backing up of the .bak files and logs created through the sql management studio?

    Thanks

  2. #2
    Sarconia's Avatar
    Join Date
    Mar 2010
    Location
    London
    Posts
    315
    Thank Post
    15
    Thanked 34 Times in 31 Posts
    Rep Power
    16
    I personally don't use BackupExec but I do use both of the methods that you have described to otherwise back up my data and I've never had any issues restoring the database when anything has gone wrong before.

  3. #3
    randle's Avatar
    Join Date
    Dec 2006
    Location
    Chelmsford, Essex
    Posts
    604
    Thank Post
    68
    Thanked 17 Times in 16 Posts
    Rep Power
    20
    Can you not just stop the MSSQL$SIMS2008 service as a pre job script and then start it again as a post job script. That's what I've had running here for an age now and backs up the folder structure "as is". It's ideal seeing as no-one should be using SIMS that late into the evening.



SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] SIMS Tidy Backups - SQL 2008 - Autumn release
    By matt40k in forum MIS Systems
    Replies: 50
    Last Post: 20th October 2014, 01:45 PM
  2. SQL error preventing nightly backups
    By WithoutMotive in forum MIS Systems
    Replies: 1
    Last Post: 28th August 2008, 10:53 AM
  3. SQL Server 2005 Backups Problem
    By ICTNUT in forum Windows
    Replies: 0
    Last Post: 7th July 2008, 10:53 AM
  4. SIMS Backups with SQL 2005
    By WithoutMotive in forum MIS Systems
    Replies: 5
    Last Post: 17th January 2008, 10:55 AM
  5. SQL Backups stopped working
    By AnnDroyd in forum MIS Systems
    Replies: 3
    Last Post: 22nd December 2007, 04:23 PM

Thread Information

Users Browsing this Thread

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

Posting Permissions

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