+ Post New Thread
Results 1 to 2 of 2
Enterprise Software Thread, SQL 2012 Backup in Technical; We currently have a 2008 R2 member server that acts as an SQL Server running full blown SQL2012, at the ...
  1. #1

    Join Date
    Apr 2013
    Location
    Lincolnshire
    Posts
    162
    Thank Post
    4
    Thanked 1 Time in 1 Post
    Rep Power
    0

    SQL 2012 Backup

    We currently have a 2008 R2 member server that acts as an SQL Server running full blown SQL2012, at the moment it only runs the new finance system but will soon also be running SIMS, Sophos etc. as and when I can get the databases moved over.

    Is there anyway of automating the process of backing up the databases within SQL2012 so that they are copied to an area of the server ??? I will be installing Backup Exec 2010 on the server when I get back to school next week but know there were issues in the past with BE not being able to backup SQL databases.

  2. #2

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    18,157
    Thank Post
    522
    Thanked 2,551 Times in 1,980 Posts
    Blog Entries
    24
    Rep Power
    877
    To backup SQL, you either need to run scripts that do the job for you, or use a 'dedicated' SQL backup tool. BackupExec has an SQL module which does the backing up, as does BackupAssist amongst others.

    I'd recommend BackupAssist - its cheap but powerful. We have transactional backups in place, so we can roll back part of a day if we want to.

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] Migrated to SQL 2012 - Tons of password resets!
    By adamf in forum MIS Systems
    Replies: 12
    Last Post: 17th February 2014, 06:00 PM
  2. [SIMS] Sending SQL 2012 data to Capita
    By adamf in forum MIS Systems
    Replies: 17
    Last Post: 29th May 2013, 08:54 PM
  3. SQL Server Backup Modes
    By mbyrew in forum Enterprise Software
    Replies: 0
    Last Post: 21st January 2011, 08:27 PM
  4. Backup SQL 2005 with BackupAssist - Eror Messages grr
    By mrforgetful in forum How do you do....it?
    Replies: 2
    Last Post: 1st November 2007, 11:18 AM
  5. ...Install MS SQL 2005 and Veritas Backup Exec??
    By LordGrey in forum How do you do....it?
    Replies: 3
    Last Post: 27th September 2006, 05:44 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
  •