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,436
questions
-1
votes
2
answers
262
views
get data from express edition db to developer edition [closed]
How to get database in new created SSMS sql server developer edition but I don't have back up of database but mdf file and ldf file are available.
1
vote
2
answers
9k
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
0
answers
304
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. ...
4
votes
2
answers
1k
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 ...
3
votes
1
answer
11k
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
1
answer
486
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
1
answer
1k
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 ...
6
votes
3
answers
9k
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
1
answer
348
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
0
answers
58
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
1
answer
1k
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
0
answers
15
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 ...
3
votes
2
answers
365
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 ...
6
votes
1
answer
885
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
2
answers
180
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
1
answer
1k
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
1
answer
230
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
1
answer
70
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
1
answer
4k
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
3
answers
756
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 ...
4
votes
1
answer
10k
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
0
answers
42
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
1
answer
69
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 + ...
7
votes
2
answers
3k
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
1
answer
496
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
0
answers
340
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/...
2
votes
1
answer
529
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
1
answer
901
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
2
answers
277
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
1
answer
374
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
0
answers
819
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
1
answer
2k
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 ...
1
vote
1
answer
1k
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 ...
2
votes
1
answer
340
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
1
answer
2k
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
1
answer
464
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 ...
-1
votes
1
answer
70
views
Database in restoring state and transaction duplicates
I use following PS script to restore database:
$sqlScript = @"
USE master
GO
ALTER DATABASE mydatabase SET SINGLE_USER WITH ROLLBACK IMMEDIATE
GO
RESTORE DATABASE mydatabase
FROM DISK = '\\...
4
votes
1
answer
698
views
Point in time Restore failed - Error 3456 'Could not redo log record'
I have a database from which all tables got deleted by accident. Unfortunately we do not have a 'perfect' backup and now my problem comes in:
FULL Backup is from yesterday, 18:00
LOG Backup wasn't ...
4
votes
0
answers
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 ...
1
vote
0
answers
3k
views
how to dump mysql schema without keys and without constraint ? and keep all of them to alter afterwards
i am using ubuntu 16.04 and want to dump large schema with hounded of tables from AWS rds, remove all keys and foreign key , load data and then add back the keys , is there any automatic tool that ...
1
vote
1
answer
2k
views
How to restore mysqldump of one database in different databaseName with content of data in the same host machine
Let's start from the beginning there is a MySQL database with name DB1. As I want to restore the mysqldump backup of DB1 database in DB2. The DB2 database is another database in same Host Server ...
2
votes
2
answers
41
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 ...
0
votes
0
answers
124
views
How to speed up MySQLl loading from dump file?
I'm using mysqld Ver 5.7.25-0 in Ubuntu 16.04. I dumped from AWS Relational Database Service (RDS) with mysqldump --single-transaction --quick --max_allowed_packet 1G ... and now when I tried to load ...
0
votes
2
answers
4k
views
User and login mapping after an SQL Server restore
I need to restore a DB from an SQL Server instance to another and I am well aware that the DB users will be transferred but the logins won't. I have created a script to be able to create the logins on ...
2
votes
1
answer
741
views
Having the backup file, how to work out the total disk space required to do the restore?
I have a nice query that gives me the date of last full backup, size and location, even when I backup to multiple backup files.
what I don't have is an estimate of the total backup size (for each of ...
0
votes
2
answers
145
views
Recover all databases to a new server
I need to copy an entire SQL Server instance, with all databases from one server to another server in my test lab.
I am aware that this can be done the "cold way", by stopping/pausing the databases ...
1
vote
1
answer
71
views
Piecemeal restore, filegroup and file extension
As per my understanding (so far) any given user database contains three types of files - mdf, ndf and ldf.
MDF stands for meta data file and stores data definition as well as data (in case of small ...
1
vote
0
answers
53
views
Couchbase backup and restote through copy data files
I was exploring couchbase backup and restoring procedures then we found standard procedures. But, if I can take data directory backup in the form of .tar and untar data directory whenever restore ...
-1
votes
1
answer
6k
views
Restore database - Operating system error 5(Access is denied.) on Linux
I try to restore SQL Server 2017 Express database using sqlcmd tool on Ubuntu 16 Server.
My SQL command is:
RESTORE DATABASE [xxxxx] FROM DISK = N'/home/xxxxxx/DBBackups/xxxx.bak' WITH NORECOVERY, ...
4
votes
1
answer
658
views
Does restoring a database break external synonyms targeting objects in that database?
If one has a database where synonyms in another database refer to objects in that database, does restoring a backup into that database invalidate the synonyms?
To be specific, imagine this situation:
...