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
0
votes
1answer
28 views

Does only a full backup (and no tlog backup) of a db in full recovery model allow for point in time recovery?

I have a database in full recovery model. Full backups are configured to run every Sunday and log backups run every day. Log backup files are destroyed after 30 days. Full backups are destroyed after ...
0
votes
0answers
43 views

After a restore my transaction is slow, so I stop it, do a roll back, then re-run and it's fast...why?

On my development server I delete all data from two tables then pull fresh data from the production server via Delete From then Select Into. It's only about 100,000 rows total. On dev I run a routine ...
0
votes
1answer
16 views

does using PV and pipe affect perfomance importing database?

I'm importing a database that's almost 2.5 GB inside a docker postgres container. I wanted to know the stimated time and the progress so to check the progress I use PV command like this (I'm not sure ...
0
votes
1answer
70 views

Restore SQL Server incremental backup with full backup copy only

I need to restore an incremental backup of SQL server but when I tried it, it gave me an error and I realized that the full copy has been done in copy-only mode for more than a year and now it does ...
0
votes
3answers
29 views

Unable to grant membership to public role

I'm trying to refresh my dev db with a snapshot from prod. I've restored the production db from the prod server to my dev server just named as development. I'm trying to grant access to the dev db to ...
-2
votes
0answers
54 views

I'm getting error when I try and restore database but I'm running a newer version can anyone explain? [duplicate]

Restoring database I recieve the following error. It seems I'm running a newer version but I'm still getting error. Please explain... TITLE: Microsoft SQL Server Management Studio Restore of ...
0
votes
1answer
34 views

Should databases be dumped to SQL format or custom archive?

I am wondering, what is the industry standard regarding dump formats, when making and storing the database dumps? Is it better to dump it to a custom-format compressed and unreadable archive, or just ...
0
votes
0answers
13 views

What's the difference between "--section=data" and "--data-only" of pg_dump/pg_restore?

In the man page of pg_dump/pg_restore, that is mentioned about --data-only option(but I didn't find --section=data) as following: --data-only Dump only the data, not the schema (data definitions). ...
1
vote
2answers
47 views

This differential backup cannot be restored because the database has not been restored to the correct earlier state

This is what I did: Took full backup Took Differential backup (immediately after full) Moved above files to DR server Restore full (successfully) Restore differential (error) RESTORE DATABASE ...
0
votes
1answer
14 views

Cannot prepare backup with innobackupex

I taken full backup from a Master server with innobackupex. Now I am restoring backup with innobackupex on a Slave server. I prepare backup with the command: innobackupex --defaults-file=/var/lib/...
0
votes
1answer
45 views

Restoring SQL Server DB trans log files error

I am getting error when restoring DB trans log files. Running RESTORE VERIFYONLY FROM DISK = xxxxxx is returning a message The backup set on file 1 is valid However when running RESTORE LOG [...
0
votes
1answer
55 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
47 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
100 views

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
32 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
18 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
55 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
1answer
34 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
104 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
45 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 ...
1
vote
1answer
27 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
38 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
62 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
123 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
130 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
55 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
53 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
33 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
70 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
88 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
45 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
34 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
55 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
29 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
66 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
42 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
95 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
147 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 ...
5
votes
2answers
373 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
50 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
124 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
165 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
43 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
43 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
67 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
40 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 +...

1
2 3 4 5
27