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
123 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 ...
0
votes
2answers
262 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
531 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
79 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
88 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
50 views
How do I refresh SQL server cross database references after a database is reattached with a different name? (Are there hidden synonyms?)
I have 2 seperate SQL databases on the same SQL instance. Database1 references tables on Database2 in its views and stored procedures. Everything was working fine until we had to create a fresh ...
1
vote
1answer
168 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
19 views
OK to put temp tablespace on volatile storage or to omit it from backups? (Postgresql)
I would intuit that it's fine, but I just want to make sure there are
no gotchas from a recovery point of view:
If I were to lose my temp tablespace upon system crash, would this
prevent proper crash ...
0
votes
1answer
27 views
SQL server dataloss restore
I have done an incorrect update in my DB and hence I restored the DB with a backup from the previous day. I have not taken a copy of the corrupted data before restoring the backup. Is there any ...
0
votes
1answer
33 views
PostgreSQL backup error
I am trying to backup my company PostgreSQL database using pgAdmin III, so I selected our company DB from the tree, then right clicked on it and selected 'Backup', selected the destination folder ...
0
votes
1answer
69 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
129 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
532 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
120 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
48 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
92 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
35 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
438 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
158 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
58 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
16 views
Backing up file groups with restore to earlier backup SQL Server 2008
I have a task: I have created a database with a filegroup lamb that has a few tables
I need to extract a csv into a table in a file group named lamb and backup file group lamb
Then extract another ...
1
vote
0answers
55 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
159 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
20 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
27 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 ...
0
votes
0answers
53 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
54 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
103 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
65 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
19 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
131 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
193 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 ...
