Solved

SQL DB backup advice

Posted on 2013-05-23
2
200 Views
Last Modified: 2013-07-02
We have a SQL server live database that needs to be backed up.  It's too large to run as part of our online backups and not important enough.  However it'd be a bummer if we lost it but would not have a negative  business impact.

I have sectioned off a NAS device with 300GB or space.  The databases are about 150GB in size.  I only need one copy of the DB per week.  I can overwrite the DB from two weeks ago when backing up each week.  Which basically I only even need two full copies of the DB and the other ones can be overwritten.

We dont have any backup software in place and the company are unlikely to invest as it's not deemed important enough.
0
Comment
Question by:wannabecraig
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 39190622
If you are using at least SQL Server 2008 Standard Edition you can use compressed backups.  Failing that you should consider just zipping up the backups when complete.
0
 
LVL 23

Accepted Solution

by:
nemws1 earned 500 total points
ID: 39192546
As acperkins says, use compressed backups if possible.  The backups aren't that much slower to create and often save *tons* of disk space.

As for backup software, I'm not sure if you need it.  I've been using Ola Hallengren's excellent maintenance script:

http://ola.hallengren.com/

Which sets up multiple agent jobs.  Just schedule the FULL backup to run every 2 weeks.  One caveat thought - these scripts do *not* cleanup old databases *before* the backup.  In other words, a new backup is done and verified and only *then* are older backups deleted.  With your drive, you'd only be able to store 1 backup (you'd need the blank space for when you go to back up your db the *next* time).
0

Featured Post

Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question