Questions tagged [restore]
Reloading a database from a backup, typically for disaster recovery, or to make a copy of a database onto another server.
1,314
questions
-1
votes
0answers
29 views
SQL Indexes are Missing post database restore into new server
We have 2 sql servers.
Database full backup has been taken from server 1 (Read only Database) -This Database is only set to Read Only.
And restored the same full backup file into Server 2.
Post ...
-1
votes
0answers
39 views
SQL Indexes are Missing post database restore
We have 2 sql servers.
Database full backup has been taken from server 1 (Read only Database)
And restored the same full backup file into Server 2.
Post restore there in server 2 found many indexes ...
0
votes
1answer
43 views
SQL 2005: Service don't start after master db restore
I need to restore master Db on my SQL 2005. But I get an error.
From prompt I stop the sql instance, then restart it in single user mode with /m command. Then launching sqlcmd -s nameistance I've this ...
0
votes
0answers
19 views
How to specify a sync source when adding a new member to a MongoDB replicaset?
Recently we had a machine physically destroyed, so our replicaset is now: Primary - Secondary - Arbiter (250G on disk, 20G (70hrs) oplog).
So, I'm trying to add a new member (4.4.10) to the replicaset ...
1
vote
1answer
64 views
+100
SQL server restore from backup files on azure storage blob container (using SAS token)
I have set up a SAS token in an azure blob storage container. It is currently valid, as demonstrated by the fact that this command in windows cmd.exe works:
azcopy list "https://<...
0
votes
0answers
25 views
Unable to perform the 'rds_restore_database' procedure on AWS RDS SQL Server Express
I'm facing the error Maximum supported database size on SQL Server Express edition is: 10 GB. when executing the restore procedure msdb.dbo.rds_restore_database.
The weird thing is the actual database ...
0
votes
0answers
13 views
How to restore the backup of schema taken using pgdump from a different RDS to a different RDS in postgresql?
I have 2 RDS in AWS actually . I need to take the schema from one of the RDS and restore it into the second RDS without taking the table data. So i have taken the backup using this command in bastion ...
0
votes
1answer
49 views
Why backup db is of more size than restore db which was restored from backup?
I got a 42 MB .bak file, when restored, the database size is about 2048.00 MB.
When I do backup for this DB .bak file size becomes 277 MB.
Why .bak file size increases? I do it immediately after ...
0
votes
0answers
28 views
How can i Restore Oracle 12c database Schema from a full EXPDP dump on a Test Server providing a new scheam name?
I have a production database whose full dump is 500Gig and and I cannot do a full restore on a test server because of space issues. However I need to restore a certain schema in from that dump into ...
1
vote
2answers
100 views
In SQL Server the backup file is around 190 gb, but when restore the log needs around 2 TB space
From the production the database is backed up automatically every day full backup and every 1 hour for transactional backup.
A test server was prepared and I want to restore the latest full backup to ...
0
votes
1answer
42 views
Restoring database and "Logical name"
I already search and read some of previous post like:
Restore Database from Database with Different Name
SQL Server Changing logical name
I know how to restore, and how to change logical name.
I have ...
-3
votes
0answers
54 views
DB2 with no backup is in restore pending state [closed]
I have DB2, and it is in restore pending state. I cannot restore cause i have no backup. I have no archive logs.. the system is production system. Is there any way, i can get the system back in normal ...
1
vote
1answer
25 views
How to take mysqldump of specific tables across all databases and restore them to a a single database?
I need to take a mysqldump of specific tables across all databases in a cluster.
In this case the cluster has more than 300+ databases. And I need to take the dump of table1 and table2 from each of ...
0
votes
0answers
30 views
Postgresql recovery setup
I have a standalone postgresql v13 server running with only a couple of 100gb databases. I am making daily dump based backups with commvault. My devs do not need PITR. I am using WALs only for ...
1
vote
0answers
48 views
RESTORE HEADERONLY takes over 10 minutes to complete
I have a database backup that has been taken on another server (That I don't have access to) I want to restore the HEADERONLY and when I do so:
RESTORE HEADERONLY FROM DISK = N'D:\SqlServer\backups\...
0
votes
0answers
57 views
MySQL Error: Multiple files found for the same tablespace ID
Today my MySQL started giving me this error when I try to start the MySQL Service:
[ERROR] [MY-012209] [InnoDB] Multiple files found for the same tablespace ID
[ERROR] [MY-012202] [InnoDB] Tablespace ...
2
votes
2answers
33 views
Microsoft SQL Standard 2012 DB recovery without .BAK file?
Morning, I'm posting for some guidance on an issue we're up against. We had a server crash and don't have .BAK file for our SQL DB (the backup/images failed). Anyhow, we DO have a file level backup of ...
0
votes
0answers
116 views
SQL RESTORE FILELISTONLY query brings error in event viewer - BackupIoRequest::ReportIoError: read failure on backup device
I use the following query:
RESTORE FILELISTONLY FROM disk = N'E:\Tmp\metadata2012.metadata' with CONTINUE_AFTER_ERROR
--or even like that
--RESTORE FILELISTONLY FROM disk = N'E:\Tmp\metadata2012....
0
votes
1answer
45 views
Sql server Backup & Restore From FileGroup
I Use Sql Server 2019 And need to backUp & Restore the FileGroup.
Execution steps :
1.Create The Database With Two FilesGroup and [TestFileGroup] name.
2.Insert data in two tables, one in First ...
0
votes
0answers
46 views
pg_dump with proper table dependency analysis?
Is it possible to dump then recreate with proper table analysis,
so for example if table A depends on table B, then table B will be dumped first, then the table A
something like
CREATE TABLE B(...);
...
-1
votes
1answer
73 views
Attach of renamed files conflicts with original files
I am having difficulties attaching DB in a certain environment while the same scenario works in my dev or other production instances.
SCENARIO
There is a backup of database files (MDF, NDF, LDF, ...
0
votes
0answers
29 views
How to recover data from idb files [duplicate]
I've tried:
Used mysqlfrm to recover the table structure.
Created it.
Discarded tablespace.
Copied .idb file to directory.
Imported tablespace.
But file size in information_schema was 0;
Then I ...
0
votes
0answers
60 views
How to speed up restore database from snapshot in SQL Server? [duplicate]
To revert a test database to an initial state (after running a test), I would like to restore the database from snapshot. I'm using the following script to achieve that. However, the script execution ...
0
votes
1answer
53 views
How to speed up restore database from snapshot in SQL Server?
To revert a test database to an initial state (after running a test), I would like to restore the database from snapshot. I'm using the following script to achieve that. However, the script execution ...
0
votes
1answer
74 views
How to sync SQL Server Logins with database User after a restore from another server
I have a database server with several databases inside. This server is used as test server to store a set of test databases. The test databases do not come from the same production server thus I can ...
0
votes
0answers
40 views
PostgreSQL - Running out of memory when restoring database from large dump
I have a Postgres database dump in text format, which is roughly 20GB. I am trying to restore the database using the command
$ psql DatabaseName < path-to-dump
But after I while I get the message ...
0
votes
0answers
33 views
Is there any alternative to Sage Evolution's way to backup & restore databases
I am currently working on a handful of web apps that work in coherence with our Sage 200 (Evolution) database.
However, one problem that we have noticed at the moment is the ability to backup and ...
0
votes
1answer
43 views
RMAN Duplicate PITR without connection to Target database
I would like to understand which network requirements are needed following the least privilege needed policy in order to perform a DUPLICATE DATABASE UNTIL SCN in this scenario
My environment is Azure,...
-2
votes
1answer
28 views
During restore, how does sql server know the point until where the tlog record is applied to the data page?
During restore, when the tlog records are applied to the data page, redo, undo phase, how does sql server know which transactions are already present in the data page and which transaction to start ...
0
votes
0answers
52 views
Recover data from .ibd file with corrupted page
I'm seeing "incorrect information in file" errors when opening my INNODB tables.
I followed the general recommendation to extract the CREATE TABLE statements from the .frm files using ...
0
votes
1answer
34 views
Made a plain-text backup (SQL script file format), how do I restore just the data (assuming the schema is valid)?
I use to backup my DB with pg_dump -cF p my_db > snapshot.sql.
How can I restore only the data from one of those files (assuming the schema is valid)?
Do I have to issue just and all the COPY ...
1
vote
1answer
27 views
Which log backup to apply first during recovery?
During recovery, I have restored the latest full backup, followed by the latest differential backup.
Last Full backup had ran on Thursday 9.15pm. Last Differential backup had run on Sunday 3.15am. Log ...
0
votes
1answer
62 views
How to restore a Cold Backup of Oracle Database to new environment
All of a sudden my laptop ran into a problem and the sfc command ruined the whole thing and couldn't boot my Windows 10. Due to this, I formatted the laptop and now I want to restore the Oracle 11g ...
3
votes
1answer
144 views
Manual log backup makes restore strategy useless upto next full backup only?
Suppose I do full backup at 12am. Then log backups every hour.
Then suppose at 8.30pm I do a manual log backup (thus truncating the log) and delete this file. Thus the subsequent log backup at 9pm ...
4
votes
2answers
365 views
Will non copy only full backup impact transaction log backups chain?
We have full backups and log backups configured.
During restore we apply full backup and subsequent log backups.
I know that if I take a manual full backup (non copy only mode) then it will break the ...
1
vote
2answers
48 views
What is the advantage of full backup over snapshot backup when it comes to restore by applying tlog?
What is the difference between following restore options:
A. Full backup and applying to it subsequent log backups.
B. Snapshot backup and applying to it subsequent log backups.
Note: this is not ...
2
votes
2answers
116 views
Will snapshot backup (non copy only) break restore chain?
I have full backup running at 6am on Sunday. Differential backup running at 6am everyday. Log backup running every hour.
There is also a Snapshot backup running at 3pm everyday. This is not a copy ...
3
votes
2answers
159 views
Why does a Full Backup restore of my database give me the error "RESTORE can only create a database when restoring either a full backup..."?
I've setup a maintenance plan to take a daily Full backup of all databases on my server. I've also setup a second maintenance plan to take Transaction Log backups every 5 minutes. The Transaction Log ...
0
votes
2answers
41 views
Oracle: Corrupt datafile will not turn back online?
need immediate assistance on an issue... Oracle Support is taking way too long to respond back on.
We have a corrupt datafile in one of our tablespaces, I attempted to shut the datafile offline, and ...
-1
votes
1answer
31 views
Postgresql: restore database from dump sql file error [closed]
There is a database that runs in the docker container . I need to make a local copy of this database. To do this I use the command
docker exec -t 5a5c84157ffe pg_dumpall -c -U postgres | gzip > /...
0
votes
0answers
60 views
(Error : RESTORE HEADERONLY is terminating abnormally) when restoring SQL Backup from Standard edition to Developer Edition (Both 2017 Versions!)
The instances have the following versions
Source -->
Microsoft SQL Server 2017 (RTM-CU25) (KB5003830) - 14.0.3401.7 (X64)
Jun 25 2021 14:02:48 Copyright (C) 2017 Microsoft Corporation
Standard ...
0
votes
0answers
36 views
How to backup tarantool remotely (over SSH) with compression?
In PostgreSQL usually I do this:
# Backup (remotely via ssh, to local disk)
ssh -p 22 user@dbserver "sudo -u postgres pg_dump -Fc -c dbname | xz - -c" \
| pv -r -b > tmp/db_backup_`date +...
0
votes
1answer
48 views
On premise to cloud restore - Automated?
What's the most automatic way to restore a on-premise SQL Server database to Azure SQL Database?
Has anybody done or seen such a solution?
Scenario:
Need to do a weekly refresh of a dev database from ...
0
votes
1answer
36 views
Is renaming schemas more efficient / faster than drop/create in a single transaction
Given the constraint (from customer side) to having only one database - how can I most effectively deploy new versions of data into a production-facing application.
The new data is packaged into a (-...
0
votes
1answer
66 views
Backup and restore of large SQL Server database with least downtime
I am trying to migrate a SQL Server 2016 database to a SQL Server 2019 server. The database is huge at about 500 GB. It takes about 3 hours to create a Full compressed Backup of about 300 GB and 2.5 ...
0
votes
1answer
66 views
What is the theory and workflow for taking a snapshot of a PostgreSQL database and restoring it in a running application?
The only thing I could find to get started is: Is it possible to quickly create/restore database snapshots with PostgreSQL?
I also see things like this, but I'm not sure if that's all you need.
I am ...
0
votes
1answer
45 views
attach Database without Overwriting the original
New to this, We have needed to do a system restore of a SQL DB the IT co have provided us with a copy of the MDF and LDF files, I need to attach these without overwriting the existing files.
But I get ...
0
votes
0answers
49 views
Copying a single database from DB2 10.5 to DB2 11.5
What is the easiest way to copy a single database (has no large objects) from DB2 10.5 Express-C instance to DB2 11.5 Community Edition instance?
I tried this method but obviously db2 restore database ...
2
votes
1answer
53 views
Can we access snapshot database of a log shipping database while we are restoring log files
I have a question regarding snapshot database of a log shipping database.
I have a database name like Northwind on server A and I am shipping it to server B. On server B, the log shipped copy of the ...
0
votes
1answer
165 views
Restore MySQL MariaDB Database from local files (without sql dump)?
first of all - I already read several other threads like Restoring MySQL database from physical files, but I'm unsure wether this will work for me since I'm running MariaDB and not MyISAM.
Let me ...