Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [database-backup]

251 questions
0
votes
0 answers

Exchange 2010 logs

Exchange 2010 sometimes doesn't delete its logs after full backup completion! Usually, we we just delete these logs (and we didn't face any problem because of that) However; is there another way to force log truncation -cleanly and safely; without…
Ahmadgeo
  • 121
  • 5
0
votes
2 answers

Does it change anything when I disable obsolete parameters in SQL Backups? SKIP , stats, Nounload , norewind etc

I am pretty new in managing Computersystems but I always want to know everything to get out the maximum. When we last time deployed a new version of our application I was given a backup script to backup a specific Database. I saw backup parameters…
RayofCommand
  • 1,451
  • 8
  • 26
  • 36
0
votes
1 answer

How to create a consistent backup of an application (database and files on a disk)?

I have an application where some data is stored in a database and some directly on a file system. When a user performs an operation, his action can trigger a change to a database and to some file on a disk (git repository more specifically). Size of…
Janek
  • 153
  • 1
  • 4
0
votes
1 answer

pg_dump fails, no space left, need to delete partial backup file to free space

Easy points. On my mac, postgres.app 9.2, I ran "pg_dump pdbt > pdbt.sql". It used up all my space and then failed with the error below. Now I want to free up the space taken up by "pdbt.sql" but I cannot find this file. How do I get the space…
user2104778
  • 103
  • 2
0
votes
1 answer

Why does the mysql backup grow if a table is crashed?

I use this backup script on my debian squeeze server to create a backup of all mysqltables: #!/bin/sh BACKUP_DIR=/var/backups/mysql/ DATE=$(date +%Y-%m-%d) for i in /var/lib/mysql/*/; do dbname=`basename "$i"` mysqldump "$dbname" | gzip >…
rubo77
  • 2,469
  • 4
  • 34
  • 66
0
votes
1 answer

How to run a mysqldump automated with SAFELY stored mysql credentials?

I'm looking for a way to SAFELY run daily backups using mysqldump. Safely means not storing username/password in a text file or any other unencoded format. I know there is (apparently it isn't) a way to safely run MySQL queries: storing the…
Slava
  • 201
  • 3
  • 12
0
votes
2 answers

Postgresql pgdump script on RHEL5: "failed: fe_sendauth: no password supplieddatabase "

What I'm trying to accomplish is having a pg_dump script run as a cron job. Right now I'm just trying to get the script to run by invoking it myself at the command line. I've searched the postgresql mailing lists and followed the postgresql…
Tim Sanders
  • 119
  • 1
  • 4
0
votes
2 answers

No match for a database image file was found based on the source database alias "URCDB"

I used IBM Data Studio to backup a test database named URCTEST. Now, I want to restore it to the actual (empty) database, URCDB. I've got little experience with IBM DB2, so I assumed this was something similar to SQL Server, where I can create a…
zack_falcon
  • 165
  • 2
  • 11
0
votes
1 answer

Not Backing Up Files That Don't Change In A WordPress Install

I have a WordPress install and I'm wonder what is generally best practice when it comes to back up. I'm asking here instead of WordPress.stackexchange as this question is not only a WordPress question but a general backup question. Is it okay to…
Brooke.
  • 145
  • 2
  • 9
0
votes
3 answers

MySQL backup and save in external server

I have MySQL 5 installed in a Ubuntu server. I want backup the database for: latest 7 days weekly and store those backups in another server. I prefers the tool runs in the same server that host the Database, and store those files in a remote…
leticia
  • 113
  • 5
0
votes
1 answer

Is it possible to dump a postgresql db and restore it in mysql?

I'm trying to get migrate data from a postgre db into mysql (mariaDB) and was wondering if it is possible to restore a db in mysql from a pgsql dump?
Dark Star1
  • 1,385
  • 7
  • 22
  • 37
0
votes
1 answer

Backup and bz2 large mysql datefile with innobackupex in the background

I'm using the following command to backup a large running mysql database (~500GB). innobackupex --user=user --password=***** --stream=tar ./db-backup | bzip2 - > backup.tar.bz2 Since the backup process takes more than 24 hours, I want to run the…
Mohsen
  • 103
  • 2
0
votes
3 answers

How does tape backup affect production systems such as SQL Server

I am not a systems person or a DBA, and as I was reviewing a bid for a project, I started to wonder how the tape backup (LTO-5 3000) affects live production applications such as Sql Server Databases in Windows Server (2012). From my experience, the…
Candide
  • 141
  • 5
0
votes
1 answer

Remove Backup Configuration in SQL Server

I did a backup to a particular database and restore it in another Server. Now I want to remove that backup. But I couldn't remove it. Whenever I remove it, I got the attached error. Could you please advise me how I could delete the backup entry from…
TTCG
  • 121
  • 1
  • 3
0
votes
2 answers

Server failed, can I retrieve my database from the my hard disk?

I have an old server running Windows Server 2003 R2. Windows got corrupted due to an improper shutdown. I attempted to repair the Windows installation, but it made things worse (it gets to the desktop, but there is no start menu and most of the…
Alex
  • 125
  • 1
  • 4
1 2 3
…
16 17