The database-backup tag has no wiki summary.
3
votes
3answers
45 views
Very high I/O on database during a backup maintenance plan
I've recently been having some hellacious problems with a specific maintenance plan. I found that part of the problem was that I had Shrink and Rebuild Index in my nightly plans, those have since ...
0
votes
0answers
27 views
Postgresql data backup key preservation
Hi we have a collections of PostgreSQL table that we want to backup and we are using postgres var dump. Now I am wondering how postgres variable dump, deals with table association. Say we have 2 ...
0
votes
1answer
29 views
postgresql backup and recovery
I’m trying to set up backup strategy for a production postgreSQL DB.
It will have large amount of data and it should be running 24 X 7.
Could you recommend some backup & recovery strategies that ...
0
votes
3answers
62 views
SQL Server Table Backup
A friend of mine has run into this problem on SQL Server 2008, please suggest a solution:
He came to know that auto backup scheduled on server were not taking place since last couple of days, when he ...
0
votes
0answers
35 views
restore using mysqlbinlog failing
While doing restore from a MySQL binary log file, it is failing with the following error .
mysqlbinlog mysql-bin.000036 | mysql -u root -p asdb
ERROR 1032 (HY000) at line 48: Can't find record in ...
1
vote
2answers
83 views
Restore .Bak file to different Server
I Copied some database backups from one server to another server(new instance no databases are present).I tried restoring using below command
Restore database dbname
from disk='g:\e2bak\dbname.bak'
...
1
vote
1answer
47 views
mysqlbinlog failing with “ ERROR 1032 (HY000) at line 48: Can't find record in `` ” Error
I am facing some issue with PITR restore using mysqlbinlog . It is failing with the following error .
# mysqlbinlog mysql-bin.000035 | mysql -u root -p db
Enter password:
ERROR 1032 (HY000) at ...
1
vote
2answers
41 views
Backup architecture for frequent backups of business critical DB
We've got a database (mysql) driven application which contains business critical information, were looking at building a system that will allow us to backup the db frequently (every 15 minutes, ...
0
votes
2answers
25 views
MS SQL Server 2012 Error on TLog Backup
I have a MS SQL Server 2012 installation on which I am restoring a SQL 2005 .bak which includes some full-text catalogues
The original .bak has no conflicts with 2012 (as the migrate advisor was used ...
0
votes
2answers
42 views
Extract Archived Log Files from RMAN Backupset
I have an RMAN backup that is taken on 19th january with: BACKUP DATABASE PLUS ARCHIVELOG command. Now I need to restore Archived logs from that backupset to some other OS directory. Is there any way ...
1
vote
2answers
202 views
RMAN list archivelogs that are needed for to recover specified backup
I've taken backup of datafiles in 31.12.2013. It completed datafile backups successfully, but archivelog backups failed.
Now, I want to determine what archivelogs should I backup to be sure that my ...
2
votes
2answers
106 views
What port is used by SQL Server to write backups to a remote server?
I have a SQL Server 2008 R2 Standard instance in a "DMZ", so that it can be client-facing. I am trying to have it write its backups to a central location that is within the network. The engineers ...
0
votes
0answers
108 views
Oracle EXP Error ORA-12704: character set mismatch
I need to duplicate a Oracle 11g Express Edition database from one computer to
another computer.
I tried exp sys/password FULL=Y FILE=backup.dump (the idea is to do a imp on the other pc)
But it ...
0
votes
0answers
16 views
HBase NetApp snapshot
I would like to use NetApp snapshots to backup single node, no-hdfs HBase instance. Do I have to just disable tables or something alse?
0
votes
0answers
129 views
Database backuped, but “Last database backup” property shows bad date
I have this procedure below to backup database(procedure is in backuped database). Procedure is called by external program. Procedure runs fine, backups are created. But when I want to find out last ...
2
votes
1answer
76 views
Is it possible to Clone a RedShift Database?
For some test and development work we would like the ability to routinely clone existing RedShift databases (all schema and all data). Something like a backup-restore.
The best I can find starts by ...
2
votes
0answers
77 views
TDP setup for SQL Server databases [closed]
I am looking for any tips/steps used by the DBA's for install and configuration of TDP backup for SQL databases. Hope this meets the criteria for the forum. Thanks
0
votes
1answer
57 views
How to give a client backups of their data without compromising our database design? [closed]
The client is asking for backups of their data, however we would not like to share our database design as it may lead to a security risk...
inb4: Security by Obscurity is not a valid security control ...
1
vote
2answers
29 views
Fail plan on a release to production with differential backup
I am currently looking into a fail plan when we do a release to our production server.
The context
Currently we have one single production database (also production and testing but they are not ...
0
votes
1answer
1k views
Mysql backup from ibdata1, ib_logfile1, ib_logfile0
I accidentally deleted my word press mysql DB. Below is the list of log files that i see in my directory where i am hoping i can get back some of my data.
I actually converted the first file ...
3
votes
1answer
174 views
failed with the following error: “Write on ”…bak" failed: 27(error not found) BACKUP DATABASE is terminating abnormally
This issue has been puzzling me for some time now and I'm running out of ideas! Any help would be much appreciated! Here's the problem:
MS SQL Server 2008 running on Windows Server 2008R2 ...
3
votes
1answer
190 views
How to take pg_dump of a very large postgres database?
I have a production database server running Postgres 8.4 on Cent OS 6.5.The volume of data has increased recently and within few one month database now has 18500 tables amounting to approx 350GB ...
0
votes
1answer
41 views
synchronizing local and server database
I am developing a billing system software. For this I have created a database it contains many tables database and this is in local system
all transactions data will be stored in local systems ...
1
vote
1answer
89 views
db2ckbkp - How to determine what tablespaces are temp-tablespace
I am writing a script to restore databases from backup. The script should need as little input as possible to fulfill this task (in an efficient way). The restore command takes the parallelism ...
4
votes
1answer
653 views
SQL Server backup fails on disk space error
SQL Server 2008 R2 RTM running on Windows 2008 64bit.
Having problems backing up a single database with the following command
backup database [somedatabase]
to disk = ...
4
votes
3answers
180 views
Backup SQL Server with a system backup
I have installed a Microsoft SQL Server 2012 on a server that also are used as a file server. Each day the server is automatic backed up with Acronis Backup & Recovery to a USB-disc that we switch ...
1
vote
2answers
87 views
Information on a Database that was restored with NO RECOVERY
I'm working with SQL Server 2008Sp3.
I have a database that was restored from a full backup WITH NO RECOVERY and it then was restored with Transaction log backup files - also WITH NO RECOVERY.
At ...
9
votes
2answers
521 views
SQL Server transaction log backups: test whether tail log follows last known log backup
We are using SQL Server with full recovery mode. Given a full backup and a series of log backups, we would like to be able to check whether the log chain is complete from the last full backup to the ...
2
votes
2answers
807 views
Transaction log has grown huge after maintenance plan to rebuild idex
A couple of days ago I was testing some stuff using the Maintenance Plans in SQL Server 2008.
I created one to rebuild indexes and take a full backup every week. (I know, bad thing I've found out ...
2
votes
1answer
290 views
I need help understanding Postgres's archive cleanup functionality
I'm reading http://www.postgresql.org/docs/9.2/static/pgarchivecleanup.html and to me it seems like it will remove any and all WAL segments from my slave server that aren't required to perform ...
0
votes
2answers
791 views
What is the most effective way to compress and store a SQL Server backup? [closed]
I've been doing some testing of different methods for compressing and storing SQL Server backups (using SQL Server 2008 R2 Enterprise edition), and I'm wondering what the most effective compression ...
1
vote
0answers
248 views
Is it possible to use 'restore UNTIL SCN' with rman and Oracle 9i in NOCATALOG mode?
I'm trying to do a hot backup with rman that I can copy to a USB drive so I can recover it on a new server.
The backup was done two days ago and the restore database command was working on the same ...
3
votes
2answers
4k views
How to backup IBM DB2 Database online?
I tried to backup the IBM DB2 (LUW) Database using this command:
./db2 backup database DBEMP to /home/user1/db2bkup
But I got this message:
SQL1035N The database is currently in use. ...
-1
votes
2answers
245 views
How do I connect to a database with a blank password using a shell script?
## connect to mysql and source backup file ##
USER="root"
PASS=""
mysql -u$USER -p$PASS database_name < backup.sql
Above is my shell script which I used to source database but still its asking ...
0
votes
1answer
416 views
Is it possible to pipe the result of a mysqldump straight to rsync as the source argument?
Is it possible to pipe the result of a mysqldump straight to rsync as the source argument?
Conceptually, I was thinking something like:
mysqldump -u root -p database_to_backup > ...
5
votes
1answer
892 views
How can I fix “Cannot perform a differential backup … a current database backup doesn't exist”?
We recently switched to the FULL recovery model, with full backups being done every weekend, and differentials being taken every day.
The problem is, the differential backups don't always seem to ...
4
votes
2answers
263 views
Can I manually reset the “internal status flag for a full database backup”?
We recently switched to the FULL recovery model, with full backups being done every weekend, and differentials being taken every day.
This worked last weekend, however this weekend the differential ...
3
votes
2answers
718 views
Is it OK to use WITH INIT for my Transaction Log Backup to avoid having it grow too large?
I'm still struggling to understand SQL's backup jobs.
We currently have a SQL Server 2005 instance using the FULL recovery model.
We do a full database backup every week.
BACKUP DATABASE ...
4
votes
2answers
745 views
SQL Server 2012 database backup successfully report but no backup file
I have created maintenance plan in SQL Server 2012. And every day, the maintenance plan should backup the database. There is no database backup file when I look in the folder where the backups must ...
