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.
2,677
questions
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
-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 ...
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 ...
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 ...
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....
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=...
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 ...
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,...
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 ...
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 ...
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....
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------- ...
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, ...
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 ...
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 ...
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'...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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, ...
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. ...
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 | ...
-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 ...
-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 ...
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 ...
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 ...
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
...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...