Results 1 to 8 of 8

Thread: SQL backup software?

  1. Mar 2nd, 2016, 10:01 AM #1
    stanav
    stanav is offline

    Thread Starter
    PowerPoster stanav's Avatar
    Join Date
    Jul 2006
    Location
    Providence, RI - USA
    Posts
    9,290

    SQL backup software?

    Hi,
    Can anyone recommend an MS SQL server backup software that is robust and can do scheduled full, differential as well as transaction log backups and restore from the backups reliably?
    Is SQL Server Backup and FTP any good? It's very affordable for sure
    Thanks,
    Stanav.
    Let us have faith that right makes might, and in that faith, let us, to the end, dare to do our duty as we understand it.
    - Abraham Lincoln -
    Reply With Quote Reply With Quote
  2. Mar 2nd, 2016, 01:26 PM #2
    techgnome
    techgnome is offline
    PowerPoster techgnome's Avatar
    Join Date
    May 2002
    Posts
    34,687

    Re: SQL backup software?

    I've never used anything but the built-in SQL Backup manager... a couple lifetimes ago, our recommendation to our clients were hourly transaction backups with daily full backups and full server with off-site storag of the tapes. In 10+ years (I left after 9 1/2) we never lost more than an hour's worth of information (lag time between the last transbackup and the current time.)

    -tg
    * I don't respond to private (PM) requests for help. It's not conducive to the general learning of others.*
    * I also don't respond to friend requests. Save a few bits and don't bother. I'll just end up rejecting anyways.*
    * How to get EFFECTIVE help: The Hitchhiker's Guide to Getting Help at VBF - Removing eels from your hovercraft *
    * How to Use Parameters * Create Disconnected ADO Recordset Clones * Set your VB6 ActiveX Compatibility * Get rid of those pesky VB Line Numbers * I swear I saved my data, where'd it run off to??? *
    Reply With Quote Reply With Quote
  3. Mar 4th, 2016, 11:58 AM #3
    stanav
    stanav is offline

    Thread Starter
    PowerPoster stanav's Avatar
    Join Date
    Jul 2006
    Location
    Providence, RI - USA
    Posts
    9,290

    Re: SQL backup software?

    Thanks, TG. Yes, the built-in SQL Backup Manager is sufficient for my organization, but it's kind of cumbersome to to set up and use. Most guys at our organization, me included, are not very knowledgeable on SQL server and database management. The guys are just programmers and I'm the system admin/network engineer. Therefore, I'm looking for a product that is reliable and easy to use, one that doesn't require a DBA certification to operate
    Let us have faith that right makes might, and in that faith, let us, to the end, dare to do our duty as we understand it.
    - Abraham Lincoln -
    Reply With Quote Reply With Quote
  4. Mar 4th, 2016, 12:35 PM #4
    techgnome
    techgnome is offline
    PowerPoster techgnome's Avatar
    Join Date
    May 2002
    Posts
    34,687

    Re: SQL backup software?

    There should be a Maintenance Plan wizard that you can run through... you set it up once, and that's it...

    -tg
    * I don't respond to private (PM) requests for help. It's not conducive to the general learning of others.*
    * I also don't respond to friend requests. Save a few bits and don't bother. I'll just end up rejecting anyways.*
    * How to get EFFECTIVE help: The Hitchhiker's Guide to Getting Help at VBF - Removing eels from your hovercraft *
    * How to Use Parameters * Create Disconnected ADO Recordset Clones * Set your VB6 ActiveX Compatibility * Get rid of those pesky VB Line Numbers * I swear I saved my data, where'd it run off to??? *
    Reply With Quote Reply With Quote
  6. Mar 4th, 2016, 01:34 PM #5
    GaryMazzone
    GaryMazzone is offline
    A SQL Server fool GaryMazzone's Avatar
    Join Date
    Aug 2005
    Location
    Dover,NH
    Posts
    7,493

    Re: SQL backup software?

    Just remember to do log backups if the database is in full recovery. Set compression on (if 2228 server or better). Set a backup folder. Add a task to remove files older the x days (how long do you want to keep a backup locally). Ensure that the network backup picks up the folder that the backup is written too. Also ensure that network backup software is not backing up the folder that the database or log files are located in.

    -gary
    Sometimes the Programmer
    Sometimes the DBA

    Mazz1
    Reply With Quote Reply With Quote
  7. Mar 4th, 2016, 03:59 PM #6
    stanav
    stanav is offline

    Thread Starter
    PowerPoster stanav's Avatar
    Join Date
    Jul 2006
    Location
    Providence, RI - USA
    Posts
    9,290

    Re: SQL backup software?

    Thanks Gary. I just begin learning to manage SQL server so any advice from the pros are really helpful for me
    Let us have faith that right makes might, and in that faith, let us, to the end, dare to do our duty as we understand it.
    - Abraham Lincoln -
    Reply With Quote Reply With Quote
  8. Mar 4th, 2016, 05:28 PM #7
    techgnome
    techgnome is offline
    PowerPoster techgnome's Avatar
    Join Date
    May 2002
    Posts
    34,687

    Re: SQL backup software?

    Hit szlamany up... he's pretty good with the SQL Server & admin type stuff...

    He'd be more likely to find this if you post right in the database section, askign for help on setting up a maintenance plan for SQL Server.

    -tg
    * I don't respond to private (PM) requests for help. It's not conducive to the general learning of others.*
    * I also don't respond to friend requests. Save a few bits and don't bother. I'll just end up rejecting anyways.*
    * How to get EFFECTIVE help: The Hitchhiker's Guide to Getting Help at VBF - Removing eels from your hovercraft *
    * How to Use Parameters * Create Disconnected ADO Recordset Clones * Set your VB6 ActiveX Compatibility * Get rid of those pesky VB Line Numbers * I swear I saved my data, where'd it run off to??? *
    Reply With Quote Reply With Quote
  9. Mar 14th, 2016, 08:44 AM #8
    faustjonson
    faustjonson is offline
    New Member faustjonson's Avatar
    Join Date
    Mar 2016
    Location
    USA New York
    Posts
    4

    Re: SQL backup software?

    In Linux you can set automatic backup of databases, some panels as isp manager support
    Reply With Quote Reply With Quote
« Previous Thread | Next 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
  •  

Forum Rules


Click Here to Expand Forum to Full Width