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

Is it possible deleted partially?

I executed delete query delete from [table_name] After execution, I found that 'where clause' is wrong so I cancelled the query using cancel buttion in SSMS. and then I counted the table record. I ...
gnc's user avatar
  • 1
5 votes
1 answer
644 views

How to restore transactions after full backup

I am moving my SQL Server database to a new windows machine, however, I do not want to lose any transactions during this process. I have been unable to find anything around this anywhere which this ...
user avatar
2 votes
2 answers
112 views

Are SQL Server stored procedures backed up by default?

We have two servers running SQL Server 2019 (15.0.x). When we do a full database backup (by right-clicking the data base, then Tasks, then Backup), does that include backing up the all items under ...
FreeMan's user avatar
  • 221
-1 votes
1 answer
42 views

Understanding "Size" Column in RESTORE FILELISTONLY for Differential and Log Backups in SQL Server

I'm trying to understand the meaning of the "Size" column in the output of the RESTORE FILELISTONLY command in SQL Server when it's used with differential and log backups. For full backups, ...
Fajela Tajkiya's user avatar
0 votes
0 answers
52 views

after restroring tablespace table or view not exists

I've Oracle CDB with PDB In the PDB I created a tablespace then I created a table over this tablespace after that, I login into RMAN for the CDB database then I make a backup using backup database ; ...
Tariq Hajeer's user avatar
0 votes
1 answer
251 views

Restore backup global using pgadmin

I created backup global by rightclicking Postgres 15 in pgadmin It generates .sql file. How do i restore the backup global in pgadmin ? I tried searching on google but didnt found the answer
LLL's user avatar
  • 101
0 votes
1 answer
43 views

SSISDB rename for maintenance

We have an SSISDB database that has become too large and we wanted to do some maintenance on it. I've read that you shouldn't rename the SSISDB database as it would break links to existing packages, ...
Nolan St. Martin's user avatar
0 votes
0 answers
70 views

can I recovery specific table from .DBF files in oracle?

I have oracle 19c on windows10, I accidentally corrupted my System TABLESPACE file(Description). But my USERS tablespace Not damaged, Can I recovery my tables from this file on windows? I haven't any ...
henrry's user avatar
  • 121
0 votes
1 answer
574 views

Mysqld won't start although lower_case_table_names is 0 and match the data dictionnary

I copied a mysql 8.0.26 database from a Linux server to my Windows box but mysqld won't start. Either it's this (with lower_case_table_names=1): [ERROR] [MY-011087] [Server] Different ...
Micromega's user avatar
  • 111
0 votes
1 answer
57 views

How does sql server derive the `Restore As` value?

When I'm restoring a database, it is auto populating the original file name and restore as. The check box (relocate all files to folder) is to change the destination path. No matter if this checkbox ...
variable's user avatar
  • 3,541
2 votes
2 answers
365 views

Why recover database request archived log from the future

It suddenly throw error when I trying to do our monthly backup verification, it failed on recover database command with : ORA-00279: change 26378396150 generated at 05/31/2023 03:52:48 needed for ...
Agung SV's user avatar
0 votes
1 answer
193 views

While restoring from mysqldump file, how do I write the table names to a log file?

Sometimes I've run into situations where developers have changed structures, added/removed columns on different DB servers, environments, etc for the same table and this causes errors such as ERROR ...
site80443's user avatar
  • 119
0 votes
0 answers
126 views

postgresql with timescaledb backup/restore and upgrade issue

My customer is using TimescaleDB 2.3.1 at PostgreSQL 11.20. We are trying to upgrade PostgreSQL and Timescaledb currently I installed PostgreSQL 13.11 and and TimescaleDB 2.11.0 I backedup the ...
Murat Suluhan's user avatar
0 votes
1 answer
81 views

Unable to use data pump utility in Oracle to import data to another server

I am using this command: impdp atif/[email protected]:1521/serv1 DIRECTORY=DATA_PUMP_DIR DUMPFILE=mltpltblbkp.dmp LOGFILE=mltpltblbkp.log to import data from one server to another. this is my ...
dbafix's user avatar
  • 54
1 vote
1 answer
77 views

Worst performance multiple left join big tables after restore DB

Problem Database: PostgreSQL 13.8 (Debian 13.8-0+deb11u1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit After migrate from DigitalOcean to strong Dedicated Servers ...
M. Garbarczyk's user avatar
0 votes
1 answer
125 views

SQL Server database not able to update after restoration

We are migrating an application's database between servers and we have used the Attach method to attach the database files to the new location. After re-pointing the application to the new database ...
ETA's user avatar
  • 1
1 vote
0 answers
283 views

Mariadb large live database dump/restore fails when using recommended options

I have a 58Gb database that is live, using InnoDB engine and I want to dump restore it to a development machine for test purposes. I'm using mariadb 10.4 client and servers on Debian 11 Buster. I've ...
Eamonn Kenny's user avatar
0 votes
1 answer
301 views

This backup set cannot be applied because it is on a recovery path that is inconsistent with the database

I am trying to insert hourly log files after a database has been changed from: "Standby / Read-Only" mode to regular (online) mode to "Read-Only" mode to "Restoring" ...
Java's user avatar
  • 223
3 votes
1 answer
266 views

Keep smaller databases out of an availability group (and recover via backup) to avoid cluster/AG issues taking the db offline?

We have several availability groups and each one has a mix of large databases and small databases, all critical. They're all asynchronous commit because their secondaries are in a different data ...
Bobogator's user avatar
0 votes
0 answers
96 views

Stuck in Rollback of restore operation

I have started a restore operation, in which backup file is in Backup Server. After an hour I cancelled the operation; in order to copy the file into the local server and start the operation again. ...
Meyssam Toluie's user avatar
4 votes
1 answer
216 views

Unable to restore database with datetime2(0) in Partition Function

I have a SQL-Server database with large table that partition by a datetime2(2) column. Some (old) filegroups marked as READ_ONLY. Periodically I make the backup with READ_WRITE_FILEGROUPS option. I ...
Oleg's user avatar
  • 43
1 vote
1 answer
332 views

How to move mdf file to other disk drive when it is "Standby / Read-Only" mode?

I am trying to change the location of mdf and ldf file from one disk drive to other disk drive due to storage limit. Currently, the database that I am trying to move to other drive is in "Standby ...
Java's user avatar
  • 223
0 votes
0 answers
101 views

install database backup from SQL Server 2017 to local PC with SQL Express 2022

I am assisting a client who has recently retired from his original business and is setting up a smaller professional property management partnership. He has been instrumental in setting up a tailored ...
Frank Kay's user avatar
0 votes
0 answers
139 views

Import error 31 on SQL Server RESTORE

Background I'm attempting to build a vagrant box to share amongst the dev team who use a variety of different languages and systems. One of the databases is SQL Server. I have successfully set this up ...
elb98rm's user avatar
  • 133
0 votes
1 answer
127 views

Would MySQL Replication (master-slave) have prevented this problem?

I'm new to the idea of MySQL Replication (mainly because I've never really had data important enough to have redundancy until recently). Today I had a random crash of my MySQL 8 database with the ...
Ethan Allen's user avatar
2 votes
1 answer
236 views

SQL Server - Restoring backup with SQL Server Management Studio restores another database than running a 'restore backup' query

These are the steps I have performed: I have run a 'restore backup' query for an old database backup Then, I restore a backup with SQL Server Management Studio. I changed the type of some columns and ...
Guido Passage's user avatar
0 votes
1 answer
533 views

Cannot open backup device 'D:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\Backup\‪D:\DB_backup\uni.bak'

I have 2 database backup files casa.bak (25 GB) and uni.bak (176 GB) in the same folder. I'm using the same script to restore the database for both files previously both were working successfully. Now ...
Muzammal arshad's user avatar
0 votes
1 answer
473 views

Postgresql Sequence Hopping

I have recently migrated (dump and restore) my database from AWS RDS PostgreSQL v12 to Aurora Serverless v2 PostgreSQL v14.6. The issue is we have setup sequencing in a table on old RDS, now in the ...
sam's user avatar
  • 11
3 votes
1 answer
237 views

During an online piecemeal restore, is it possible to restore to a point-in-time?

I have a database (full recovery model) with multiple filegroups, that each have full and diff backups. I am able to replicate an online piecemeal restore (SQL Server 2019 Enterprise Edition) as it is ...
Matthias L's user avatar
0 votes
1 answer
99 views

SQL Server 2019 - Take backup of a single table from a secondary filegroup using SSMS

I am working a database with a size of 325 GB total. Out of this a single table Documents is occupying 321 GB storage and the rest of the 84 table occupy the remaining space. As the database is ...
user avatar
0 votes
1 answer
184 views

Exporting via Phpmyadmin Charset

MySQL 5.7 I am exporting my db from my web host using phpmyadmin. This produces a single .sql file. When I check the export with Notepad+, there are special characters in the file. e.g. in my source ...
TheOrdinaryGeek's user avatar
0 votes
0 answers
136 views

Dealing with Corruption

I started getting Error 823 alerts from my SQL Server. When I checked SQL Server error log, I found lots of this: A read of the file 'path\to\my\file.ndf' at offset 0x00000d5f850000 succeeded after ...
Sicilian-Najdorf's user avatar
0 votes
1 answer
134 views

Unable to restore a restore a MSSQL db from .bak file because of size unavailablity in disk

I need to restore a database from a .bak backup. When i tried it is showing insufficient disk space becuase the mdf and ldf files are also moving and in those ldf is aroud 100GB. Is there a way to do ...
Nidal K I's user avatar
-1 votes
2 answers
413 views

Unable To Execute restore Operation

I tried to run this SQL statement: RESTORE DATABASE test1 FROM DISK = N'D:\Projects\Billing DB\Test1.bak' WITH REPLACE; but all I get are these errors: Msg 5133, Level 16, State 1, Line 1 ...
user avatar
2 votes
0 answers
184 views

Getting the "Database cannot be opened. It is in the middle of a restore.", when using a different database

Problem We have an everyday process of restoring a DB from backups to kind of replicate it on another server (yes, I know it's not the way to do that) and encountered a rather strange problem. Process ...
Arkatias's user avatar
1 vote
1 answer
152 views

MariaDB / (MySQL ?) point in time recovery

I am trying to get know the exact workflow of point in time recovery, or more general using the binary logs for backup/restore (meaning: using binary log files with mysqlbinlog) This is important not ...
g.pickardou's user avatar
1 vote
1 answer
718 views

Function does not exist then dumping mariadb database to remote host

Im trying to do an initial transfer of my data to a replica server by running this command: sudo mysqldump -f -u root -pPassword --opt mydb | mysql --host=replica01 -C mydb -u restore -pPassword It ...
jared's user avatar
  • 113
0 votes
1 answer
59 views

Azure SQL Database - Restore options for Continuous Integration Builds

We have a Azure SQL Database (PAAS) that acts like a master database for testing new code. The goal is to set up a pipeline that creates a writeable copy of the master database to test new builds ...
Raadee's user avatar
  • 425
1 vote
0 answers
2k views

pg_restore error could not execute query: ERROR: relation does not exist

I am trying to restore, on the same server but different database, a specific table from a dump file using pg_restore. This table is located on public schema and I want to restore it on public schema ...
padjee's user avatar
  • 177
0 votes
0 answers
439 views

SQL Server - Exclusive access could not be obtained because the database is in use

Took backup of database from SQL Server 2008 R2 Enterprise and trying to restore it on a database on SQL Server 2019 Enterprise but getting error: Exclusive access could not be obtained because the ...
Frank Martin's user avatar
0 votes
1 answer
298 views

How to restore Mongodb db with collection.wt and index.wt files

I have collection-0-xxx.wt and index-0-xxx.wt files simply copied from another dbpath. I am wondering if those files are enough to restore the data in MongoDB. If yes, how can I do that? If not, what ...
zurich_ruby's user avatar
0 votes
1 answer
386 views

Disable tail-log backup default

Is there any way to globally set "take tail-log backup" to unchecked in MS Sql Server? I would like to not have to switch to options and disable this option every time I restore a copy from ...
Alex Abramov's user avatar
2 votes
1 answer
225 views

How to (pg_)restore selected tables with all indexes?

I would like to restore selected (currently after -t) tables including all indexes without making a definition after -I - because indexes are changing, new ones are created, old ones may expire. What ...
user avatar
1 vote
1 answer
174 views

How do I restore a schema in Cassandra?

This is an example scenario and we wanted to understand if it would be possible to recover it. And also understand better about the schema. In a hypothetical scenario of just 1 node, Cassandra 3.11. I ...
Gustavo Ciria's user avatar
0 votes
1 answer
233 views

Sql Server Management Studio does not have access to a .bak file on a remote server

I'm trying to restore a database backup that is on a server. This server is on a remote machine and runs in a docker container. The container OS is Ubuntu 20.04. I can access the database, make ...
Leonardo Silva's user avatar
0 votes
1 answer
64 views

Percona 8 MySQL server restart while restoring backup

I have a problem with Percona 8 on Debian 11, I installed the latest version of Percona 8 for MySQL server, 8.0.29-21 I set these configurations in the mysqld.cnf innodb_buffer_pool_size = 12G ...
Khaled Hussein's user avatar
5 votes
1 answer
660 views

Rebuild of DB fails, yet size of the DB has doubled

I attempted to rebuild all the indexes of a DB using the query, USE [DB_Name]; GO DECLARE @TableName VARCHAR(255) DECLARE @sql NVARCHAR(500) DECLARE TableCursor CURSOR FOR SELECT '['+...
theindianvenom's user avatar
0 votes
0 answers
114 views

Accidentally drop of collection on shard of sharded MongoDB cluster

I have accidentally triggered a drop collection command on one replica set (primary-shard) of a MongoDB sharded cluster (no secondary shards). Unfortunately now I can not access the data of this shard ...
honigbrot's user avatar
1 vote
2 answers
1k views

In PostgreSQL how do I generate a script that will recreate the database and all of its contents?

I'm trying to generate a SQL script that will recreate a Database I have on my installation of PostgreSQL but I have not been successful yet. I'm able to create a backup file of my database using the ...
JTD2021's user avatar
  • 37
0 votes
1 answer
348 views

Backups cannot be restored on AWS RDS - View creation problem. Access denied; you need (at least one of) the SUPER, SET USER privilege(s) for this

The environment is MariaDB 10.6.8, via Amazon RDS. We have all 'admin' rights but not SUPER on AWS databases. I have a view in an application that has it's data stored in a single schema. We use non-...
J. Gwinner's user avatar

1
2
3 4 5
29