Database restoring refers to the concept of restore a database from a backup or a copy.
-4
votes
1answer
39 views
Oracle database and data has been corrupted. Is there a way to get it back? [closed]
The Oracle database has been corrupted and both the data and backups were lost in the corruption. Is there anything I can do to recover my data? It would be terrible if it were all lost.
1
vote
1answer
102 views
How to recover/restore corrupted Innodb data files?
A while ago, my Windows 7 system on which a MySQL Server 5.5.31 was running crashed and corrupted the InnoDB database. The weekly backup that's available does not cover all the tables that were ...
0
votes
2answers
53 views
Can I find out what version of MySQL from the data files?
I have a very odd situation going on here. I had a linux box running ubuntu 8.10 and MySQL server with a Wordpress installation on it hosting an internal blog for our company. The machine that this ...
1
vote
2answers
49 views
“Rewinding” a Postgresql database
I have heard that Postgresql uses an append-only format for it's databases, and if this is true I should be able to 'rewind' the database to a previous point in time by removing the commits that came ...
1
vote
3answers
61 views
Proper way to export database to other servers
I am using SSMS (I am a software developer, not a DBA) and in each application release I need to release the database with its tables (some with data some with scheme only).
I tried doing 3 things ...
2
votes
2answers
583 views
media family on device is incorrectly formed. SQL Server cannot process this media family
I am trying to restore a .BAK in SQL server but get the following error:
Msg 3241, Level 16, State 7, Line 1 The media family on device 'c:\glyn\JA.bak' is incorrectly formed. SQL Server cannot ...
0
votes
1answer
100 views
Restoring a differential backup in SQL server 2005
I have created a full back up of my database by executing the line below in my application:
Dim Query As String = "backup database Ari to disk='G:\Documents and Settings\i\Desktop\BKAR\" & ...
2
votes
2answers
116 views
Disaster recovery plan - Having multiple servers
I work in an organization where departments are in different buildings. I have a data centre in the main building. All the in-house applications connect to the SQL Server residing in the server in the ...
1
vote
2answers
101 views
Database Is In InRecovery Mode.
I have a database that has entered "Recovery Mode". It was working fine, but ended up in this status a few days ago.
I have been told that a cause can be the partition holding the datafiles running ...
3
votes
0answers
155 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 ...
2
votes
1answer
190 views
Restore InnoDB tables / database using only data files
I have MySQL Server 5.1.51 installed on Windows Server 2003 as Operating System and using InnoDB as database engine.
I have run DROP DATABASE dbName statement by mistake. I have no backup of that ...
6
votes
1answer
470 views
Timeout expired error while using copy database wizard
Microsoft made me believe that SQL Server 2012 Copy Database Wizard is the most optimal way of copying a SQL Server 2000 database to SQL Server 2012. After struggling a few hours, I was able to get ...
2
votes
3answers
2k views
Why is my database stuck in the Restoring state?
I have some unit tests that manipulates data in a database. In order to guarantee that the database state is always the same throughout all the tests, we're trying restore a database snapshot at the ...
1
vote
1answer
263 views
SQL Server: Simple database restore with overwrite
What I'm trying to do is backup one of our production databases and restore them as our dev database (overwriting what's been there).
That's how I back up:
backup database [authfx] to disk = ...
0
votes
0answers
279 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 ...
2
votes
1answer
124 views
How are foreign keys resolved when creating tables in batch?
I am creating a database version management tool with the goal of being able to recreate a database from scratch using text/sql files contained in source control. As part of establishing a baseline ...
2
votes
1answer
307 views
Ensure correct username when using pg_restore
I have just installed postgres 9.1.6 on a local Ubuntu server. Now I'm trying to restore a database dump from a database on Heroku. The local database is setup like this:
sudo -u postgres psql -c ...
5
votes
1answer
90 views
Can We Perform an “Up-To-The-Minute Restore” After Taking Transaction Log Backups?
The Setup:
Say we have a Database in Full Recovery Mode that does a nightly Database Backup, Transaction Log Backup, and Transaction Log Shrink.
Now the Transaction Log grows so quickly during the ...
1
vote
1answer
939 views
disable constraints before using pg_restore.exe
When I try to execute pg_restore.exe of a dump file from a database, it throws dozens of errors, all the same:
ERROR: insert or update on table "someTable" violates foreign key constraint ...
0
votes
1answer
195 views
Drop and restore PostgresSQL database without losing settings
This seems like a simple, easy question, but I'm very new to PostgreSQL administration and I'm not sure of the best way to do things. I have a PostgreSQL (9.1) database that somehow got corrupted ...
0
votes
1answer
124 views
while restoring mysql database, views changed into tables
I have a full database dump and i restored it. But in my new restored server all the views are appeared as MyISAM tables. In early times dumps were restored perfectly. can anyone help me to trigger ...
1
vote
1answer
899 views
Full and differential restore with two backup files - SQL Server 2008
We are trying to establish a maintenance plan with 2 separate backups.
One full backup over the weekend and differential backups through the week. [the differential backup has a "_diff" appended to ...
1
vote
1answer
388 views
ERROR 1100 (HY000) at line 11084: Table 'search_index' was not locked with LOCK TABLES
I'm trying to import a mysqldump backup of a drupal database taken from a server running MySQL 5.0 (which will be upgraded to 5.5) onto my local machine running MySQL 5.5.23. The import fails with the ...
1
vote
0answers
55 views
SQL Server Database Size much higher than the backup size after restore [duplicate]
Possible Duplicate:
Why is a .bak so much smaller than the database it's a backup of?
The database backup size is around 120 MB but when I run Restore FileListOnly, I see that the data ...
6
votes
2answers
139 views
Automation of backups of Large Number of Database
In a multi-tenant web application where a database is set up for each tenant, the database can be backed up and restored manually through a fairly conventional approach.
I am considering this type of ...
2
votes
2answers
61 views
Data Backup and Restoring the same if requried in SQL SERVER 2008
In Multi-tenancy , Shared Database Shared Schema.
How to take Tenant level backup and restored the tenant data when required? Can any one guide me or point me to the right direction.
Thanks!!!
NB: ...
2
votes
1answer
242 views
Correcting the imported latin1 data to be utf8
I restored my drupal site database from a backup but after i finished i discovered that the Imported data was symbols like this قوانينكرة because the backup was taken using latin1 charset ...
1
vote
1answer
581 views
Solution to error NID-00135 in Oracle 10g, Solaris 10
We are trying to build a test version of a production database by restoring the production backup using RMAN and renaming the database to test.
We've successfully restored and opened the database ...
3
votes
2answers
465 views
SQL Server Restore DB from MDF file, lost LDF and DB was not cleanly shutdown
My dev DB server was formatted by some admin without my knowledge. Thankfully I had mdf file kept in some other drive but ldf was in its default location. Since I don’t have DB backup I am now left ...
0
votes
0answers
70 views
Database Design Concern [closed]
Need to design a multi-tenant web application, using single application multiple database setup.
![Image][1]
https://plus.google.com/photos/104702944930754413137/albums/5725683632435430785
2
votes
2answers
561 views
SQL Server: in what situation can snapshot restore be blocked after SET SINGLE_USER?
In my tests, i have the following script:
USE master;
ALTER DATABASE [TestDB] SET SINGLE_USER WITH ROLLBACK IMMEDIATE
RESTORE DATABASE [TestDB] FROM DATABASE_SNAPSHOT = 'TestDBSnapshot'
In some ...
1
vote
2answers
450 views
Move (Restore) SQL Server 2005 database which does not exist before
I did not ready about this but found out after trying to restore a database from remote server and it wont restore if the database did not exist before. What I would do is
create a .bak file ...
0
votes
0answers
156 views
How do I restore a SQL backup, while excluding a specific table?
How do I exclude a specific table during a SQL backup RESTORE operation?
My question is specific to restoring a backup sql file.
I am using Putty and bash server.
2
votes
2answers
253 views
Looking for a way of moving millions of record without impacting the transaction log
I need to move around 10 million records out of a table into a new "optimized" table, but I need to keep the database online. What would be the best method in doing this without impacting the ...
0
votes
3answers
401 views
SQL Server restore sequence from multiple full, diff and log backups
Suppose I have a lot of backups (may include full, differential and log backups) of a SQL Server database. I want to write a program that can generate a SQL script to take the database to its most ...
1
vote
2answers
572 views
Move an Oracle database by moving the raw data files
I have a large Oracle database (~300 GB) and I need to move a copy of the database to a new environment in a short period of time. I was wondering if there is a way to just pick up the raw files ...
3
votes
1answer
241 views
How can I restore SQL Server database to a custom location, if the backup file was renamed?
Suppose I have an SQL Server database called bubu and the respective backup file is bubu.bak.
If I want to restore it with the backing store in a custom location, I use the following T-SQL statement:
...
3
votes
1answer
953 views
MySQL Restore Large Dump
I have a dump file of a single table which is 7GB. I try to restore it using
mysql -u root -p DB_NAME < .SQL FILE
But I don't see any activities in task manager. CPU is 00 and RAM is 5,700 K. I ...
1
vote
1answer
79 views
mysql server password change while restoring
I restored all database backup from another server's dumpfile to my machine. At the end my mysql server's password changed to that mysql server's password. Why it got overwritten? What i need to do to ...
3
votes
3answers
4k views
Restore mysql database with different name
Hello Experts,
How can we restore mysql database with different name from mysqldump file.
I dont't want to open dump file and edit it. Any other better methods.?
regards,
Praveen
2
votes
1answer
375 views
BACKUP and RESTORE MySQL Database
I have very specific question.
I have seen the instructions on how to backup and restore mysql database using SSH but they barely explain the process when backing up on one server and restoring on ...
2
votes
1answer
253 views
Error When Restoring Log
Here is the situation. I have restored a database to replace an existing version (need to get it back to yesterday at a certain time). So I do a RESTORE DATABASE ... WITH NORECOVERY, REPLACE, etc... ...
1
vote
2answers
1k views
Database after restore process still display Restoring
I restored Database from Backup File (in Management Studio) and after restore, Database showed Restoring, then I deleted files from disk (engine's stopped), then I tried Restore again with success, on ...
3
votes
1answer
1k views
Restore dropped mysql database
I create a database each year from the previous year, back up and then clean up the tables. So I have databases for the past 3 years.
This year I did not do a backup and accidentally dropped the ...
2
votes
1answer
535 views
Error restoring SQL differential database files
Occasionally I'm having problems restoring DB differentials. I'm getting the error "the differential backup cannot be restored because the database has not been restored to correct earlier state." ...
3
votes
3answers
405 views
How and what do you backup for a simple Oracle DB?
Background:
I am in the following situation: We have a JIRA instance running on a dedicated server machine (Windows Server). It uses Oracle XE to store all the data. The JIRA instance and a Oracle ...
5
votes
4answers
10k views
Restoring a backup to an older version of SQL Server
When trying to restore a backup to a SQL Server Express 2008 database I got the following error:
Restore failed for Server '...\SQLEXPRESS'. (Microsoft.SqlServer.SmoExtended)
...
2
votes
2answers
1k views
Oracle Restore and recover Database on the same host?
I have DB1 database on Server1 .
I have taken backup.
After that I have created table TEST.
Inserted some values in the TEST table.
Truncated table.
And want to return my TEST table to its previous ...
2
votes
4answers
2k views
SQL Server: cold backup, shutting down services?
One of our collagues told me that they are doing "cold" backups for SQL Server so that they are shutting down services and then taking a backup somehow. I think this is all wrong! Am I right? I think ...
12
votes
3answers
1k views
Is it possible to quickly create/restore database snapshots with PostgreSQL?
First of all, I'm a developer, not a DBA or sysadmin; please be gentle :)
I'm working on an application workflow where a single user action will trigger complex changes in the database - creating ...
