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,102
questions
0
votes
1answer
11 views
How to create multiple azure sql database in an elastic pool using powershell script?
I want to create a sql server and deploy the elastic pool on that server. Then create multiple azure sql database in that elastic pool using powershell script.
0
votes
0answers
33 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
query ran :
SELECT session_id as SPID,wait_type,wait_resource,last_wait_type,
command, a.text AS Query,...
1
vote
1answer
44 views
Restoring a MS SQL Server database on Linux
I am running Manjaro Linux and I am trying to restore a Microsoft SQL Server database from a .bak file.
I am trying to follow the official documentation, but it doesn't seem to work!
➜ ~ sudo ...
0
votes
0answers
27 views
Restore database with .idb .frm and logfiles
I recently had an error with my SD card inside my RaspberryPi4. (I'm very inexperienced with databases as well.) So this means that I have to restore my database. What I did was copying all the files ...
8
votes
1answer
527 views
Is it possible to determine the default Collation and server version of a database without a full restore?
I work for a company who regularly receives large SQL database backups from clients for support purposes. We support multiple SQL versions and collations, but currently have to manually confirm our ...
0
votes
1answer
31 views
SQL Server AG secondary replica database still in Restoring mode
I created an AlwaysOn in SQL Server 2019 and I selected the Full Database and Log Backup option. Now it created a database in secondary replica but it is still in Restoring mode. My DB size is 16MB ...
0
votes
1answer
26 views
Differential Backup of A Table In Sql Server
I will transfer the datas of a two different table to a database in reporting server Daily but i don't want to do it manually and also don't want to transfer all the datas to that databases everyday. ...
0
votes
1answer
37 views
Auto-Shrinking All Databases Files To Their Minimum Size In Sql Server
I restore my all databases in production to my development environment monthly. Development server has 4 TB disk space and there are 4 different instances over it which containt databases on the ...
0
votes
0answers
14 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 ...
3
votes
5answers
157 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
1answer
19 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 ...
0
votes
1answer
82 views
problem with the restored database [closed]
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 ...
1
vote
2answers
33 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
111 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
39 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
0answers
34 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
5answers
111 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
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) ...
3
votes
1answer
39 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
45 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 ...
0
votes
3answers
54 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
46 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
50 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 ...
1
vote
1answer
60 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 ...
0
votes
1answer
26 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
49 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 ...
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
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
32 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 ...
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 ...
1
vote
1answer
24 views
Can you Identify the sql server name from sql backup file(.bak)?
I have a backup file from an SQL 2016 server and I need to identify which SQL server the file was created on. Is there a way to identify the original SQL server where the file originated at? Thank ...
0
votes
0answers
14 views
how to restore wal file that is in tar format in postgresql
I am trying to use incremental backup provided by postgres. It is working if I copy the WAL files as it is in another folder and then recover. But if I make .tar.gz of WAL file then try to recover db ...
0
votes
0answers
13 views
RMAN restore / recover
this is probably a simple question, but I'm not finding an answer which I deem correct.
So at this organization, they take a weekly backup using RMAN, ship those to a standby server, and perform a ...
2
votes
1answer
287 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 ...
0
votes
1answer
31 views
how to upgrade postgresql 9.0.4 to latest with minimum downtime
I have master-slave-slave setup for postgresql 9.0.4 in our production setup.
We need to upgrade it to latest (11.X), so my question is what would be the procedure to do so with as little downtime as ...
0
votes
1answer
187 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 ...
13
votes
1answer
2k views
Temporarily moving a SQL Server 2016 database to SQL Server 2017 and then moving back. Is it possible?
If I take a backup of a database from a SQL Server 2016 instance and then restore it to a 2017 instance to do some work on it.
Can I then turn around and back up that database from the 2017 instance ...
1
vote
2answers
77 views
Does restoring a database in Microsoft SQL Server add objects to Resource Database?
As far as I know the resource database contains information on all objects in its server instance, so I would think it's only natural that when you restore a database from a backup file, part of the ...
1
vote
2answers
86 views
Sql Server Restoring Process Time Takes Too Long Time
I have 7 databases on my reporting server. I restore those databases every night with differetial backups. Normally, the differential restore time was taking about 1 or 1.5 hour for each databases. ...
1
vote
1answer
68 views
What is the purpose of keeping filegroup or filestream backup in MSSQL?
I'm a new DBA for SQL SERVER. Currently I'm learning about filestream on SQL server. So I tried to restore only filegroup of filestream to other database, but I get an error message:
An exception ...
3
votes
2answers
129 views
SQL Managed Instance - Cross Subscription Restores/Migration
Short Version:
I am trying to restore a backup from one SQL Managed Instance to another SQL Managed Instance. These are in different subscriptions. Using Example 3 from here I can at least get it ...
3
votes
0answers
328 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 ...
1
vote
1answer
111 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
52 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
221 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
113 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
32 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 ...
