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,118
questions
1
vote
1answer
32 views
minimum space is required on disk to restore a backup in SQl Server?
Suppose I am going to restore a backup (2 GB) in my sql server, I have sufficient space (20 GB) in my disk, but is there any algorithm that SQL server follows to calculate the minimum disk space ...
4
votes
0answers
43 views
how to remove all permissions in a database?
every time I need to either restore a database or reinitialize a replication publication I first (on the restored to be or subscription database) I script all the permissions, triggers, indexes, ...
0
votes
4answers
94 views
Granting a user a permission to restore a database
In a database I created a user with the following roles:
Server Roles
public
Database roles
db_backupoperator
db_ddladmin
db_datareader
db_datawriter
The problem is I don't want to change his ...
2
votes
2answers
67 views
How does the actual restoration works in SQL Server internally?
Suppose my Database DB1 lost some data, but I have a Full, Differential and then followed by Transaction log backups.
Till full\Differential backup I can understand it is like the snapshot of the ...
0
votes
1answer
40 views
In SQL server during Log Shippping which portion (active\Inactive) of the Log file (.ldf) backup is taken and further restored in SQL Server
I am confused, like if we take the backup of the whole log file, wont it clear the transaction log though we have copy only backup.
In log file we have 2 parts, like active and inactive logs, in ...
0
votes
0answers
39 views
SQL Server database restore from backup changes all dates with datetime2 type return with values to future dates
I'm trying to restore a SQL Server database from a .bak file.
The process completes without any issues, but the dates with datatype datetime2 are presented with totally different values (change to ...
0
votes
1answer
47 views
ORACLE DB literal does not match format string
I' am having this error:
ORA-01861: literal does not match format string
01861. 00000 - "literal does not match format string"
*Cause: Literals in the input must be the same length as ...
1
vote
2answers
26 views
Oversize DB restore to SQLExpress
I made a back of an express DB, it was 14.7GB big (how is this possible) but anyway, I need to restore it back to express but obviously it is too big, but there must be somehow I can do this. I need ...
1
vote
1answer
15 views
PostgreSQL - WAL segment file creation and naming conventions
I was under the impression that WAL segments files are normally generated before they are being written to and archived, and are continuously renamed and reused to save disk space. I was wondering if ...
0
votes
0answers
19 views
Restore got failed in sql server
While i restore my database i got the below error. But i have more space in my drive.
modify file encountered error 112 (Ther is not enough space on the disk)while attempting to expand the physical ...
0
votes
2answers
55 views
Restore database stuck at 100% progress
We are seeing restore taking more than 25 minutes for a simple 4 mb file .Restore progresses to 100%,but it wont update any status from there
When checked in error log ,we could see below error...
...
0
votes
0answers
21 views
Is It Possible Backing Up Postgres Backups To Windows Backup Server With PgBackRest
I want to take my postgres backups to our backup backup server which works on windows server, with pgbackrest. My postgres databases are on CentOS/7 OS. I can take those backups to my local but i want ...
0
votes
1answer
36 views
Oracle SYS views missing from DB instance [closed]
Hi i have a question but not sure what the problem was and how it happened though.
The initial error when i logged in the DB dev machine was ORA-00942: table or view does not exists. Some of the ...
0
votes
1answer
27 views
Speedup restore of 160 GB SQL in 24 core + Optane NVME system
i set up a new sql-server, ubuntu 18.4 (MYSQL 5.7), 24 core (48 threads), 256G RAM, System is SATA Raid1 XFS SSD /var/lib/ is mounted on Optane SSD XFS.
In restore i can see that the server has unter ...
-1
votes
0answers
35 views
Recover Lost or replaced database
I have got in a big trouble !
I was trying to restore a database in an empty one.
I put the restore files in D directory of Windows, then create a new empty database and tried to restore that files in ...
0
votes
1answer
45 views
Piecemeal restore only one filegroup without primary filegroup restore
I have a db in SIMPLE recovery model, and regularly take FULL,DIFF backups.
This db also have filegroups for each month.
Each filegroup has exactly one NDF file.
Like this:
FileGroup: PRIMARY
File: ...
0
votes
1answer
20 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.
1
vote
0answers
92 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(connection context is master)
query ran :
SELECT session_id as SPID,wait_type,wait_resource,...
1
vote
1answer
58 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
34 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
536 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
46 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
27 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
40 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
19 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
231 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
23 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
35 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
42 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
52 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
32 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
113 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
30 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
42 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
25 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
57 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
55 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
49 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
68 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
72 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
29 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
43 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
52 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
33 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
42 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
27 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 ...
