Making copies of data which may be restored after a data loss event or to recover data from some earlier point in time.
0
votes
2answers
388 views
How to increase fast backup and restore of 500GB database using mysqldump?
There is a database A size of 500GB. Tables in database A contains both MyISAM and INNODB tables. MyISAM tables are master tables and Innodb tables are main transaction tables.
Backup and restore ...
13
votes
1answer
549 views
Sql Anywhere 11: Restoring incremental backup failure
We want to create remote incremental backups after a full backup. This will allow us to restore in the event of a failure and bring up another machine with as close to real time backups as possible ...
4
votes
1answer
100 views
Process attempted to unlock a resource it does not own
SQL Server 2005 SP4 32-Bit
I have a DBCC CHECKDB job running nightly. Last night, soon after the job started, I got the errors below. The database is NOT in suspect mode, and CHECKDB comes back clean ...
2
votes
1answer
109 views
Backing up a 400-500 GB database on MySQL/Amazon RDS?
We have an Amazon RDS small instance for a MySQL datawarehousing database.
Database size will be around 400-500 GB very shortly.
What is the best way to backup our database?
Can it be done ...
1
vote
1answer
39 views
MongoDB: move documents before capping
The cappedCollection concept works well for most of my projects where cleaning old data without care makes sense.
For another projects, I need a more complex and safe concept. The requirement is ...
1
vote
1answer
149 views
MySQL backup InnoDB
I have a VoIP server running 24x7. At low peak hour at lease 150+ users are connected. My server has MySQL running with InnoDB engine on Windows 2008 platform. I like to take at least 2 times full ...
1
vote
1answer
186 views
How to run a cold backup with Linux/tar without shutting down MySQL slave?
I run the following before tar-ing up the data directory:
STOP SLAVE;
FLUSH TABLES WITH READ LOCK;
FLUSH LOGS;
However, tar will sometimes complain that the ibdata* and ib_logfiles* files are ...
0
votes
1answer
90 views
Backup plan for MySQL NDB cluster databse not innoDB
I have a Database which will grow more than 250GB all data is in NDB engine(2 datanodes) and no other mysql engine used for data store.
What are the best approaches or plans for MySQL Cluster NDB ...
0
votes
1answer
145 views
mysql duplicate entry error 1062 when restoring backup
Sorry, I seen similar threads but I still couldn't find it addressing my issue plus, I needed some more info on this.
Requirement: To create an exact replica 'db4' of an existing DB 'db3'.
Procedure ...
0
votes
1answer
609 views
Restore SQL Server database using Windows Powershell 3.0
I'm trying to restore a SQL Server database with a PowerShell script, but I'm having problems.
Here is the error I'm getting:
Exception calling "SqlRestore" with "1" argument(s): "Restore failed
...
0
votes
1answer
129 views
Is there a way to export Oracle's UNDO?
I tried exp utility to dump all database. Looks like this exports only the last version of data skipping undo log. Using flashback queries I see:
01466. 00000 - "unable to read data - table ...
-1
votes
1answer
58 views
In the domain of SQL Server backup, what is a backup set, backup device, backup media, backup media set, backup media family
I'm not a native English speaker and I've read the descriptions in BOL but still can't understand what exactly are they. Can anyone explain in an easy understand way?
Thanks.
3
votes
0answers
96 views
What are the best practices for backing up a secured SQL Server 2012?
I want to state right off the bat that I'm not looking for information on how to backup a SQL Server. I've got that taken care of.
I'm looking for some form of documentation that will tell me the ...
2
votes
0answers
38 views
Is it possible to have a valid backupset with null position?
In database restore process I need to rely on position column exists in backupset record to restore the latest backupset.
Restore the latest backup on the database
I noticed sometimes position is ...
2
votes
0answers
661 views
Error 9001, Severity: 21, State: 1 The log for database 'DB_NAME' is not available
I have a SQL Server 2008 R2.
I got a mail that the backup had failed, I opened the SQL log viewer and started browsing.
And i found these two errors a bunch of times.
error 1:
Date ...
2
votes
0answers
178 views
Restore database from multiple .bak files
I have a bunch of .bak files used as a DB dump for SQL server.
Each one of them is part of the backup (media set families?).
I need to import/restore them. Just to emphasize, the need is load the data ...
2
votes
0answers
60 views
How to display differential backup date in SSMS Object Explorer Details
SQL Server Management Studio exposes the Object Explorer Details (selectable from the View menu option) and its context menu that allows adding fields to the default display.
Full and Transaction Log ...
1
vote
0answers
18 views
how to verify mysql backup file
Is There any tool to verify the backup taken using mysqldump without manual restoration ?
I have to take full backup daily so it is difficult for me to verify the backups daily by restoring them. As ...
1
vote
0answers
46 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 ...
1
vote
0answers
74 views
How to backup a running SQL Server CE database with full data?
I need to move my running windows-based app (built in C#) to another machine, but I also need to transfer the whole data, how can I take a backup from the .sdf file and use it with the new installed ...
1
vote
0answers
168 views
Cannot remove .bak file
I have a java application that:
Reads a .bak file from a windows fileshare and restores it in SQL Server on a remote windows server
Does various modifications on the database restored from the .bak ...
0
votes
0answers
33 views
Is it recommended to run a Oracle schema backup when there are active sessions?
I need to backup two schemas in a Production database (Oracle11gR2) that are being accessed by an application and some other systems. These schemas are quite small and exp will be used for the export.
...
0
votes
0answers
24 views
Rackspace Cloud Databases: incremental backup
Rackspace Cloud Databases are a little bit special in that we do not have access to the bin_log file, they are not servers in the traditional sense. I do have a couple of Cloud Servers with them but I ...
0
votes
0answers
24 views
'Offline' MySQL backup - server not starting
The MySQL server is no longer starting because the partition is too full. The issue seems to be ibdata (40GB). I wanted to follow these instructions (at 'InnoDB Infrastructure Cleanup')
Now I already ...
0
votes
0answers
28 views
Should I keep pg_xlog on the same disk as data if using disk snapshotting?
We're running on EBS volumes on EC2. We're interested in leveraging
EBS snapshotting for backups. However, does this mean we'd need to
ensure our pg_xlog is on the same EBS volume as our data?
(I ...
0
votes
0answers
60 views
Tape rotation strategies
I am trying to find a tape rotation strategy that would be optimal under the following conditions:
Backup Media Rotation strategy should support the following:
Media Archives required ...
0
votes
0answers
64 views
How to do point in time recovery of binary log files into .sql file
I have written a shell script to do an incremental backup of MySQL database.
For point in time recovery I'm using the binary logs generated in /var/lib/mysql directory.
For point-in-time recovery, Im ...
0
votes
0answers
114 views
Mysql Incremental Backup and point in time recovery
I'm writing a shell script using the concept of binary logs for point in time recovery.
Now, the scenario is such that a full-backup will happen every alternate day and Incremental backup should be ...
0
votes
0answers
69 views
Copying BLOB fields from a table on one server into corresponding fields in a corresponding table on a different server?
I have a database on a remote server whose BLOB fields are corrupted. I have fields in an earlier copy of the database which duplicate a portion of the corrupted data. I would like to overwrite the ...
0
votes
0answers
35 views
How can I backup Oracle with Listener error
On my server that I have installed Oracle, I encounter a
TNS Listener error and i couldn't connect Oracle.
Is it possible to backup database with Only my user and password, without listener?
0
votes
0answers
20 views
is there any strategy for back up the SharePoint Portal Server Farm?
We have many servers in our farm with SharePoint Portal Server and VSTS and Project Server. now we have up-to 100 DBs and back it up with STSADM.exe in schedule task.
But several of time this batch ...
0
votes
0answers
136 views
change database name controlfiles after restore?
I have restored database with the name DB to another database called DB01
it is in STARTED status (not mounted) and it seems I can not change the name if it is not mounts, and I can not mount it ...
0
votes
0answers
209 views
log 1 sequence# not archived, no available destinations
i'm facing a problem with my oracle 10.2.0 database
it's running on HP-UX 11.31
the problem is when ever i try to run
SQL> alter system archive log all;
it show that error
alter system archive log ...
