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
-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?
user avatar
  • 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, ...
user avatar
  • 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:...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
-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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
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:\...
user avatar
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. ...
user avatar
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 ...
user avatar
  • 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' ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 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'...
user avatar
  • 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 ...
user avatar
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] ...
user avatar
  • 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 , ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
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, ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
  • 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). ...
user avatar
  • 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 ...
user avatar
  • 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/...
user avatar
  • 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 [...
user avatar
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 ...
user avatar
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 ...
user avatar
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://<...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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\...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
  • 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....
user avatar
  • 57

1
2 3 4 5
27