Questions tagged [backup]

Making copies of data which may be restored after a data loss event or to recover data from some earlier point in time.

Filter by
Sorted by
Tagged with
0 votes
1 answer
38 views

What are recommended values for block size, buffercount and maxtransfer size for Ola backups to Azure?

I have SQL servers running on onprem and Azure VM hardware. The backups write to a file share located on a network VM. I am wanting to change the backup destination to Azure blob storage. For this I ...
variable's user avatar
  • 3,593
0 votes
1 answer
68 views

Encountering an Issue with Oracle ORA-39405 Error

I've been researching and testing for days now, and so far, I haven't been able to solve my problem. I'd like to know if any of you have ever encountered this. I'm facing a challenge with a client's ...
Thiago Roque's user avatar
0 votes
1 answer
74 views

Cannot do a backup of a read_only database

I'm facing a strange issue where my backup fail with the message : Msg 3906, Level 16, State 1, Line 5 Failed to update database "MyDBB" because the database is read-only. Msg 3013, Level ...
Dominique Boucher's user avatar
0 votes
0 answers
12 views

Percona XtraBackup questions about full and incremental backups

I had a few questions on the Percona forum, and I'm unsure if I was being clear in my questions or not, however I'm curious how full and incremental backups work with XtraBackup. When doing ...
alturic's user avatar
0 votes
0 answers
10 views

The backup I took with mongodb mongodump is extremely slow

I am using mongodb 7 community version. And I have a system that inserts a lot of log documents. Since I am using the Mongodb community version, I cannot use the ops manager tool used in Mongodb for ...
emreyanik's user avatar
0 votes
2 answers
49 views

Point in time Postgres restore

I was trying to do Point in Time Restore, I had my placed by previously backed up WAL file in my directory to where my restore command (/var/lib/postgresql/16/main/pg_wal/wal_archive) in postgres.conf ...
Руслан Пилипюк's user avatar
0 votes
1 answer
20 views

Restoring incremental backup of Postgres

I have restored basic backup successfully of Postgres. However, after that I have tried to restore incremental backup of Postgres(it was a couple of write to test table), and it had a couple of WAL ...
Ruslan Pylypiuk's user avatar
0 votes
1 answer
32 views

MySQL services fails to start successfully after copying MySQL Data Directory from another server

Purpose 1 - The running application should not be stopped and run 24*7 while backup or copy MySQL data directory (/var/lib/mysql). Purpose 2 - To backup MySQL files directly and copy on another server ...
Vijay Singh's user avatar
0 votes
1 answer
72 views

SQL Server - moving databases to an earlier version - options

I have inherited a vendor product. It’s currently very old, having been installed in 2013 and never updated in the 11 years since. The database server it’s using for its 3 database is SQL Server 2008 ...
fiveeuros's user avatar
0 votes
1 answer
55 views

ORA-19504: failed to create file "bh2jk0h7_1_1"

I want to create a script to get incremental backup of the remote Oracle database every week. I save this command in rman_command.sh and give permission to it: BACKUP INCREMENTAL LEVEL 0 DATABASE ...
M_Gh's user avatar
  • 101
0 votes
2 answers
88 views

What is taking backups of my servers?

I am working in virtualized environment. All my SQL instances are hosted on Windows Server machines. My infrastructure team is using Veeam tools for backups and replication to the secondary data ...
Radek Gąska's user avatar
0 votes
2 answers
50 views

Unable to restore from WAL files

I copied both the base backup and the WAL files from my primary Postgres database to a standby database and tried to restore from them but I'm getting this error: PostgreSQL Database directory appears ...
dokgu's user avatar
  • 113
-1 votes
2 answers
84 views

Why does restoring a database on a different server bring in the backup info into the msdb db of new server?

I restored a db to a different SQL server but interestingly the msdb backupset tables on this server are showing the db backup history from the source server. Is this expected? Note: I have not ...
variable's user avatar
  • 3,593
0 votes
1 answer
24 views

How can I restore everything except stored procedures, functions, users from SQL Server 2019 native backup into another DB Server.?

How can I restore everything except stored procedures, functions, users from SQL Server 2019 native backup into another DB Server? We are planning to setup a QA environment from clone of PROD SQL ...
Sunil Bopanna's user avatar
0 votes
1 answer
29 views

How to create a pg_basebackup for without streaming?

I have a primary and a replica Postgres database that are never connected to each other. We have another layer of technology to store a base backup and the WAL files to and those will get synced to ...
dokgu's user avatar
  • 113
0 votes
1 answer
36 views

what to do when database is not synchronizing in availability groups?

I am using Jonathan Kehayias - Monitoring Availability Group Replica Synchronization SELECT ar.replica_server_name, adc.database_name, ag.name AS ag_name, drs.is_local, drs....
Marcello Miorelli's user avatar
0 votes
1 answer
157 views

Why is restored database faster than original?

I ran this explain analyse in my PostgreSQL 13.7 database: explain(analyze, verbose, buffers, settings) select * from main_table; Seq Scan on public.main_table (cost=0.00..10246.15 rows=220715 width=...
Mapashito's user avatar
1 vote
1 answer
83 views

How to lock an entire Postgres database

I have a process (for backup and replication using binary logs) that works in MySQL that I want to replicate for Postgres databases (using WAL): Lock database (FLUSH TABLES WITH READ LOCK;) Disable ...
dokgu's user avatar
  • 113
0 votes
0 answers
67 views

Database log file is so big

My database log file is so big(400 giga) and data file is (50 giga) My recovery method is simple and backup plan is daily full backup Log file is configured to auto growth. I checked open transactions,...
Abdelrahman Mamdouh 's user avatar
0 votes
1 answer
30 views

GRANT REPLICATION SLAVE ON - ERROR 1064 (42000): You have an error in your SQL syntax

I'm setting up mysql replication using xtrabackup guide https://docs.percona.com/percona-xtrabackup/innovation-release/set-up-replication.html#2-copy-backed-up-data-to-the-replica On Master/Source I'm ...
Vaughn's user avatar
  • 101
0 votes
0 answers
49 views

what to do before restoring a database that is involved in TDE (transparent data encryption)?

I use the following script from John Eisbrener to get the chain of backups, in order to restore them: WITH BackupHist AS ( SELECT s.server_name , d.name AS ...
Marcello Miorelli's user avatar
0 votes
0 answers
52 views

xtrabackup: File '/var/lib/mysql/binlog.000010' not found (OS errno 2 - No such file or directory)

I’m first time using percona Xtrabackups. And, while taking full backup with it, I see this error message at the end of log: Below command I used to take backup: xtrabackup --backup --host=xx.xxx.xx....
channa's user avatar
  • 350
0 votes
2 answers
61 views

Full folder /wal

How can I efficiently delete thousands of WAL (Write-Ahead Logging) files in the /wal directory in a PostgreSQL database to free up disk space while ensuring the integrity of the database? -rw------- ...
Jan Kůst's user avatar
1 vote
2 answers
62 views

My backup failed DBCC CHECKDB. Now what?

Assume the following: I have a database on a production server. I do not regularly run DBCC CHECKDB on it. I regularly take full, dif, and transaction log backups on my database. As is good practice, ...
J. Mini's user avatar
  • 109
1 vote
0 answers
37 views

Modified_extent_page_count shows 0 extents modified on a 1.7TB database, but running a differential takes takes 4-5 hours and generates a 50GB file

As per the title - modified_extent_page_count shows 0 extents modified on a 1.7TB database, but running a differential takes takes 4-5 hours and generates a 50GB file. I wondered if anyone has come ...
MattT's user avatar
  • 11
0 votes
0 answers
23 views

DBeaver script in linked folder disappears after renaming in Windows

I changed the location of my Scripts folder from the default C: drive location to a cloud storage location where there is automated backup: When I go to open a script in DBeaver, I see these scripts ...
kstats9pt3's user avatar
0 votes
0 answers
51 views

FIX: mysqldump: Couldn't execute '/*!80000 SET SESSION information_schema_stats_expiry=0 */

I've already asked this question in the "Stack overflow" website. I don't understand why they closed my question even if I didn't get a working solution for my setup. Why did I submit it? I'...
Edo Meloni's user avatar
0 votes
2 answers
93 views

How to prevent backup messages to be printed

In one of my servers, there are many databases which I take backup from the with Ola's script. Sometimes it happens that the backup job failed. But because many messages had been printed in job ...
Meyssam Toluie's user avatar
0 votes
0 answers
10 views

Quicker & automated way to replicate mysql from master to slave

I want to replicate around 60 databases from master to slave server. I've read this guide https://dev.mysql.com/blog-archive/get-mysql-replication-up-and-running-in-5-minutes/ and few other. It's ...
Raymond's user avatar
  • 101
0 votes
1 answer
50 views

How to force checkpoint before backup is executed in IBM Db2?

In my company coworkers are creating several tests per day on database. After group of changes are performed that take few hours, they request to perform database backup of this test database, before ...
folow's user avatar
  • 339
0 votes
0 answers
12 views

Restore Postgres Server from Backup Plain File with PG_Admin or somethin else?

I have created a Backup for the Postgres server via PG Admin 6.17. I would now like to import this plain sql file again on a new server, but there is no button for Restore Server Backup similar to the ...
Omegon's user avatar
  • 101
0 votes
1 answer
57 views

sql server backup restore multiple require disk space

I took a full backup file of a live system, approximately 210 GB. It's in the downloads folder with the .bak extension. I'm trying to install it locally with the restore database in SQL Server on my ...
Kadir Çolak's user avatar
1 vote
1 answer
900 views

MS SQL show percent extents changed per table

I've got differential backups set up for MS SQL Server 2022 and would like to know how much each table in the database is contributing towards the size of the differential backup. The page below shows ...
CoderBrien's user avatar
1 vote
0 answers
61 views

How to restart SQL Server Instance after restore master

At work we have a productive SQL Server working, and we create backups of each database periodically, including system databases master, msdb and model. I'm trying to restore the whole datawarehouse ...
santiago arnesano's user avatar
0 votes
1 answer
118 views

Unable to import constraints using IMPDP in Oracle 19c

I am using impdp user/password@PDB directory=data_pump_dir tables=tablename dumpfile=DP_3.dmp logfile=card.log parallel=6 there are 2 tables: Table A and Table B the tables are restored correctly, ...
datascinalyst's user avatar
2 votes
3 answers
82 views

Window Server Backup products: Are they a viable replacement for SQL-Server backups yet?

We currently use VEEAM for Server level backups including snapshots. We also take full Db and TX logs backups. Most db's are in full recovery mode. We're about to move to Cohesity for server backups. ...
Sir Swears-a-lot's user avatar
0 votes
0 answers
60 views

Why bulk of pages/extents are unallocated in sys.dm_db_file_page_usage

Could someone help shed some light on a strange sys.dm_db_file_page_usage result of a large database? sys.dm_db_file_space_usage result: |total_page_count | allocated_extent_page_count | ...
Mary W's user avatar
  • 11
-1 votes
1 answer
34 views

Backup and Restore Disaster Recovery

I am using PowerShell to write a script for DR, assuming that we only have backup files of all the databases. If i have a latest sql server version and i want to restore some database from backup ...
LearningSQL's user avatar
-1 votes
1 answer
148 views

BACKUP FAIL FOR SERVER (Microsoft.SqlServer.SmoExtended)

Show error: I have to make a backup of my SAP database but when I do it it shows the following error. Apparently, while investigating, it is due to the fact that my database (PRD) is damaged, but I ...
user avatar
1 vote
2 answers
95 views

how to change the database create_date after a restore?

I just restored a database, but then I noticed the create_date remains from previous to the restore. is there a way I can change the create_date to be as the new database (after the restore)? this is ...
Marcello Miorelli's user avatar
1 vote
1 answer
46 views

CleanUp Time not working for DIFF Backups

We have a database server where the test database is "refreshed" with the backup of prod database every day at 22:00. The first backup after the restore is a differential backup, because we ...
Guenter's user avatar
  • 13
1 vote
2 answers
73 views

last backup - how many backup files and where they are?

I am restoring a database, this database is very big and it has 6 backup files (meaning the backup is split into 6 smaller files) I can see an indication of that using the restore labelonly ...
Marcello Miorelli's user avatar
0 votes
1 answer
64 views

Log .ldf file not truncate after several times of log backup on secondary database

i have always on setup in production environment. Scheduled backup (transaction log backup) already in place every 2 hours using netbackup on secondary database. The issue i am facing is sometimes the ...
zul nasir's user avatar
1 vote
4 answers
839 views

Difference between Backup and Snapshot

I've been reading article after article about the difference between a Database Backup and a Snapshot and they just don't make any sense, so please help me undersand "A snapshot is an image of ...
Juan Perez's user avatar
0 votes
1 answer
41 views

Reading data from PostgreSQL backup directory

Let's say I have a backup directory containing PostgreSQL data from some other system. By default, the data is stored at /var/lib/postgresql. After changing the default data directory to the path of ...
0xD4rky's user avatar
0 votes
1 answer
49 views

Merging old backup in current database mysql

I have a backup database that contains data up to the specific date 27-11-2023. Currently, I have the latest version of the database with updated records. However, the issue arises when I consider ...
Muhammad Faizan Khan's user avatar
2 votes
1 answer
62 views

how percona hot backup works / innodb crash recovery works?

I am trying to understand the process of how percona does hot backup. from what in understand is, they use innodb crash recovery mechanism and execute the following steps. store/remember start LSN ...
Rajat Aggarwal's user avatar
1 vote
1 answer
147 views

RMAN backup restoration

I am trying to restore a RMAN backup to a different server. I needed some clarifications/guidance. This is the location for datafiles in database 1: /u01/app/oracle/oradata/db1/datafile This is the ...
datascinalyst's user avatar
0 votes
0 answers
49 views

Problem restoring partial mariabackup

I follow this method to perform a partial and incremental backup of my database on two servers, bskpserver and devserver. Everything works fine except for some tables. When I try to restore them on ...
elarichi.y's user avatar
0 votes
2 answers
30 views

maintaing backup log sequence after executing BACKUP DATABASE databasename command manually [duplicate]

I am new to database admin role and I have to configure backups for a new client. I want an advice on how to handle below scenario. I want to configure a weekly full backup along with incremental ...
user avatar

1
2 3 4 5
54