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

learn more… | top users | synonyms

0
votes
2answers
277 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
143 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 ...
4
votes
1answer
446 views

Why can't I read my transaction log backup file using fn_dump_dblog?

I'm using this blog on sqlskills.com as a guide to practice finding the relevant LSN in a transaction log backup for point in time recovery. After backing up the transaction log, I attempt to read it ...
1
vote
1answer
176 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 ...
1
vote
1answer
73 views

Restoring full and differential backups from production to a report server

Running this SQL query: RESTORE DATABASE Demo FROM DISK = 'C:\DBBackup\Demo_FULL_Sunday.bak' WITH NORECOVERY RESTORE DATABASE Demo FROM DISK = 'C:\DBBackup\Demo_Diff_Monday.bak' ...
0
votes
1answer
35 views

restoring Postgres dump with tablespaces

I'm trying to restore a dump done with pg_dumpall > mybak.sql from a server that has 1 table in a different tablespace that the default one. On the target machine I have recreated the directory ...
0
votes
1answer
49 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
0answers
23 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
36 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
8 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
15 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
40 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
18 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
181 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
45 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
37 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
168 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 ...
0
votes
0answers
453 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 ...