Questions tagged [restore]

Reloading a database from a backup, typically for disaster recovery, or to make a copy of a database onto another server.

Filter by
Sorted by
Tagged with
-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 ...

1
2 3 4 5
27