Database restoring refers to the concept of restore a database from a backup or a copy.

learn more… | top users | synonyms

1
vote
3answers
1k views

SQL Server mirrored database is stuck in recovery mode

I have a database that is stuck in recovery mode for few days already. There are multiple threads about this, but the solutions there don't work for me. Here is what I tried already: RESTORE ...
4
votes
1answer
451 views

SQL Server 2008 R2 Restore constantly hanging

I have a SQL Server 2008 R2 SP2 test server that I have to refresh the databases on fairly often, but every time I have to do a restore on, it will hang on me. I use a custom script to check the ...
1
vote
1answer
49 views

Restore a WordPress database from .frm and .idb only

I had a WordPress website running a long while ago. I used WAMP server. Then, I uninstalled WAMP. Today I would like to work again on my website; all that remains of my database is this (I cannot find ...
1
vote
1answer
882 views

Extremely slow mySql restores

Please bear with me as I ask this question, which looks similar to questions already on DBA@SE. In the current configuration, we have a server (a Linux quadcore box with 4 GB RAM) - Both the Database ...
0
votes
1answer
73 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 ...
0
votes
1answer
332 views

Table is marked as crashed and should be repaired

I have MySQL and Nagios installed Linux PC (Centos5.5) I have wrote some script to fetch the data from Nagios to Mysql DB (Exactly fetch data in Table) The data fetching working properly (confirmed ...
1
vote
0answers
34 views

Pg_restore table size differences

What would account for the difference in table sizes between one PostgreSQL database and another restored from its dump file? On an Ubuntu 12.04 host, I'm running PostgreSQL 9.1, and I dumped my ...
1
vote
0answers
44 views

Restoring a database to a point in time: Database I want not showing up in dropdown list

I want to restore to a point in time from a database that is already attached. When I try to do this using SMSS I cannot find the database I want in the dropdown list, but oddly it has a couple ...
0
votes
0answers
18 views

mysql restoration suddenly became slow

Recently I reinstalled couple of servers from Ubuntu to RHEL. I was having problems in restoring the mysql database from the dump file. I modified the below parameters in the /etc/my.cnf file. ...
0
votes
0answers
25 views

Restoring Cassandra fails

I try to restore a Cassandra table from snapshot , but when i try to see the result the query give me a rpc_timeout so i tried to see the log files java.lang.RuntimeException: ...
0
votes
0answers
31 views

RDS did not restore to a specific point-of-time on my MySQL instance. Why did that happen?

I'm using a MySQL 5.6.13 instance on RDS and accidentally wiped all the data in it (something like 2.5GB). I used the restore to point-in-time feature to recover all the data and it only recovered the ...
0
votes
0answers
91 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 ...
0
votes
0answers
21 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
254 views

how to restore sqlite dump file to sqlite database using java?

I generated dump file from java using .dump command so my back-up is ready now I want to restore it to once again so can anyone help me how to restore? In stackoverflow I got this but nothing restore ...
0
votes
0answers
54 views

Accidentally I had deleted a database from production server working with MySQL

I have its backup as a full and an incremental backup took using enterprise backup. Is it possible to restore a specific database or else what should I do as an immediate action?
0
votes
0answers
43 views

Jobs owner schema has been changed after restore database using oracle expdp and impdb

I have taken oracle database full backup using expdp utility from 32 bit linux server. Then I have restored this full backup in 64 bit linux server and it was successfully restored. The problem what ...
0
votes
0answers
521 views

Sybase ASA 9 Central exception on connecting to old database

I have installed sybase ASA 9 i used the sybase central to connect to an old version .db file of ASA version 6, a wizard popup and ask yes or no to unload the database .. for upgrade i click yes ...