+ Post New Thread
Results 1 to 6 of 6
Windows Thread, Backing up SQL 2008 in Technical; Just a quick question, What are people using to backup SQL 2008? we currently are using backup exec 12.0 which ...
  1. #1

    glennda's Avatar
    Join Date
    Jun 2009
    Location
    Sussex
    Posts
    7,714
    Thank Post
    269
    Thanked 1,116 Times in 1,012 Posts
    Rep Power
    345

    Backing up SQL 2008

    Just a quick question,

    What are people using to backup SQL 2008? we currently are using backup exec 12.0 which as far as i can see will not backup sql 2008. You cannot use NT backup AFAIK to backup sql.

    is this something we are going to have to bite the bullet and upgrade exec to version 12.5? or is there an alternative?

  2. #2
    DMcCoy's Avatar
    Join Date
    Oct 2005
    Location
    Isle of Wight
    Posts
    3,386
    Thank Post
    10
    Thanked 483 Times in 423 Posts
    Rep Power
    110
    Scheduled backup to a file on the servers disk with the sql agent. Then that file is part of the normal backup. You just need the sql management studio to create the task. I assume this is possible in sql express, but mostly use sql standard here.

  3. #3

    SYNACK's Avatar
    Join Date
    Oct 2007
    Posts
    10,693
    Thank Post
    824
    Thanked 2,570 Times in 2,187 Posts
    Blog Entries
    9
    Rep Power
    731
    Agreed you should be able to use managment studio express with SQL express to schedule a backup job in SQL itself out to a known file location then just pick it up on the standard backup.

  4. #4
    zag
    zag is offline
    zag's Avatar
    Join Date
    Mar 2007
    Posts
    3,530
    Thank Post
    815
    Thanked 380 Times in 317 Posts
    Blog Entries
    12
    Rep Power
    80
    Microsoft DPM 2010 is pretty cheap and does a great job.

    Backup exec really isn't the market leader any more.

  5. #5

    Join Date
    Jan 2006
    Location
    Surburbia
    Posts
    2,178
    Thank Post
    74
    Thanked 307 Times in 243 Posts
    Rep Power
    114
    you should be able to use managment studio express with SQL express to schedule a backup job in SQL itself
    You (or at least I) get that feature Management Studio Express, however you can go get ExpressMaint and use it in a simple scheduled task to create/trim-to-last-n backups/recreate indexes etc... it's a very, very handy little app.

    Or if a DB doesn't have to run 24/7 shut it down as a backup job pre-backup command and start it up again as a post-backup command.

  6. #6

    glennda's Avatar
    Join Date
    Jun 2009
    Location
    Sussex
    Posts
    7,714
    Thank Post
    269
    Thanked 1,116 Times in 1,012 Posts
    Rep Power
    345
    For Anyone looking at this thread looking for a backup solution, this is a walk through that i followed for setting this up Scheduling Automated Sql Backup

SHARE:
+ Post New Thread

Similar Threads

  1. Moodle / Server 2008 / IIS7 / MS SQL Server 2008 Express
    By Kamran7860 in forum Virtual Learning Platforms
    Replies: 3
    Last Post: 23rd November 2010, 06:03 AM
  2. Windows 2008, SQL 2008 and Backup Exec 12
    By joe90bass in forum Windows
    Replies: 2
    Last Post: 5th May 2010, 02:49 PM
  3. Backing up SIMS with Windows Server 2008 Backup
    By mrforgetful in forum MIS Systems
    Replies: 3
    Last Post: 30th September 2009, 06:01 PM
  4. Replies: 7
    Last Post: 20th February 2008, 04:37 PM
  5. Backing up SQL database ?
    By Kyle in forum Windows
    Replies: 4
    Last Post: 8th June 2006, 09:36 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
  •