Questions tagged [restore]

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

236 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
4
votes
0answers
2k views

Restoring from PostgreSQL 9.5 dump to 10 is super slow

I am trying to restore database dump created on PostgreSQL 9.5.16 to PostgreSQL 10.7 and it is taking a lot of time to restore. Restoring the same dump to 9.5 doesn't take that much. So I am wondering ...
4
votes
0answers
2k views

"could not write to log file, Bad file descriptor" error when working with huge table

I'm having a big problem with a PostreSQL database. Whenever I do something with a huge table (over 9 million rows) the whole postgres process crashes with the following entries in the log file: ...
3
votes
0answers
55 views

Why recovery took longer time even though analysis phase is not that long

We are doing Volume Snapshot restoration from Production to Warm Stand-By Server on daily basis. Daily it takes around 10 mins for DB to recover. But yesterday it took 44 mins to recover. I am ...
3
votes
0answers
286 views

Remove table from DEFUNCT filegroup so we can recreate the table again in a different online filegroup

We have a BIG production database. We also have STG and UAT servers, where we restore the PROD database. One of the biggest tables (+250 GBs) in this PROD database is in the SECONDARY filegroup. We ...
3
votes
0answers
1k views

No backupset selected to restore

I have 2 cloud SQL Servers, one in Azure, one in AWS (I don't think the cloud platforms matter here but including them just to be thorough). I'm unable to restore a database from the Azure server to ...
3
votes
0answers
378 views

Restore from Azure blob storage failing after backup overwrite

I'm attempting to backup a database (full backup, in simple recovery) to Azure storage, replacing a bak file that already exists, then restoring the new backup. Doing a regular backup and restore ...
3
votes
0answers
75 views

database restore with filestream on Windows Server 2016 renames data file

I have a database in SQL Server 2008 R2 sp2 that has filestream enabled. Restore of the database on a Win10 machine works as it should. However, on Windows Server 2016, the data directory (file) for ...
3
votes
0answers
14 views

Restoring SQL Server filegroup subset

Struggling with a task I've been given. We have a large SQL Server 2012 database (almost 2TB) with multiple filegroups. The filegroups are basically split up into different years, so many of them ...
3
votes
0answers
288 views

Best method for daily incremental copy of Postgres database

I'm trying to figure out the best plan of attack for making a nightly copy of our Heroku PostgreSQL production database to our local development environment. The database is rather large and grows ...
3
votes
0answers
77 views

Compress backup taken from two different environments take different time to restore

I have two backup files one from Normal SQL Server and one from SQL Server from Azure VM. The restore of these backup files is totally different from each other. Though the database backups are ...
3
votes
0answers
343 views

Restoring Postgres fixtures into a different database with different premissions

I've got an application called BigSense that uses two database users/rolls. One has full permissions and is used by my application to create/adjust table definitions. Then the application starts with ...
3
votes
1answer
5k views

How to restore database from /var/lib/mysql

I have a database folder from a crashed server called gain_wordpress. I'm trying to put that database on a new server but I'm not able to do it successfully. I don't have a .sql dump, all I have is ...
3
votes
2answers
754 views

Applying (log backup) LSNs to the secondary node of an Availability Group

I have a test instance configured as always-on go down today due to a restart of the primary node and the file-share going down together. I had a bunch of problems in order to get the secondary ...
3
votes
2answers
1k views

Extract one MySQL database from a FULL MYSQL Server backup file

I have a small shared windows server on which i'have installed MySQL 5.1 engine for hosting my user's mysql databases. I backup the complete MySQL databases each day by running this script as batch ...
2
votes
0answers
613 views

Trying to restore InnoDB tables

I've reinstalled MySQL but when I copy the data dir from the old instance: maicol07@maicol07$ sudo mysqld --user=root 2020-07-14T13:07:34.031447Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (...
2
votes
0answers
558 views

PgAdmin: backup and restore schemas using the GUI

I know how to backup and restore one or more schema(s) from a PostgreSQL database using psql: Go to the folder that contains the executables of PostgreSQL: cd C:\Program Files\PostgreSQL\11\bin ...
2
votes
2answers
148 views

Log error restoring old database to SQL Server 2017

I am trying to migrate a database from an old SQL Server 2008 R2 to SQL Server 2017. The database was originally 2000 and thus has a compatibility level of 80. Initially I took a full database backup ...
2
votes
0answers
631 views

SQL Server Restore Failing with Error Read on "M:\MSSQL\My_FULL_Backup_20190924_010558.bak" failed: 1101(A tape access reached a filemark

I have been trying to restore one of our db for the past few days without any luck. I keep getting the below error. I tried the restore during peak hours, off peak hours both by accessing the backup ...
2
votes
2answers
37 views

Database Merging / Re-integration

I am a SQL Server DBA. I recently had the misfortune of losing a database due to drive failure. I was able to restore the data but for whatever reason, it stopped at a certain time and not all of the ...
2
votes
1answer
2k views

Galera - single database backup & restore

I have a MariaDB Galera cluster. One of its nodes is dedicated for the backups (pc.weight=0 and the MaxScale SQL proxy doesn't know it exists). I'm using mariabackup --backup --galera-info --target-...
2
votes
1answer
38 views

How to order databases by size? (For use in full backups)

Recently, I've been trying to make our company's full backup process more efficient. In order to do this, my team has decided that instructing the backup job to tackle the full backups starting with ...
2
votes
0answers
116 views

Restore SQL Server 2016 - buffer memory - OS memory

When restoring SQL Server 2008R2 DWH-DBs I always gave some memory back to the OS to speed it up. Now I got performance problems restoring to SQLServer 2016: Where does the restore buffer come from? ...
2
votes
1answer
77 views

Do I need to worry about RESTORE FILELISTONLY types other than L and D?

According to https://msdn.microsoft.com/en-us/library/ms173778.aspx, there are four types, L, D, F and S. All of the actual database instances I've seen so far (SQL Server 2008 and up) only have ...
2
votes
0answers
340 views

SQL Server Backup/Restore IO performance on Azure VM

We are currently experiencing an issue where the IO performance of our SQL Server running on an Azure VM isn't quite up to snuff. We are running a Azure VM (Standard DS2). This one has a 127 GB SSD C:...
2
votes
0answers
1k views

Restoring a database with just .idb and .frm files

I've never attempted something like this before. We had a WAMP installation with WordPress running on my wife's PC, and the Aestan tray menu failed. I figured we need to uninstall and re-install WAMP, ...
2
votes
0answers
476 views

SQL Server 2012 database stuck restoring

I'm trying to restore my development database DEV with a backup of my production database PROD. Every time I go through this process, the DEV database gets stuck in a Restoring state. Using the SQL "...
2
votes
0answers
94 views

Why does my differencing virtual disk grow so much after restoring a differential SQL Server backup?

Inspired by RedGate's upcoming SQL Instant Clone, I'm using virtual disks to store my test database and gain fast clones via differencing disks. I created a 30 GB VHD and restored a 18 GB database ...
2
votes
0answers
1k views

Why does SQL Server's RESTORE VERIFYONLY command fail intermittently?

Our maintenance scripts run RESTORE VERIFYONLY WITH CHECKSUM after each database is backed up to our backup server. A few of the databases often fail with the error shown below. But if we re-run the ...
2
votes
0answers
961 views

Trying to restore a db2 database but stops at roll-forward with error 'SQL1265N'

I'm trying to restore a backup that is older than the current database. The restore went ok, but the roll forward didn't giving the following error: SQL1265N The archive log file ".LOG" is not ...
2
votes
0answers
1k views

DB2 - Error accessing a table space SQL 57048

Please can you assist me,I am mighty new at DB2, I done a backup on the prod server in order to mirror the prod server on another server. Backups ran fine. I did the restore on my test server. but ...
2
votes
0answers
162 views

Restoring SQL Server 2012 Enterprise to Web Edition not possible due to full text partitioning

I have an SQL Server 2012 Enterprise database I’m trying to restore to SQL Server 2012 Web Edition instance. I’ve used sys.dm_db_persisted_sku_features to find features to remove before a backup/...
2
votes
0answers
65 views

My stored procedure randomly fails due to invalid object in a swapping database instance

I have a stored procedure in my database (say it is CustomerDB) which joins with a table function in a different database (say it is dbPerformance), the sp is something like: select something from ...
2
votes
0answers
73 views

restore script variable date and time

Goodafternoon, i am looking for a variable for the date and time. I have several backups in one directory and want to restore the latest to a another server. Is there a variable i can use in my ...
2
votes
1answer
90 views

Recover mysql using data folder

One of our MySQL servers died but somehow we were able to recover all the files from it. This server was a slave at one time however we stopped it being a slave so we could use it for housekeeping ...
2
votes
1answer
87 views

Recovering credential data from a master DB backup

On a SQL Server 2008 R2 instance, a misconfigured credential used as a SSIS proxy for an SSA job was dropped before I could look at the system views to figure out when it was originally misconfigured. ...
2
votes
0answers
1k views

System.Data.SqlClient.SqlException (0x80131904): SQL Server detected a logical consistency-based I/O error: incorrect checksum

I am migrating client's database to my hosted environment, the client runs SQL Server 2008 R2, and we run SQL Server 2014. I am stuck on restoring one log file, which left below error message when I ...
2
votes
0answers
2k views

Fast restore of dropped partitions

I want to test the restore of erroneously dropped partitions of a subpartitioned table. This restore would consist of three steps: restore the database (or at least the necessary tablespaces) to the ...
2
votes
0answers
7k views

Oracle restore backup on other server

I have following situation: One server with Oracle has to be backed up and recovered on other Oracle server. Second Oracle DB has the same user/schemas, but with a different older data. I intend to ...
2
votes
0answers
235 views

How to gracefully handle a source database restore from backup in a data warehouse

We are facing a challenging situation with our data warehouse source databases. Frequently these sources databases will be restored from backups. There is a high turnover of data entry persons who ...
2
votes
0answers
178 views

Is it possible to have a valid backupset with null position?

In database restore process I need to rely on position column exists in backupset record to restore the latest backupset. Restore the latest backup on the database I noticed sometimes position is ...
2
votes
2answers
2k views

Powershell Restore Azure SQL Database to local with Restore-Database

I have written a powershell script that uses Start-AzureSqlDatabaseExport & Get-AzureStorageBlob to export my Azure DB to a bacpac and download it locally, the next step is to restore the bacpac ...
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\...
1
vote
0answers
32 views

Informix onunload/onload between different arch

I have some necro-project using Informix Dynamic Server Version 7.31.UD1. I need to backup-restore database between servers. The thing is, the onload just silently exits and doesn't create a database, ...
1
vote
0answers
93 views

Faster way to restore MySQL innoDB dump

I have a below MySQL configuration. # The MySQL server [mysqld] .... key_buffer = 384M max_allowed_packet = 5M table_open_cache = 512 sort_buffer_size = 2M read_buffer_size = 2M read_rnd_buffer_size = ...
1
vote
1answer
25 views

Recover old backup with barman

I have setup barman that allows me to backup my database. I have several backup, and I would like to recover an old backup. because I need to check the state of the database at a given time, two month ...
1
vote
1answer
112 views

Target server is not communicating(polling) with master SQL Server

We set up multi-server administration to create a job on the master which are executed on target servers, and we had this issue because the target server was shut down after a virus attack and we set ...
1
vote
0answers
44 views

SQL Managed Instance Restore to lower environments

I was trying to find an article or design pattern to fit my use case but I cannot find one. My use case: I have a Production Subscription with a SQL Managed Instance that holds all production data. ...
1
vote
0answers
202 views

PostgreSQL COPY - Generated columns cannot be used in COPY

Im trying to import a SQL dump file for a table (A COPY command dump file). The table has a generated column. While restoring the dump Im getting this error. ERROR: column "call_status" is ...
1
vote
1answer
26 views

Restore Postgresql database from table files

Is it possible to restore a Postgres database when only having access to the table files under $PGDATA/base/<db_oid>? The system catalogs are empty. Background Somebody with sudo executed an ...
1
vote
0answers
190 views

Can not run Sys.dm_exec_requests during backup restore

We do database creation through an application,i am seeing below error when running below DMV(connection context is master) query ran : SELECT session_id as SPID,wait_type,wait_resource,...

1
2 3 4 5