Solved

SQL DB backup advice

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

Edgartown IT Case Study

Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!

Question has a verified solution.

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

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
In this article we will learn how to backup a VMware farm using Nakivo Backup & Replication. In this tutorial we will install the software on a Windows 2012 R2 Server.
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…
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

685 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