+ 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,817
    Thank Post
    272
    Thanked 1,138 Times in 1,034 Posts
    Rep Power
    350

    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,467
    Thank Post
    10
    Thanked 496 Times in 436 Posts
    Rep Power
    113
    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
    11,190
    Thank Post
    875
    Thanked 2,717 Times in 2,302 Posts
    Blog Entries
    11
    Rep Power
    780
    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,832
    Thank Post
    918
    Thanked 423 Times in 356 Posts
    Blog Entries
    12
    Rep Power
    88
    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
    115
    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,817
    Thank Post
    272
    Thanked 1,138 Times in 1,034 Posts
    Rep Power
    350
    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
  •