Questions tagged [database-restore]
The database-restore tag has no usage guidance.
80
questions
1
vote
1
answer
57
views
Restore an Azure SQL database while retaining backups
I'm trying to figure out how to restore a database using the Azure Portal without losing either point-in-time or long-term retention history.
My production database has both a point-in-time and a ...
- 13
0
votes
0
answers
46
views
Reinstalling server and SQL Server database
Due to some Windows issue, can't clean-up the WinSxS folder and the Disk Space process (cleanmgr.exe) makes the CPU going to 100% meaning that I am at 97% of disk usage, I am planning to reinstall the ...
- 123
0
votes
0
answers
92
views
Replicate AWS RDS Postgres instances
Faced a situation we need to consolidate few small postgres instances to a bigger one
Cant figure out how to replicate "old" db new data to "new" db when the replacement happens
...
- 125
0
votes
0
answers
39
views
Deleted everything from google cloud - Can it be recovered? [duplicate]
I recently deleted everything from my google cloud storage and need to know if there is a way to recover the data.
google-cloud-platform
0
votes
1
answer
3k
views
Restore MySQL database is very slow [duplicate]
I've just bought a new home desktop. I have three MySQL databases that I want to move across. I dumped them all using mysqldump before removing the drive from the old machine.
Restoring the largest of ...
- 117
3
votes
1
answer
390
views
Can I restore the SVN repository from the copy of the repository folder on the server?
The guy responsible for maintaining the SVN server was not having knowledge about the SVN server. Whenever he was told to take the backup of repository, He was just copying the folder of the ...
- 31
1
vote
1
answer
633
views
Azure SQL bacpac Restore Over Existing Database
I want to restore a bacpac file over an existing Azure SQL database using PowerShell. Past with experience with restoring bacpac files in Azure requires creating a new database altogether when ...
- 688
0
votes
3
answers
303
views
Transfer a bigger MySQL/MariaDB DB fast, save and restartable
I have to transfer a Drupal site with a 43GB MariaDB DB via ssh/scp to another server.
I have a limited downtime window early in the morning. In the past I transferred smaller DB's (<3GB) directly ...
- 179
0
votes
1
answer
2k
views
pg_restore with ssl parameters - how to specify parameters right way?
I have PostgreSQL 11 server with ssl-only connections (it's "Managed PostgreSQL" service by my cloud provider)
In documentation psql connection to this server should be like this:
psql "host=xxx.mdb....
- 169
0
votes
0
answers
310
views
copying back *.ibd files in mariadb
I have full MariaDB backup with this lost files with mariabackup --backup
They just removed by stored procedures from current instance.
How can I restored this file (history_log#P#p201712030000.ibd) ...
- 101
2
votes
2
answers
284
views
windows server backup. how to restore msssql database
it's theoretical question. If i have a window server 2012 r2 which have mssql server installed. I add role windows server backup.
So can restore the database which was backuped by windows server ...
- 33
0
votes
2
answers
1k
views
R1soft error "MySQL restore already occurring for running instance, cannot continue"
I am using R1soft backup tool on my server(cpanel) and trying to restore the database backup but it gives me the error "restore failed". Attaching logs error here:
Protected Machine: MySQL restore ...
1
vote
2
answers
2k
views
RDS Mysql point in time restore fails - incompatible state
I have an RDS MySQL instance with MySQL version 5.7.19 for which a point in time restore failed with a status of "incompatible-state".
Through experimentation I have determined that point in time ...
- 131
3
votes
0
answers
2k
views
Got a packet bigger than 'max_allowed_packet' bytes
MySQL Community-Server 5.6.39
RHEL7
Scenraio:
Trying to process binary logs to restore the incremental backup and receive max_allowed_packet error.
Turned off binary logs,restarted the database.
...
0
votes
1
answer
1k
views
Oracle 12c schema restore using impdp from a different server
I have created 2 EC2 instances in AWS.
One acts as DB Server and one acts as client.
Oracle 12c DB instance is installed on DB server and Oracle 12c instant client on client server.
I have ...
- 203
1
vote
2
answers
2k
views
Can't restore Google Cloud SQL instance
I'm trying to restore my Google Cloud SQL instance to a backup from a previous date:
gcloud sql backups restore 1504554300110 --restore-instance=[MY-DB-INSTANCE]
Ultimately, it keeps giving an error:...
0
votes
1
answer
1k
views
SQL 2012 Restore Issue - Exclusive Access cannot be obtained
Situation - We have a Live_db database, and a Test_db database. I'm trying to Take a copy of Live to use as Test.
A Backup of Live was taken.
The existing Test database was deleted (closing ...
- 113
4
votes
1
answer
897
views
Can I restore SQL databases from full Windows server backup if needed
I have scheduled backup and every day copies of:
bare metal recovery
system state
system reserved
local disk C:\
Backup is stored on iscsi disk. On local disk C are databases mdf with logs. In ...
- 45
0
votes
1
answer
59
views
Oracle RMAN full backup due to gaps in ARCHIVE LOGs
I've recently recovered a Data Guard configuration. Simple setup that syncs from primary to standby using Data Guard.
Because it's been on-line for a sustained period, some logs are missing and I ...
- 151
-1
votes
2
answers
1k
views
restored Wordpress site from DB, wp-login.php redirects to old domain
We have a Wordpress .sql backup which we restored on a linux box. Now we want to log in to the admin console and export the site as XML.
Unfortunately, the wp-login.php redirects to the old ...
- 33
3
votes
1
answer
11k
views
Recover mysql database innodb 'table doesn't exist'
Our server crashed last week and we lost a lot of information. We were able to recover .frm files for the tables, ib_logfile0, ib_logfile1 and ibdata1 but no .ibd.
I've tried the innodb-force-...
- 81
0
votes
2
answers
1k
views
Restore deleted exchange 2007 public folder from backup .edb file
We are running a stand-alone instance of Exchange 2007 without replication of any kind. We do have nightly backups. A user deleted a public folder, and I need to restore that from one of our full ...
- 9
0
votes
3
answers
19k
views
Restore SQL Database From BAK File using a SQL Query
I have my database backing up to the hard disk in the format of BAK file. I am trying to restore that backup, but I unable to do so.
Here is my query:
ALTER DATABASE DBASE
SET SINGLE_USER WITH
...
- 417
1
vote
1
answer
105
views
Why does SSMS Restore Database to another database not copy the current state of the "From" database?
When copying a database by using the Restore Database functionality in SSMS, why is it not a copy of the current state of the Database? After performing the Restore From Database Bar to Database Foo, ...
- 169
1
vote
1
answer
1k
views
How can I restore an Exchange 2010 mailbox to its original state after the mailbox has been deleted?
In our environment we are running Exchange 2010 with NetBackup 7 and Symantec eVault. We have global 25 year retention and no purging policies (insane, but that's what the boss wants). We use eVault ...
- 890
4
votes
1
answer
5k
views
MSSQL: Restore a DB to the latest file in a backup set
I have a MSSQL 2008R2 DB in SIMPLE recovery mode that is periodically backed up with
BACKUP DATABASE MyDB to DISK = 'Z:\MyDB.cbak' WITH COMPRESSION
This runs periodically, creating multiple ...
- 6,956
0
votes
1
answer
287
views
Can you restore multiple Oracle databases with the same tablespace name?
I am in the process of setting up an Oracle instance for customer database restores.
The vast majority of our customers use the same tablespace name for their databases, which leads to us needing a ...
1
vote
1
answer
3k
views
No file access permissions after restoring database
I restored an SQL-Server 2012 database to a folder on my D-Drive. I can access the database and everything seems to work, but when I check the file access permissions of the mdf and ldf files, there ...
- 11
0
votes
0
answers
154
views
no access to preivous databases in mysql56 after password reset, but showing in data folder
i had problem with mysql (windows machine, mysql5.6) login because of power failure, after trying various solution, i did password reset for root. This helped me to login mysql using root account. But ...
- 101
3
votes
4
answers
4k
views
mongorestore from stdin
On a remote server I have a file which is the mongodump output compressed, let me say a file called mongodb.tar.gz.
Inside mongodb.tar.gz there is a directory structure like this:
dump/dbname/
dump/...
- 323
1
vote
2
answers
226
views
MySQL transfer from backups
I had a server die and I have been trying to restore the data onto a new server. I had a mysql database.
I have all the files stored in /var/lib/mysql. Each database had a database privileges ...
- 115
2
votes
1
answer
2k
views
MySQL ZRM restore failed with mysql error unknown command \0
I am restoring an incremental backup with ZRM server on mysql database. I am having blob data in the tables. The incremental backup not getting restored and giving mysql error unknown command '\0'.
...
- 31
0
votes
1
answer
265
views
Recovering InnoDB
Bit of tough situation. Running MySQL 5.5 on Ubuntu 12.04. Looking to add some functionality to our internal site, I installed Kaltura. In doing so, my existing MySQL databases seemed to lose all ...
- 1
6
votes
2
answers
39k
views
Recover mysql database - mysql/mysqldump gives "table <database>.<tablename> doesn't exist (1146)"
Backstory
Ubuntu died (wouldn't boot) and I couldn't fix it. I booted a live cd to recover the important stuff and saved it to my NAS. One of the things I backed up was /var/lib/mysql.
Reinstalled ...
- 273
4
votes
1
answer
828
views
MS SQL Server DB version without restoring?
Is there a way of telling which version of Microsoft SQL Server a database backup is from without restoring it?
- 989
2
votes
2
answers
12k
views
Recover MySQL tables from frm files
I'm desperate, and hoping some kind soul can rescue me! I'm dealing with restoring a completely crashed server. Everything is back up except for there's an issue with one domain which uses MySQL (no ...
- 175
2
votes
1
answer
928
views
Recovering/Rebuilding MySQL .FRM, .MY* files from IBDATA1
I recently had an incident in which several MySQL files were wiped out (mostly from WordPress, but also a few of MySQL’s own files). The IBDATA1 file is unaffected, but several .frm are gone as are a ...
- 948
0
votes
1
answer
232
views
PostgreSQL 9.1 won't restore because "a user is connected"
I'm transferring a database as part of transferring a website. I've not used PostgreSQL before, so assume that I don't know much about it (I primarily use MySQL). We cannot directly connect the ...
- 572
0
votes
1
answer
255
views
selectively import "record sets" from one mysql instance to another
I have a mysql server hosting a production database, and routinely I make snapshots of it, which we can also use as a staging environment.
Sometime bad things happen, e.g. we delete a row (and all ...
- 125
2
votes
1
answer
4k
views
Restore SQL Server 2008 db without affecting users
When I restore a db in Sql Server 2008 R2 from data on another server, it makes a mess of the users. I have a Windows User and MsSql Login named Web_SqlA on both machines. Before the Restore, Web_SqlA ...
- 469
2
votes
1
answer
73
views
Copy a database from Denali CPT3 to SQL 2008 R2
Ok, officially this one is messing with my head. I had the worst idea to try out the SQL server Denali CPT3 when it came out on our development environment. And it seemed ok so we used and gathered a ...
- 157
2
votes
2
answers
450
views
Hosting server's harddisk crashed [closed]
My hosting provider has told me that the server harddisk that I am currently using is crashed and they failed to recover most of the data and they only managed to recover some files or folder from the ...
- 123
1
vote
3
answers
1k
views
Restore MySQL Databases from File backups, not MySQL Export
I've got a Windows Server and I get Windows Server Backup to backup all the files every day. I don't however have a system image so I cannot use that.
I've tried just copying the database files into ...
- 61
3
votes
1
answer
149
views
SQL Server backups - transferring between instances
I work in a development shop where we primary use SQL Server for our day-to-day development and testing.
Sometimes issues occur on someone's machine, often a labtop, that I would like to reproduce on ...
- 197
3
votes
3
answers
16k
views
How to restore a file system level copy of a PostgreSQL database (not dump) to a different PC
I am new to PostgreSQL. I have to recover a database which was running in widows XP machine.
I have the zip folder of postgres.
I have extracted postgres installation in a different PC and started a ...
- 33
1
vote
3
answers
2k
views
What's the most efficient way to reclaim disk space after deleting lots of data from a database on Sybase ASE 15?
As I understand it, based on some research but zero real-world experience with Sybase ASE, the only way to reclaim disk space once it's been allocated to a database is to export that database, create ...
0
votes
1
answer
5k
views
How do I restore MySQL .frm .MYD .MYI files in OS X Lion [duplicate]
Possible Duplicate:
How to restore mysql database from the physical files?
I received a bunch of these types of files and haven't a clue as how to restore the database on my Mac. I've found ...
2
votes
2
answers
127
views
Restoring a SQL database in a production environment as an update mechanism
I'm a sysadmin who has recently been landed with some SQL DBA responsibility. Not reluctantly I might add, this is a world I'm very much looking to get immersed in.
I am curious about one of the ...
- 86
1
vote
1
answer
125
views
Remote restore of DB in MSSQL 2008
I have a remote MSSQL server meant to centralize SQL for development projects. I hand out DB's and access to developers as they need it. I do not want to give them access to filesystem in any way (...
- 674
2
votes
0
answers
190
views
Exchange 2003 / 2010 Public Folder Restore or Sync Tool needed
What tools exist to restore public folder data?
If nothing will assist in (exmerging) PF data, what tools exist to sync data between backup sets?... between forests?
It seems that pfdavadmin was ...
- 8,921
Related Tags
mysql × 25
sql-server × 20
database × 12
database-backup × 10
restore × 8
sql-server-2008 × 8
backup × 7
windows × 5
postgresql × 4
innodb × 4
oracle × 3
sql × 3
sql-server-2005 × 3
azure-sql × 2
data-recovery × 2
exchange-2003 × 2
exchange-2010 × 2
mariadb × 2
linux × 2
oracle-11g × 2
more related tags
Hot Network Questions
- The interplanetary cold war
- Table stability
- PhD Advisor Slander to Postdoc PI
- How does Einstein's paper on Brownian motion actually prove atoms exist?
- What do these clearances by Heathrow Director mean?
- By implementing/By having implemented new technologies, the company is going to generate more revenue. - differences in meaning
- DateSelect : columnwise selection applied to a matrix
- How did early computers deal with calculations involving pounds, shillings, and pence?
- "XXXX it is, then" with plural nouns?
- Best way to join two timber rafters at the apex?
- Is there an increase in whale deaths due to windfarms?
- Complement an infinite list
- Wiring from meter to panel over longer distances
- ValueError: count not convert string to float
- Do the Einstein Field Equations force the metric to be Lorentzian?
- Pronunciation of Ancient Greek sigma as voiced [z] before voiced consonants
- Why does Miniscript add an extra size check for hash preimage comparisons?
- IPv4 class E IPs
- Can a derivative of a public domain text be licensed under CC0?
- Is there a way to extend the analogy that fractions means "x out of y" to show that fractions are also dividing?
- What is the difference between 潜艇 and 潜航器？
- Installing Ethernet Cable (West to North side of house)
- A perforated ding dong surface
- What is this component? It looks like a rectifier with 149k as identifier