Database restoring refers to the concept of restore a database from a backup or a copy. The database needs to be off-line in order to be restored. Questions having the database-restoring tag refers to the activity to restore a database.
0
votes
0answers
15 views
Not all the table in mysql show in phpadmin
I recently accidently dropped my whole database for Wordpress, but luckily I had backed it up with Time Machine.
The problem now is when I copy the database file back to the path where I store the ...
8
votes
2answers
83 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
33 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
63 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
50 views
Solution to error NID-00135 in Oracle 10g, Solaris 10
Been scouring around for a comprehensive explanation/answer to this error. We are trying to build a test version of the production database by restoring the prod backup using RMAN and renaming the db ...
3
votes
1answer
119 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
61 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
69 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
100 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
46 views
Restore sql backup excluding specific table
Can anyone tell me how to exclude specific table from sql backup restoration?
My question is specific to restoring a backup sql file.
I am using Putty program and bash server.
tks
2
votes
2answers
71 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
155 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
123 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
92 views
How can I restore sqlserver database to a custom location, if the backup file was renamed?
Suppose I have an SqlServer database named bubu and the respective backup file is bubu.bak.
If I want to restore it with the backing store in a custom location, I do the following T-SQL statement:
...
2
votes
1answer
149 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 ...
