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
0answers
21 views

This is a question about hash index. I'm not sure about the correct answer

I think the answer of the first question is 2^(n-na) and the second question's answer is p*2^(n-na) + (1-p)*2^na. is it correct? But what about the third question?
0
votes
1answer
174 views

Restoring a FrontBase database

I have a FrontBase database that I am trying to restore. This is a database system I have no experience up until now so this may be a basic question. I am issuing the following command to restore c:\...
-1
votes
0answers
37 views

If you were the DBA, which indexing alternative you would choose [closed]

consider the relation EMP(ssn, name, salary), with the following specifications: • it has ssn as the primary key, • it has n tuples, each 50 bytes long, • there are many, exact match queries on the ...
1
vote
1answer
76 views

problem with the restored database

I have a database storing user login credentials of my application in a Table. When I backed up and restored my database to another server, the restore is successful but the login is timing out (SQL ...
0
votes
0answers
10 views

Single-tenant to multi-tenant: restore old database to schema in new database

I have a Django app which uses Postgres as a database w/ the django-tenants package providing multitenant functionality. This is a migration from what was originally a single tenant database with just ...
0
votes
1answer
139 views

StorageEngineUsed set to TabularMetadata. For databases in this mode, you must use Tabular APIs to administer the database

I am an administrator in SSAS. I have many data warehouse servers. In some servers I have SQL Server and SSAS on the same machine. I successfully backup the SSAS databases and even check if the ...
1
vote
1answer
489 views

MongoDB Unrecoverable Failure

My machine (OSX) had a power failure and when restarted, I have one db in MongoDB that is completely unrecoverable. I am using the db per directory with dbpath and logpath specified options and was ...
3
votes
5answers
133 views

Restore a database with a different name on the same server

I need a copy of a live database called Carers on the same server for testing purposes. The test database name will be Carers_Test. I took a backup of Carers using SSMS. And tried to restore it using ...
2
votes
2answers
305 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 ...
-2
votes
1answer
17 views

Deleted oradata folder under oracle home by accident

While setting up a new server, I accidentally deleted the oradata folder in the working Database server. I have no backup of the working database, I googled and found flashback option to recover, but ...
1
vote
2answers
30 views

restoring to new db putting old db into restore

The image below says it all. I need to get some data out of a back-up that's two weeks old, so I restored to a new db called ETLFix. However, when I started the restore my production DB, ETL went ...
3
votes
2answers
107 views

Restore from SQL Server 2008 to 2014

When a full-backup is restored by the DBA, does the DBA need to restore permissions, users, and roles separately? Or does it all come with the full restore? I am from the dev team. We are migrating ...
0
votes
1answer
34 views

Restoring a Database Using Full Backup and Transaction Logs in SSMS

I have a full backup file (.bak file) of a database for the 25/10/2019. However I want to restore the database to the 21/10/2019. My problem is that I do not have the full backup files for the 21/10/...
0
votes
1answer
88 views

Having two data folder in my postgresql setup- Postgresql

I am using centos 6 and installed Postgresql_9.4 using the following commands yum install postgresql postgresql-contrib postgresql-client pgadmin3 yum install postgresql-server After that i ...
4
votes
2answers
2k views

what would be the right permission to allow everything else but overwriting or creating a database?

I have a test environment where the AD group mycompany\developers is currently sysadmin. Recently I have had some issues, specially regarding to people restoring databases. My concerns are: ...
0
votes
0answers
24 views

MySQL InnoDB Cluster - database backup restoration

I have a 3 node MySQL InnoDB Cluster. I wanted to restore few databases around 20 GB each. Please help me with following questions: Can I restore it on Read/Write node through MySQL Router? Do I ...
1
vote
1answer
29 views

RMAN Restore Validate time equals to actual restore time?

I'd like to know if the time to restore the database is equal the time using restore validate database. If not, How can I know how much time the restore will spend?
0
votes
2answers
219 views

Restore a database backup on another server without sysadmin account

I need to restore my own database backup on another server. On both servers I have the same user account name with limited privileges (eg WebUser). On the target server I can't use a sysadmin ...
-1
votes
1answer
255 views

Restoring more than one .bak files in a TSQL query

Can any one share a script that will allow me to restore all the .bak files in my one folder into SQL Server using a TSQL script?
0
votes
1answer
111 views

Restore user db from UNC

I need to create a job that restores all user databases from UNC to my SQL Server. All the backups, for 3 days, are located in the same folder and I need to restore the last modified backup. What is ...
0
votes
5answers
109 views

Restore DB Backup with limited amount of disk space

I want to restore a SQL Server database using a backup (.bak) of about 60GB. Is it possible to do this on a machine with only 100GB of free disk space? Or do I need at least the 60GB for the .bak ...
0
votes
1answer
109 views

Copy postgis layer from S3 to Heroku

I have a dump of a postgis layer (layer.dump), which I am trying to add to my heroku database (mydatabase). The postgis layer is stored on S3 (https://s3.amazonaws.com/layer.dump). I would like to add ...
0
votes
1answer
28 views

Automating database restoration of SQL Server transaction log files on standby mode

I am wondering if I get help from this house on the following issue. I have a standby database that should be restored with the set of transaction log files I get from the vendor's(eClincalWorks) ...
-1
votes
2answers
184 views

Can I restore only the LOG of a database?

We have a 1.5TB database. I could create some replication strategies do replicate the database to another server in a fixed time.But the developers don't know when they will need to replicate this ...
6
votes
3answers
9k views

Unable to create restore plan due to break in LSN chain

My backup plan is: Full backup - once a day Differential backup - every four hours Transaction Log backup - every 30 minutes. All database backup are stored on my computer. I add some wrong ...
3
votes
1answer
34 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
2answers
20 views

Restore mysql database with some columns content enclosed by " and another not

We have to restore a database in MySQL but some columns have content enclosed by " and another not like in this sample: 00.168.93.70,null,ES,0,htc,33a48a1515b20691,"htc;HTC One (REL4.4.2)",m7,...
1
vote
1answer
43 views

can I do a restore controlfile from autobackup out FAST RECOVERY AREA?

I know that I can issue the command restore controlfile from "location_here". But there is some config that can I do for issue the command restore controlfile from autobackup even whether the ...
2
votes
1answer
1k views

Issues with mysql enterprise backup, assertion failure on restore

I'm trying to restore a backup to a new server, but having some issues with corruption. The source server has a 2.5T table which is very active. I copied the latest backup over to a new server and ...
2
votes
3answers
114 views

Regarding Backup and Restore Strategy

I have some questions regarding backup and restore strategies. I want to take backup and restore of large databases approx. 60 to 70 GB and it is a critical database on SQL Server. Backup schedule ...
0
votes
1answer
43 views

How do I skip an offline database over the network in MySQL import?

I am doing a MySQL import from an *.sql file to multiple database location over the network. I'm using cmd batch file to run the command and it's working as I expect it to be. However I notice that ...
1
vote
2answers
31 views

Restoring Postgres from only base backup taken with wal-e

I have a postgres base backup taken via wal-e. Is it possible to restore and start the DB with just the base backup? I cannot use the restore_command in recovery.conf since the wal files are archived ...
0
votes
3answers
52 views

how to automate DB restore to another server?

The plan is to have 1 backup set that will contain full and transactional log backup. (Server1) There is already a scheduled job that will append any transactional log to the file after 30 minutes. (...
0
votes
1answer
1k views

Postgresql - Large object exists in pg_largeobject table but cannot open with lo_open?

I have a problem with opening Large Object in postgresql version 9.2, select * from pg_largeobject where loid = '19423'; will return data like this: loid oid;page no integer;data bytea 19423;0;"<...
1
vote
1answer
40 views

How to restore a database with innodb tables from files?

I am trying to restore a MariaDB database containing innodb tables from files. Blue-eyed as I am, I considered this an easy task: I just stopped the server, copied the files and restarted it as ...
1
vote
1answer
187 views

MonetDB auto-backup mechanic problem

I'm trying to set up mechanism that will automatically create database backup. The idea is to create a script that will be executed by crontab. Seems easy but I'm struggling with the following ...
-1
votes
2answers
152 views

MySQL InnoDB data restore using 3 files

I am able to restore MySQL table data along with structure with indexes (InnoDB Engine) using 3 files. MyTable.frm, MyTable.ibd and ibdata1. Can any body confirm, will these 3 files suffice to ...
3
votes
1answer
302 views

Restore Read Only FileGroups from File

I have a database DB in simple recovery mode with filegroups PRIMARY, A, B, and C. Each filegroup has a single file, PRIMARY.MDF, A.NDF, B.NDF, and C.NDF, respectively. First, I run: ALTER DATABASE [...
0
votes
1answer
23 views

Restoring MySQL 8.0 server from cold backup files

Recently, my database server running MySQL 8.0 crashed due to power outage. I have access to a cold backup (i.e., all physical files) of the server before the crash occurred. I do not have any other ...
0
votes
1answer
41 views

It's a good practice always restore controlfile before restore the database?

I'm beginner in Oracle, but I'd like know if it's a good practice always restore the control-file of a backup-set before restore the database. I ask this because always when I restore the control-file ...
1
vote
1answer
200 views

What is wrong with my RESTORE procedure? [closed]

I'm trying to use Toad Freeware (my SSMS is totally broken) for the following restore command: RESTORE DATABASE AdventureWorks2016 FROM DISK = 'C:\Database\MSSQL\Samples\AdventureWorks2016CTP3.bak' ...
2
votes
1answer
193 views

How to maintain database ownership restoring across domains?

I am working with a vendor who is developing a SQL Server database outside of our domain. Occasionally, they need to deploy a new copy of that database into our domain by backing up their database, ...
1
vote
1answer
45 views

Restore plan cache and buffer pool after database restore? [duplicate]

When restoring a database, is there a way to restore the plan cache so it doesn't have to be re-created during production use? Similar question: is there a way to pro-actively restore the buffer ...
53
votes
7answers
20k views

Is it possible to quickly create/restore database snapshots with PostgreSQL?

First of all, I'm a developer, not a DBA or sysadmin; please be gentle :) I'm working on an application workflow where a single user action will trigger complex changes in the database - creating ...
-1
votes
1answer
226 views

barman + barman can show the details from backup directory

we have linux machine as backup server with barman tool when I want to see the details backup with the command barman show-backup then I get the following exceptions # barman show-backup main-db-...
0
votes
1answer
39 views

Restore database with Availability Groups

I have high availability enabled with two servers and when trying to restore a database I realised I had to un-synchronize the database and then remove it from the availability group. I use Ola ...
0
votes
0answers
37 views

DB Maintainance Job Fails Single User Mode

we have a stored proc where we rebuild indexes and also take Backup of filegroups.Following is part of the code. But this job is failing since few weeks for error message : Error : Executing the ...
1
vote
1answer
109 views

RESTORE database now in Emergency

We have a database that was basically used for application purposes but it was using "master" - bad indeed. We created a new database called school that is now being used (same structure as how master ...
1
vote
1answer
58 views

Backup too big to restore

I have a backup which in file explorer is roughly 160GB. If I run select sum((size*8)/1024) From sys.database_files where type=0 I get a result of 169493, fine. When I try to restore this ...
1
vote
0answers
29 views

How to force SQL Studio not to use copy-only backups to build database restore script?

How to force SQL Studio not to use copy-only backups to build database restore script? I want to ommit copy-only backup (because it's not longer available) and force studio to use last full backup (I ...