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,062
questions
1
vote
2answers
25 views
Incremental backup between now and backup taken one week ago
We do a full backup of our SQL Server 2012 database every night.
A new developer needs an incremental (or differential) backup of a backup we took one week ago. The reason is that for them, ...
5
votes
1answer
70 views
Restore stuck in ASYNC_IO_COMPLETION
Very frequently when I restore databases the restore operation gets stuck and the wait type is ASYNC_IO_COMPLETION.
It can be in such state for 10-20-30 minutes untill it proceeds to ...
0
votes
0answers
19 views
Cassandra restore fails if sstableloader is used
Starting point:
new cluster, DSE 6.7.4, C* 4.0.0.674
backed UP data, which was made by Opscenter snapshot backups to remote S3 bucket (1.5TB per each node)
restoring data to new cluster needs to use ...
0
votes
0answers
15 views
SQL Server Windows backup restore on centos
I have installed sql server 2017 on my centos 7 machine. I need to restore my database backups from windows machine to this machine. I could successfully run filelistonly. However, for restore, I'm ...
3
votes
2answers
93 views
How to query data in backups?
I have an ASP.NET app using SQL Server 2017. There's a bug somewhere that's causing some records to be deleted, and I'm trying to recover the data and find the cause of the bug. We take daily backups, ...
-2
votes
2answers
51 views
get data from express edition db to developer edition [closed]
Hi I've installed freshly db of ssms developer edition and Uninstalled express edition but I've a issue that I forget to take back up of that database.I've same data in c drive program file MS SQL ...
0
votes
2answers
29 views
SQL Server Backup Database not .bak file format
I've been using SQL Server 2012 for as long as I can remember. When I do a backup it's always saved as .bak file format. However, there's this other server that has SQL Server 2012 and when I do a ...
0
votes
0answers
18 views
How to prevent regular users to backup database, in Postgresql
How can I prevent/restrict regular users, that do have select rights granted on tables etc, to perform backup of Postgres database?
Is there a way to enable users to connect, select, update etc. ...
0
votes
1answer
14 views
mysql db data folder restore in 5 days old backup
recently I had the need to install a driver on a server and because of the destination I finished uninstalling XAMPP in which I had a database that I need to recover.
The fact is that after ...
-1
votes
0answers
18 views
Automate Weekly Restores, backups have different names each time
I'm trying to automate restores of weekly backups we are getting from a vendor. The issue is the database name changes every time and is postfixed with the date so how do I supply the full path in the ...
0
votes
0answers
23 views
PostgreSQL does not starting up after power failure
Could not start PostgreSQL after power failure:
FATAL: could not find tuple for opclass 1
PostgreSQL version:
root@ubuntu:/usr/lib/postgresql/9.6/bin# ./postgres -V
postgres (PostgreSQL) 9.6.1
OS ...
4
votes
2answers
74 views
Finding out who changed the owner of a database when performing a restore
A coworker who worked on restoring a backup changed the database owner from his name to 'sa' (rightly so) last night. While I had seen the his name in a SQL Server Management Studio window, I did not ...
0
votes
1answer
18 views
Error Unknown command '\U' when restoring MySQL dump on Windows
I am updating software that used MySQL 5.4.3 in its old version, and now uses MariaDB 10.2.11.
So, I dumped the old data with that command:
mysqldump -uroot -p --no-create-info --skip-triggers --...
1
vote
1answer
52 views
Restore of a database failed - Table does not contain an identity column
I've created a local SQL Server instance (using SQL Server 2017). I'm trying to restore a backup of a database created on a SQL Server 2012 server, for testing purposes.
The problem is that it ...
0
votes
1answer
44 views
How to check there is enough disk space before overwriting a DB with restore command
I need to automate the restore of a database each night from a backup but I want to first check if there is enough disk space. In the below Microsoft link it says the verifyonly command is able to do ...
3
votes
2answers
57 views
Backup a database from Azure SQL Managed Instance and restore to on premise SQL Server
I have three databases that I am migrating to Azure SQL Managed Instance. One is a Utility database, just a small collection of generic functions and procedures. One is the OLTP database for a web ...
9
votes
1answer
165 views
How do I find the FamilyGUID of an exsting database
When executing a RESTORE command, I understand that SQL Server ensures that an existing database is not being overwritten by a different database. This check can be bypassed using REPLACE.
I ...
0
votes
0answers
39 views
Corrupted Access Database
I have a big Access database, with aobout 150 Tables/Queries/Linked txt files/Macros/Modules.
I was working today, and then from out of nowhere the database got corrupted. I googled, and forund that ...
0
votes
0answers
52 views
End of file reached. Error 38 in SQL. Passes verification checks
Having issues restoring a database in SSMS, error 38.
The databases are transferred up to google via their Drive API.
Download it on my side and has error.
If I transfer it through teamviewer ...
1
vote
0answers
7 views
Mongodb - Small and Larger deployment
I read the following information from "https://docs.mongodb.com/manual/core/backups/"
"mongodump and mongorestore are simple and efficient tools for backing up and restoring small MongoDB ...
2
votes
2answers
48 views
How is the behaviour of backupset in RMAN?
I found this definition on WEB:
A logical grouping of backup files -- the backup pieces -- that are
created when you issue an RMAN backup command. A backup set is RMAN’s
name for a collection ...
5
votes
1answer
179 views
pg_ctl hangs over ssh
I am designing a process to test my postgresql 10.8 backups by restoring them to a random point in time in a throwaway virtual machine. I have been unable to fully automate the process though. I am ...
1
vote
2answers
43 views
How to verify the restored MS SQL DB from Backup matches with the source?
Once you restore the backup, how do you verify that the source and destination are in sync (schema, datatypes, number of records etc)? assuming that the source has not change. Appreciate your insights....
0
votes
1answer
61 views
SQL Server Agent Job - Unable to open Step output file. The step succeeded
I have seen many posts with "Unable to open Step output file.", but can't find any references where the step succeeded. I have my output file location set to:
$(ESCAPE_SQUOTE(SQLLOGDIR))\$(...
2
votes
1answer
78 views
How to check if backups are reliable?
I generally have to restore databases to different servers after important data imports or other important and delicate database operations.
I need to be sure that my backups up to that point in time ...
-3
votes
1answer
49 views
Postgres Restore [closed]
I need to restore a single schema from production postgres to test.
Test database and schema already exists.
The users/roles & sequences are different on prod to test and after schema is ...
0
votes
0answers
10 views
How to make replication continue to work after repairing?
I would like to share with you a problem I faced today and will be glad if you can help me to tackle that issue. The issue related to transactional replication. So, let's go step-by-step to know how ...
0
votes
1answer
35 views
Unable to restore a PostgreSQL database from a .backup file
I am using Ubuntu 18.04 and PostgreSQL. For the GUI, i am using pgadmin4 (browser version). I created a new database and when trying to restore, the following error message comes up:
<!DOCTYPE ...
0
votes
1answer
25 views
Restore previous version of database in sql server
I need your help on restoring previous version of database on SQL Server.
In last week I restored database 'A' in DEV server with it's production copy and didn't realize that this database 'A' in ...
1
vote
1answer
33 views
PostgreSQL - do we need to DROP the database and recreate it if we want to RESTORE it?
I worked with many different databases (SQL Server, Oracle, IBM db2) and for all of them if we have a backup it is just enough to execute RESTORE command in order to restore the data.
I am beginner ...
0
votes
0answers
21 views
Log shipping - Secondary Server
I am not a SQL Server DBA but I need some advise. I am having a problem with a prod server that’s being pounded by constant queries and data mining. I have a second server that I would like to setup ...
1
vote
1answer
29 views
Legacy data migration to Always on Availability group database
In our application there is a data conversion process that brings all the legacy data to the production database.
Since our database is on availability group and the migration might bring 100GB + ...
0
votes
0answers
8 views
What are the considerations when restoring an Oracle db from control file instead of RMAN catalog?
I have a customer that needs to make a testing restore of its Oracle 11.02g database. The destination host is not the source host (so the structures of directories may not be the same). They use ...
0
votes
0answers
16 views
Migrating AWS RDS SQL Server to a smaller RDS instance
I am in the process of migrating an AWS RDS SQL Server to another instance of AWS RDS SQL Server with lesser storage. AWS folks suggested using the native backup/restore option instead of DMS.
Steps ...
6
votes
2answers
975 views
How can I restore a master database from its bak file?
During a penetration test I found multiple .bak-files for an MSSQL database. I want to restore them all. In a Windows VM I installed SQL Server 2017. For restoring the master database, I put the ...
0
votes
1answer
35 views
Can you restore purged MySQL binary logs?
I have two situations I need some clarification.
1) Let's say I made a backup of all the MySQL binary logs before I purged a single binary log file (the oldest one, possibly the very first one).
...
0
votes
0answers
24 views
error while restoring database from mysql: ERROR 1006 (HY000)
I made a mysqldump from all my databases prior to fully deinstall and reinstall MariaDB. while restoring the databases with the following command, logged in as root:
MySQL -u root -p < /mnt/...
0
votes
0answers
10 views
Migrate data from database on MarkLogic 7 to database on MarkLogic 9
I need to copy data from a MarkLogic 7 database to MarkLogic 9 database on another system. I tried backup and restore option provided by the MarkLogic Admin console. The original database in MarkLogic ...
2
votes
1answer
28 views
How to attach a sql db with blobs using a shared folder?
I use the following query for attaching a sql db:
CREATE DATABASE [myDb] ON
(FILENAME=N'C:\myDb\myDb.mdf'),
(FILENAME=N'C:\myDb\myDb_log.ldf'),
(FILENAME=N'C:\myDb\FILESTORE')
FOR ATTACH
In ...
0
votes
0answers
15 views
how to restore partial-backup created using xtrabackup
I had to take a backup of a single database in my MySQL server of size 2.4 TB. I used percona xtrabackup as mysqldump was taking forever. I used below command for it:
xtrabackup --backup -u user -p ...
0
votes
1answer
30 views
Restore database from a save
I use pgadmin 4 and PostgreSQL
I try to restore a database from a save.
I have put the directory of my file save C:\Users\H2O\Desktop\temp_DB\ as a binary path in file preferences.
When I try to ...
0
votes
2answers
28 views
Took a full backup of a running mariadb server and restored, but none of the databases are visible
I'm setting up a mariadb galera cluster to ultimately switch production to. However, I don't have the ability to stop the production instance so I'm trying to set this up using various workarounds I'...
2
votes
1answer
41 views
Oracle isn't restoring correctly a backup
First of all I'll say I'm using:
Oracle Database 11g Express Edition
Oracle SQL developer
What I'm trying to achieve
Create a backup and restore it, so for example I can delete a table after a ...
0
votes
0answers
47 views
Restore a 140GB - 292 Million entrie MySQL-Database faster?
i need help. I have an old innodb Server and my storage limit reached.
I dont use files per table entries because in old times there were no ability at this time. My ibdata grown up fast and there is ...
0
votes
1answer
27 views
How to restore output from pg_dump into a new table name
I am dumping a large postgres table (~15m records) like this:
pg_dump -h myserver -U my_user --table=mytable -Fc -Z 9 --file mytable.dump mydb
The above creates a mytable.dump file. I now want to ...
0
votes
0answers
118 views
RMAN restore error to restore archivelogs
I have this backup piece with the archivelogs:
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ -------------------
54 1.01M DISK ...
1
vote
1answer
58 views
Having a backup of the master key, how can I restore a database that was encrypted by master key?
while setting up AlwaysOn - Availability Group on a test system,
I generated all the restores from live and restored them to this new server.
then I backup all these databases to a network share to ...
1
vote
1answer
27 views
pg_restoring into a table with a not null column
I'm merging two databases. The newer one has a table with an integer column failed_port which is NOT NULL. The older database does not have this column.
So after using pg_dump to dump both ...
1
vote
1answer
88 views
How to specify column positions in insert statements generated by pg_dump?
I need to add a column to a specific position in a table. I'm doing this because I'm merging tables from two different databases:
DB1.schema1.table1 has these columns:
name_pk | date | type
while ...
7
votes
1answer
168 views
After Restoring Log Shipping to Secondary Server, First Stored Procedure Execution is Slow
We've set up log shipping to a secondary SQL server on Standby/ Read-Only to offload all SSRS report generation.
This works fine within the restrictions imposed by:
Kicking out the user during the ...
