Stack Overflow
Stack Overflow

Questions tagged [backup-strategies]

169 questions
1
vote
0 answers

backup up db using php script and cron job

I'm using the script I posted below and it appeared to have worked based on the email and the fact it actually generated the file. However, It didn't backup anything. Here is the output stored in the file it created: SET FOREIGN_KEY_CHECKS=0; SET…
D.Davis
  • 15
  • 1
  • 10
1
vote
2 answers

How do I use git without having a proper git server?

I want to be able to make backups of my project in a windows environment without having to manually copy and paste my whole folder. Unfortunately I am not allowed to use a remote git server for this project, so I was wondering if I could use git for…
Ronaldo Felipe
  • 402
  • 2
  • 13
1
vote
1 answer

SQL Server differential backup file size smaller than previous one?

I have a production system running on an SQL Server 2008 DBMS, in Full recovery mode. I take a full backup each day at midnight, a log backup every two hours, and a differential backup every 6 hours (06:00, 12:00, 18:00, but not midnight as the full…
tjeuten
  • 649
  • 9
  • 28
1
vote
1 answer

Migration MSSql Db - from SQL Server 2008 R2 Enterprise backup can restore in SQL Server 2008 R2 Express version

I have a quick simple question: can a SQL Server 2008 R2 Enterprise/ Developer edition backup be restored in a SQL Server 2008 R2 Express version? Source: SQL Server 2008 R2 10.50.1600.1 RTM Developer Edition (64-bit) Destination: SQL Server…
Ajay2707
  • 5,690
  • 6
  • 40
  • 58
1
vote
2 answers

Hg ( Merculrial ) Backup policy

We have 500 plus Hg repositories and am looking for a quick and efficient want of backup. Is there a script or Tool that we can use to backup these repositories. We tried Hg bundle, hg clone and regular file system backup but they are not…
Rajeev Saraswat
  • 11
  • 1
1
vote
2 answers

AWS backup account

We all know about what happened to Cold Spaces getting hacked and their AWS account essentially erased. I'm trying to put together recommendation on set of tools, best practices on archiving my entire production AWS account into a backup only where…
Ma Diga
  • 406
  • 1
  • 3
  • 14
1
vote
2 answers

Is there a way to only backup a SQL 2005 database structure fully, but only the data in a certain set of schemas?

I have several schemas in my database, and the largest one ("large" meaning disk space consumed) is my "web" schema which is a denormalized copy of data in the operational schemas. This denormalized data is able to be reconstructed at anytime, and…
TheSoftwareJedi
  • 34,421
  • 21
  • 109
  • 151
1
vote
1 answer

Should I be backing up a webapp's data to another host continuously?

I have a webapp in development. I need to plan for what happens if the host goes down. I will lose some very recent session status (which I can live with) and everything else should be persistently stored in the database. If I am starting up again…
Griff
  • 31
  • 5
1
vote
2 answers

Subversion: is it possible to backup only the delta since the last backup?

Does someone here know if it is possible to backup only the part of a subversion reposiotory that has changed since the last backup (that is: the delta)? Practically, that could be something like doing a full backup every midnight, and a delta every…
René Nyffenegger
  • 39,402
  • 33
  • 158
  • 293
1
vote
4 answers

Versioning SQLite databases with Subversion. Good idea or bad idea?

So I have a web system where every user gets a separate SQLite database which acts as a sort of their workspace. All of the database files are in a directory with database names that match up to the user ids. Many of these databases are created and…
RobKohr
  • 6,611
  • 7
  • 48
  • 69
1
vote
1 answer

SQL Server 2008 backup from locked down hosting provider

I have a shared MS Sql 2008 database with my hosting provider and MS SQL Standard 2008 on my local box. They have the SQL Server locked down (rightly enough) but it menas I don't have sufficient privileges to use the backup database wizard or to…
amjags
  • 39
  • 5
1
vote
1 answer

Database backup - differential file size question

For my backup plan for SQL Server 2005, I want to do a full on Sunday: BACKUP DATABASE myDatabase TO DISK = 'D:\Database Backups\myDatabase_full.bak' WITH FORMAT GO Then I want to do a differential nightly the rest of the week: BACKUP DATABASE…
Chris Burgess
  • 5,787
  • 13
  • 54
  • 69
1
vote
2 answers

Best Practices for Development Backups

I am a intermediate-level developer (I think). I almost always work alone. I have always just save my code to my hard drive and then published it to my server. I almost always over-write old code. If I make a big mistake I will get a backup restored…
Brian Barrus
  • 385
  • 3
  • 6
  • 17
1
vote
1 answer

What when mysqldump becomes utterly slow

Currently my database is almost 20 GB big and still growing. I'm taking a daily backup with mysqldump and it's getting really slow. So slow that in the meanwhile new connections stack up and eventually cause this error: SQLSTATE[HY000] [1040] Too…
lordstyx
  • 775
  • 3
  • 12
  • 29
1
vote
1 answer

permanently remove revisions from SVN

Preamble My SVN hosting is provided by a 3rd party which limits my usage to 300MB. As the project is only of a moderate size, I never imagined this would be a problem. Once the app went to production, I realised that I needed some kind of backup…
Dónal
  • 185,044
  • 174
  • 569
  • 824
1 2 3
…
11 12