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
2answers
34 views

Permission denied when creating a database

Currently, my local instance looks like this I want to restore my user database I have tried restoring my database my rightclicking on Databases and also tried right clicking and doing it on system ...
4
votes
1answer
118 views

Not able to restore a backup to SQL Server 2019

I am trying to a restore a SQL Server from a .bak file and always get the same error : The database was backed up on a server running version 15.00.2000. That version is incompatible with this server,...
0
votes
1answer
21 views

MYSQL+MyISAM+Need information regarding check table statement

The MySQL CHECK TABLE statement checks a table or tables for errors. Does the statement put an auto lock on a table before checking table for errors? Does the statement perform a READ ONLY operation? ...
2
votes
1answer
19 views

SQL Server 2014 Restore DB only has “Verify Backup Media” option

I just downloaded SQL Server 2014 Management Studio. I got the backup files ".bak" from my colleague. When I try to do a restore from "Database > Restore Database...", the ...
1
vote
0answers
16 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. ...
0
votes
2answers
32 views

Fast Backup and Restore of Growing Databases

I work in Tech Support and the some of the products I support are heavily database dependent (PostgreSQL and MySQL, but most of the big ones are MySQL). Before we do an upgrade, we always take a full ...
0
votes
0answers
19 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 (...
0
votes
0answers
31 views

Is safe to make backups of vm that contain Oracle databases using veeam backup or another similar tool?

I would like to know if it is advisable or safe to make backups of vm that contain Oracle databases using veeam backup or another similar tool, my doubt is caused because I have several vm with Oracle ...
0
votes
1answer
28 views

How to restore MySQL database files without having a MySQL instance?

After a crash of my PC I'm left with several databases (27Gb in total) that are left on my data drive, while my OS drive (Windows 7) is gone. I've reinstalled the machine by now (Windows 10) and set ...
2
votes
1answer
38 views

Merging a .bak to an existing SQL database

I have a SQL Server database with data from 1990-2018 in a .mdf file. I recently downloaded data for 2018-2020 and it's in a .bak file. When I went to "Restore" the database, it wiped out ...
0
votes
0answers
26 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
votes
1answer
16 views

Migrate data from an older version of mongodb

How can I backup and restore a large mongodb database (500GB) from a server running an older version (v2.6) than the target one (v3.6)?. The downtime is critical. We've tried by making a straight copy ...
-3
votes
1answer
47 views

How to import old mongodb cluster into a new version of mongodb? [closed]

If I try to directly copy the data/db folder from an old installation of mongodb to the new one I'm getting this error when I try to start mongod, ** IMPORTANT: UPGRADE PROBLEM: Found an invalid ...
0
votes
0answers
49 views

A restore database action change my datatype from datetimeoffset to datetime

This the sequence I follow to replicate the problem: I have a tableA with some column, for example Field1 AS DATETIMEOFFSET(2) I have a view that use that column: View_ForTableA If at that moment I ...
1
vote
0answers
76 views

Database restore time increased after we changed from SQL Server 2014 to SQL Server 2016

I have a 2 TB database (200 GB backup) that I am restoring every night on a secondary server of a AlwaysOn group, to erase confidential information and then backup the clean database and send it to ...
1
vote
1answer
71 views

Oracle - MUST_RENAME_THIS_LOGFILE in logfile name

I'm creating a data guard using hot backup from the primary server. In my restore I've used the following commands to restore: run{ set newname for database to '+DADOS'; restore database; switch ...
0
votes
1answer
38 views

SQL Server - SQL script to restore database backup file into a new database

I am trying to create a SQL script to restore a database backup file into a new database in SQL Server. I can do it manually without problems: Right click on Databases => Restore Database Tick on ...
0
votes
0answers
13 views

Restore mongodb database from blockstore snapshot backup

I have a situation where I need to restore the mongodb database from the blockstore snapshot backup taken from the ops manager which is used to manage 3 node replica set. I need to restore this backup ...
0
votes
2answers
61 views

Can't alter database roles on a restored database

My SSMS Login (using an AD group) is allocated all server roles apart from sysadmin so I have quite a lot of access. Using this Login, I have restored a database from its .bak file. However, my Login ...
8
votes
1answer
334 views

Is it possible to restore a SQL Server Linux Backup on SQL Server Windows

I am running SQL Server in docker on a mac. I have taken a SQL Server backup from windows and restored it in the mac SQL Server docker instance. Now I want to take a backup from the SQL Server docker ...
0
votes
0answers
13 views

How to take single database backup using mysqlbackup command in Mysql 8.0.18 version DB

I have a mysql instance(8.0.18-commercial MySQL enterprise server) with 8 databases in it and out of those I only need to take the backup of DB named 'Test1'. Please note that its 300 GB sized DB ...
0
votes
1answer
29 views

views restored from backup in a different server referring to linked servers

I have 3 SQL servers X, Y, Z and 2 databases X.A and Y.B. There are (many) view in X.A that uses 4-level naming in their definition: SELECT ... FROM Y.B.SCHEMA.TABLE From this I infer that X ...
0
votes
0answers
24 views

Restore job “stuck”

After a restore job I can't read from database until I kill that long-running job. I'll try to give as much info as I can but being that I'm stuck I'm not sure what is pertinent. We are using ...
3
votes
0answers
54 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 ...
1
vote
1answer
32 views

SQL Fast database restore with Azure Virtual Machine instant recovery snapshot and SQL in Azure VM?

I have a large database. If I want to restore to a point in time using a full back up, it takes around 4 hours + time taken for transaction log restores. I also have VM image instant restore ...
2
votes
1answer
37 views

Large MySQL database dump/restore [closed]

Got a quite interesting task: Have to dump mysql databases from AWS and restore on a private cloud. Databases are quite big: 160GB, 120GB and 21GB each db.sql dump - all 3 in the same aurora rds ...
3
votes
2answers
116 views

Restoring MDF without LDF file

I am trying to attach a database just from the MDF file, cause the server crashed and could never find the LDF. I am on a 2019 MS SQL Server. I am following the instructions from this page. I have ...
6
votes
1answer
311 views

SQL Server: Get location of transaction log from MDF file

Our SQL Server 2012 Express server crashed and lost some data. We managed to rescue the main MDF, but can't find the LDF. Is there a way to get this information from the database MDF file or msdb, or ...
0
votes
1answer
24 views

Is it possible to restore single postgreSql database to PITR?

I have PostgreSQL instance with n databases on it. Is it possible to restore just a single database using PITR ? # restore tar xvfz /var/lib/postgresql/db_file_backup.tar.gz -C /var/lib/postgresql/10/...
0
votes
1answer
42 views

SQL Server: Get latest backup restore

We had a SQL Server crash and most of the data is unobtainable. I have found some old full backups and some differential backups in different servers. Is there a way to tell which differential ...
1
vote
2answers
32 views

MySQL replication master-slave

I'm learning master-slave replication with MySQL and I could get it to work and also use the Percona backup tool to restore a slave. I learnt from this project https://github.com/vbabak/docker-mysql-...
1
vote
0answers
24 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 ...
0
votes
1answer
11 views

restore table and populate new data from transaction log

I use mysqldump nightly to backup a database. I'm trying to find a way to do a partial restore on the data from one table. I use the --master-data flag so I know where in the transactions log my data ...
9
votes
3answers
2k views

Restoring ANY database to Azure MI fails

Our freshly provisioned Azure SQL managed instance fails restoring backups from URL. According to the server log the restore itself seems to finish after a certain amount of time but errors in ...
0
votes
2answers
80 views

How to find the current Log Sequence Number (LSN) of a database that is in Restoring state?

I removed one of my databases from the availability group on my secondary replica in my AlwaysOn group for an experiment. I want to add it back, but I cannot do so because the databases needs to be ...
0
votes
0answers
22 views

How to restore inno db table to mysql 8.0?

Something wrong with my ibdata1 file in mysql 5.5, now I only have *.frm and *.ibd files for my inno db tables, And I know the structure for my tables, so I can create empty tables in mysql8.0. Is it ...
2
votes
0answers
63 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 ...
0
votes
1answer
24 views

How to bring all replicas on a SQL availability group to an earlier state / point in time?

I have a SQL Always on availability group, with 4 replicas. One of them is the primary. Lets say someone accidentally drops a table on the primary. This transaction would go to all of the secondary ...
0
votes
0answers
8 views

sp_AllNightLog - Not restoring differential backup at the start of the process

I have setup [sp_AllNightLog] and running backups in production site with no issues. I have FULL, DIFF and LOG backups happening. Using version 3.5 and sql 2014 build 12.0.5659.1 When I run [...
1
vote
2answers
50 views

Associate BAK file with SQL Server database

One of our users deleted a lot of data from one of our database applications, and I need to find a way to restore it. I have a bak file and full recovery mode, but there is a catch. This bak file is ...
0
votes
1answer
12 views

No permissions to the certificate file when trying to restore a DB from a third party

I am trying to restore a Db in SQL server 16. It is a developer version installed on windows 10 laptop. We have a backup file from a SaaS instance. We have moved to a new instance of the SaaS and this ...
0
votes
0answers
10 views

Is there a way to recover a dropped database in postgresql-11

I am using postgresql-11, I have dropped by mistake the wrong database with dropdb command and I don't have any backup for it. Is it possible to recover the dropped database or the data inside it ...
0
votes
0answers
16 views

SQL 2016 - TDE Restore Failing Even After Certificate Restore

I'm trying to ship some TDE enabled database backups from one server to another and I'm having a problem. Specifically, I'm getting the following error: RESTORE FILELISTONLY FROM DISK = N'<path>...
1
vote
1answer
22 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 ...
0
votes
0answers
9 views

database restore with cross foreign keys on different schemas/databases

As I read on this question Mysql allows cross-schema foreign keys but how to deal with database (schemas) restore? I mean, if table A (schema 1) has a foreign key on table B (schema 2) and table C (...
0
votes
2answers
51 views

Postgresql - how to do backup/restore on a database level?

I'm a developer learning Postgresql and I'd like to know more about backups. As long-time Sql Server user, I understand backup and restore usually is done on a database level. So far every tool I ...
0
votes
1answer
40 views

Restoring a managed SQL instance in Azure using PowerShell

I am trying to figure out how to restore a database from one managed SQL instance to another. I'm following the tutorials, but I keep running into inscrutable error messages. Here's my command: ...
1
vote
2answers
50 views

MySQL restore dump takes too long to complete, how DBAs deal/replicate large databases?

Due to coronavirus my company is forced to scale down and cut costs. Long story short, I went the route of least disruption I set the original database server (that's going to be turned off for good ...
0
votes
1answer
27 views

Is it possible to restore a database with only database roles membership?

I have an existing database, that i want to restore from a backup by overriding the existing database. at the moment I have db_owner db_backupoperator roles I thought that would be enough to ...
0
votes
2answers
35 views

RMAN incremental restore

Can you anyone tell me if it's possible to restore an 11g Oracle database using media management software like Net Backup or Commvault incrementally? I need to perform a restore of a DB into a new ...

1
2 3 4 5
24