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,340
questions
-2
votes
1
answer
43
views
What is recommended approach for fixing corruption related errors?
When there are errors of code 823 in the log or dbcc has detected corruption, then should the 1st choice to solve this be:
dbcc checkdb with no data loss
or restore from full backup+tlog backups?
- 2,239
-1
votes
0
answers
34
views
After a server OS drive crash, how to restore user dbs after restoring the system dbs? [duplicate]
Assuming sql server OS drive crashes and data/log files are safe in their own drives.
I installed sql server with same version on a new machine. Then I restore the system databases (master, msdb, ...
- 2,239
-2
votes
0
answers
26
views
Where can I find steps to recover sql server from OS drive crash? [duplicate]
I want to understand official Microsoft recommendation to recover from a sql server OS crash. Assuming the data and log file drives are safe.
I am reading various online material which suggests either:...
- 2,239
-2
votes
1
answer
53
views
What is the general recommendation for sql server crash recovery from mdf/ldf vs backups for least data loss? [closed]
I'm learning steps to recover from sql server OS or OS disk crash. Assuming the OS or OS disk is corrupted and unrecoverable.
I know that a HA solution like fci or ag is better suited to prevent such ...
- 2,239
0
votes
1
answer
30
views
How to restore a RDS Postgres instance from a snapshot exported to S3?
Amazon RDS Postgres database are backed up as snapshots automatically. Because of the high storage costs ($0.095 per GB-Month), I want to move them to S3 (Storage Class: Glacier Deep Archive: 0.00099 ...
-3
votes
1
answer
50
views
speedup postgres pg_restore
Hi I have to update monthly my database using this big dump (100gb)
I don't have the control over how it's done I only receive a .zip with a lot of .gz
i want to speed up the restoring since I only ...
- 3
0
votes
0
answers
21
views
Faster way to Restore Postgresql Dump Taken by Pg_dumpall?
I have a database server which consists multiple databases and the size is nearly 1 TB. The problem is, it takes very long (hours) to restore from the dump.
Normally i restore my database via this ...
- 101
4
votes
1
answer
51
views
SET SINGLE_USER WITH ROLLBACK IMMEDIATE only disconnects sessions when account is a database user
The following code creates a user that is able to restore a database:
CREATE LOGIN RestoreUser WITH PASSWORD = 'MyPassword'
ALTER SERVER ROLE dbcreator ADD MEMBER RestoreUser
This works fine and the ...
- 1,450
0
votes
0
answers
23
views
Postgres 11 docker container fails to start: Segmentation fault
I am running a Postgres 11 instance in a docker-container started with docker-compose together with Wiki.js on a raspi.
A longer time ago, I pulled a new image which resulted in termination by signal ...
- 101
1
vote
1
answer
40
views
Restore filegroup without log sequence number (LSN)
I have the following error:
The roll forward start point is now at log sequence number (LSN) 5470633000000066000001. Additional roll forward past LSN 19429240000000043500001 is required to complete ...
1
vote
2
answers
30
views
Restore database, moving ldf and mdf to the default location
When I try
RESTORE DATABASE [foo] FROM DISK = 'C:\foo.bak'
the restoration procedure will try to put the dat and log in a location that was available on the system where the backup was done (like G:\...
- 626
0
votes
1
answer
58
views
Corrupted database. How to restore it from an old backup and add newer changes after?
I have a corrupted database with the following error
Msg 8952, Level 16, State 1, Line 1
Table error: table 'sys.syscolpars' (ID 41). Index row of index 'nc' (ID 2) does not match any row of data. ...
- 1
1
vote
4
answers
68
views
Basic SQL-server support question [duplicate]
I'm facing the most basic SQL-server support question:
I'm developing an application, based on a certain database, and my customer is using that same database structure (same name, same structure, but ...
- 333
0
votes
0
answers
18
views
How do I use COPY FROM on a backup file with multiple tables?
I used this command to backup my "supplies" table:
COPY supplies (id, price, ...) FROM 'C:\Users\MyCompany\Desktop\database03-01-2022.sql';
But now, I would like to write three more tables' ...
1
vote
0
answers
14
views
How to activate barman_slot in PostgreSQL?
I am using PostgreSQL cluster with Barman backup tools. I just recovered one of my backups. After recover, I found barman slot is inactive. Later, I deleted that inactive barman slot and created ...
0
votes
1
answer
52
views
ODA X8-2M crossrestore with TDE wallet fails with: DCS-10001:Internal error encountered: failed to open the tde password based wallet
We are trying to crossrestore a TDE encrypted Oracle Database 19.12 on a new ODA X8-2M.
TDE wallet has been successfully backedup (odacli create-backup -in CDBET015 -c TDEWallet) and transferred to ...
- 868
1
vote
1
answer
63
views
dbcc checkdb errors, or msg 601 when restoring SQL 2012 backup to SQL 2016
I need to move two databases, WES and WILL from a Win2012/SQL2012 instance to a Win2016/SQL2016 instance for a software upgrade. I'm using the full backup files from the SQL2012 maintenance plans. I'...
- 11
3
votes
2
answers
56
views
Estimating the best restore time from saved backups in SQL Server
I am looking for guidance and any advice on how to estimate the restore time for SQL Server databases once copied locally to the server.
This is just to layout a strategy what will happen if in future ...
- 703
4
votes
1
answer
128
views
Can't restore a backup of database which has TDE enabled
I'm trying to restore the backup of database which has Transparent Data Encryption enabled. I have verified the certificate thumbprint in the backup file is the same as TDE certificate in [master] ...
- 76
0
votes
0
answers
42
views
remote backup restore with xtraBackup
how i can restore backup created with xtrabackup to remote server ?
we do not have enough space to copy backup files and then restore them .
is it any way like xbstream that backup on remote server , ...
0
votes
1
answer
73
views
pg_restore "exceeds btree version 4 maximum 2704 for index" with no data exceeding that
Currently trying to migrate a Azure Postgres instance from pg11 to pg13, using pg_dump and pg_restore.
However there's a problematic table that is complaining about a large index b-tree size, I ...
- 1
0
votes
1
answer
86
views
Restoring sql database from recovered .bak file
I want to restore one of my databases from an old backup but the old backups were deleted. So, using a recovery tool, I was able to recover the old backup files. but when I try to restore them I get ...
- 55
0
votes
1
answer
44
views
Missing rows in table after restore database from MDF and LDF with SQL Server 2008
I have got two files, test.mdf and test.ldf, with sizes around 200 Mb and 200 MB.
I restore the database using "Attach Databases" options, all is ok, but I found that there are a lot of ...
- 113
3
votes
1
answer
59
views
Missing Tables from a Backup and Restore (Migration) on SQL Server
I'm trying to copy the structure and contents of a small database on an SQL Server instance at work to an instance on my home computer. It seems like this should be a simple, two-minute operation, ...
0
votes
1
answer
34
views
RMAN Duplicate with new SID / Path
We are running Oracle 12c SE. I need to duplicate an instance from the RMAN backups. However, this instance will be on a different server, with a different SID. And, the pathnames have the SID in ...
- 131
0
votes
2
answers
52
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 ...
- 2,239
0
votes
0
answers
48
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 ...
- 109
0
votes
1
answer
24
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
1
answer
114
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
3
answers
129
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 ...
- 111
0
votes
1
answer
39
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 ...
- 115
1
vote
0
answers
90
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). ...
- 157
1
vote
2
answers
229
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 ...
- 637
0
votes
1
answer
37
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/...
- 1
0
votes
1
answer
172
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 [...
syl
0
votes
1
answer
69
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 ...
- 1
0
votes
0
answers
52
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
1
vote
1
answer
250
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://<...
- 53
0
votes
1
answer
118
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 ...
- 101
0
votes
0
answers
45
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 ...
- 1
0
votes
1
answer
63
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 ...
- 13
0
votes
1
answer
72
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 ...
- 19
1
vote
2
answers
113
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 ...
- 11
0
votes
1
answer
63
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 ...
- 117
1
vote
1
answer
57
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
0
answers
63
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
0
answers
136
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\...
- 1,450
0
votes
0
answers
270
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 ...
- 101
2
votes
2
answers
34
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 ...
- 21
0
votes
0
answers
191
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....
- 57