Solved

SQL DB backup advice

Posted on 2013-05-23
2
197 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

732 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