Link to home
Start Free TrialLog in
Avatar of wannabecraig
wannabecraigFlag for Ireland

asked on

SQL DB backup advice

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.
Avatar of Anthony Perkins
Anthony Perkins
Flag of United States of America image

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.
ASKER CERTIFIED SOLUTION
Avatar of Nem Schlecht
Nem Schlecht
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial