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,592
questions
-2
votes
0
answers
29
views
Does PLE have any relation to the backups performed? [duplicate]
Page life expectancy tells how many seconds a page remains in memory.
Backup uses backup buffers which are separate to the sql server buffer pool memory.
So this means that when a backup is performed, ...
- 2,239
-3
votes
0
answers
43
views
SQL Server differential backups too much slow and big
I configured a backup plan on my SQL Server 2019 Web Edition with this scheduling:
a full backup every day at 00:00
a differential backup every 15 minutes
What I was imaging is that every ...
- 127
-1
votes
0
answers
26
views
One way syncing of few tables from one SQL Server to multiple SQL server Express Edition databases
I need to sync few database tables (Not every table and not every column of the table) from one SQL Server (Standard Edition) to multiple SQL Server Express editions in different locations all ...
- 15
0
votes
0
answers
55
views
Why is full backup so slow after running big table update?
I'm using SQL Server 2016 SP3 Enterprise Edition on AWS EC2 instance
I have the following msdb job:
takes a copy-only full backup, database belongs to a read-only replica from AlwaysOn
restores the ...
- 11
1
vote
1
answer
46
views
How do I generate the private key needed to restore the encrypted backup?
I'm simulating the situation where I take a backup from instance A and restore it on instance B. I followed the doc to Backup to Disk with Encryption. Since I'm using only my desktop to simulate the ...
- 4,394
0
votes
0
answers
21
views
Faster way to Restore Postgresql Dump Taken by Pg_dumpall?
I have a database server which consists multiple databases and the size is nearly 1 TB. The problem is, it takes very long (hours) to restore from the dump.
Normally i restore my database via this ...
- 101
0
votes
0
answers
41
views
Restoring DB from pg_basebackup I get 'role "postgres" does not exist' error on new DB
I do it for the first time. On the main server I've set archive_mode getting my WAL files and do base backups via cron with the following command:
pg_basebackup -h localhost -U <user> -Ft -z -D /...
- 1
-1
votes
1
answer
15
views
Log backup after switching recovery model from full to simple to full, followed differential backup (not full backup) contains which transactions?
Suppose I have configured full backup for every Sunday, differential backup every day at 1AM.
Then switch db from full to simple recovery model. Then switch back to full recovery model.
Now if I try ...
- 2,239
0
votes
1
answer
24
views
What happens when full backup, differential backup and log backup schedules collide?
Suppose I have configured full backup for every Sunday 1AM, differential backup every day at 1AM and log backups every hours from 12AM.
So, every day the differential and log backups collide at 1AM.
...
- 2,239
-3
votes
2
answers
79
views
I am facing difficulties in backing up a database in MS SQL Server
When I try to backup a database, it is showing this message :
to accomplish this action set property devices.
(microsoft.sqlserver.smoextended)
I cannot able to select the file location to backup as ...
0
votes
0
answers
22
views
Large log backup files on subscriber side of merge replication
I have a merge replication setup in SQL Server 2019 (Full recovery model) that is working great with no problems in use.
The publisher and the subscriber both have weekly full backups, and hourly log ...
- 101
-2
votes
1
answer
35
views
Does database backup contain the user's GRANT, REVOKE and DENY permissions?
I am migrating database to another SQL server.
I have scripted the logins from the source server and migrated them into the target server. Also, I have backedup the source db and restored it on target ...
- 2,239
1
vote
2
answers
54
views
What is the practical purpose of backing up the system databases?
I know that system databases hold logins, security info, jobs, etc.
Assuming I have backup of all system and user databases, and the SQL server crashes, then I will have to re-install the SQL server ...
- 2,239
3
votes
1
answer
89
views
TDE Backups Won't Compress with NOINIT
We run weekly backups of a TDE-enabled database using a command in the following format:
BACKUP DATABASE [DBName] TO DISK = N'C:\Temp\DBName.bak' WITH
FORMAT,
INIT,
MEDIANAME = N'DBName ...
- 131
2
votes
2
answers
62
views
Issues with differential backup on random days
We are having a very weird issue with our backups related to differential backup for one of VLDB around 10 TB.
We run once a full backup every Monday and differential on remaining days. We do on ...
- 703
0
votes
1
answer
58
views
Corrupted database. How to restore it from an old backup and add newer changes after?
I have a corrupted database with the following error
Msg 8952, Level 16, State 1, Line 1
Table error: table 'sys.syscolpars' (ID 41). Index row of index 'nc' (ID 2) does not match any row of data. ...
- 1
0
votes
1
answer
39
views
Troubleshooting RMAN-03009: failure of delete command on d1 channel
I don't have many experience about RMAN backup. I'm running backup daily level 1 incremental backup and weekly Level 0 incremental. Backup files will kept at 2 difference locations (each location one ...
- 101
0
votes
1
answer
37
views
Can we use multiple backup software programs at the same time?
We've implemented EMC NetWorker (Legato) as a network based SQL Server backup solution. Previously we used SQL Server Backup via Ola Hallengren's scripts. Can we continue to do both or will that mess ...
- 11
3
votes
1
answer
60
views
Cross-domain backup using Ola Hallengren's scripts
I have a backup repository on a different domain than the one where I have SQL Server. Is there any way I can define the credentials to access the repository on the backup itself? (domains are ...
- 31
2
votes
1
answer
48
views
Sql server 2016 split url backup into multiple files
I have a database backing up into an Azure page blob via URL backups set up from SSMS. I am trying to find out how to split the backup into smaller chunks. I have a 2 TB database that is now backing ...
- 23
0
votes
1
answer
37
views
IBM DB2 database backup speed
I have a IBM DB2 database on LUW that is around 5TB.
Currently the backup of 5TB takes around 24 hours.
I am thinking of creating a mountpoint called /dbbackup and that mount point is a LVM powered by ...
- 103
0
votes
0
answers
46
views
Maintenance plan run date wrong
Win server 2019 & SQL Server 2017
On Jan 28th, 2022, I setup 3 maintenance plans to backup 3 databases from 3:00AM – 3:40AM. The last one finishes at 3:45AM. For a few weeks I confirmed that I am ...
- 1
0
votes
0
answers
12
views
How to synchronize eligible data of multiple tables in a database?
The server has a lot of stock data and I want to sync to my local,
A: Server; mysql, a total of 600 tables, 50G raw data.
B: My computer; mysql, with Navicat 16.
The database in server A, stock data ...
- 101
0
votes
1
answer
39
views
SQL Server backup log - hasn't been run in a long time, what could go wrong?
SQL Agent was accidentally not enabled on a SQL Server after a restart, and no jobs were run for 3 weeks, including no backups (full or diff or log).
SQL Agent is enabled now. The full backup of the ...
- 169
0
votes
0
answers
11
views
Recover profile of deleted user from backup, and inject into working MYSQL database
Can someone specify a procedure to recover the complete profile of a deleted user,
extracting the old data from a backup (gz compressed MySQL)
and injecting it into the empty profile of the working ...
- 1
0
votes
0
answers
18
views
How do I use COPY FROM on a backup file with multiple tables?
I used this command to backup my "supplies" table:
COPY supplies (id, price, ...) FROM 'C:\Users\MyCompany\Desktop\database03-01-2022.sql';
But now, I would like to write three more tables' ...
1
vote
1
answer
36
views
Should I offload my SQL Server backups to a secondary replica?
My production server doesn't have enough horsepower to run backups locally without causing impact to production. I'd like to offload them to my secondary replicas, to free up resources on my primary.
...
- 2,869
2
votes
2
answers
46
views
PostgreSQL (TimescaleDB) asynchronous replication (WAL) doesn't work
I'm trying to setup asynchronous replication of a PostgreSQL (TimescaleDB) database. I've been following numerous of guides, and even after trying things from documentation it doesn't seem to work. I ...
- 21
-1
votes
1
answer
37
views
Mysql, failing xtrabackup and weird undo tablespaces metrics
I'm trying to set up a MySQL replica server, but, since the database size is quite large, I'm using xtrabackup. The latter one constantly fails on start (though I used to use it earlier):
xtrabackup: ...
- 197
3
votes
2
answers
56
views
Estimating the best restore time from saved backups in SQL Server
I am looking for guidance and any advice on how to estimate the restore time for SQL Server databases once copied locally to the server.
This is just to layout a strategy what will happen if in future ...
- 703
1
vote
0
answers
43
views
Get Queries History from SQL Server Database
I started a new job as DBA, and one of the tasks is to run backups and stuff but since it's my first experience I would like to get a general idea about the databases I'll be managing, for that I want ...
1
vote
1
answer
60
views
Can you backup a replicated database?
I would like to backup a publication SQL Server database that is being replicated with transactional replication.
Would it cause any issues (with replication or any other issue) if I took a backup of ...
- 253
0
votes
1
answer
37
views
Proper roles for a backup-only user on PostgreSQL
I am working on new processes and policies for my PostgreSQL databases when they are first created, and I am trying to define what role attributes are necessary for a role specifically used for ...
- 37
0
votes
1
answer
69
views
SQL Server on Linux, an issue with filesystem privileges for a backup creation
I'm trying to backup SQL Server to a directory that different users should have access to. To do this, I create a user group, and include the mssql user there - but when I try to create a backup, an &...
- 363
0
votes
1
answer
35
views
Start SQL replication using differential backup
I need to replicate a few databases but they are too (>100GB) to use snapshot or to copy the full backup on last minute (it take around 5 hrs to copy the full backup across centers). I'm looking ...
-1
votes
1
answer
32
views
Can I set up Wal Archiving on a three years old Postgres database?
If I set up Wal Archiving on a three years old Postgres database (used in production); do the Continuous Archiving and Point-in-Time Recovery (PITR) will work from the beginning? Will I have all the ...
0
votes
0
answers
42
views
remote backup restore with xtraBackup
how i can restore backup created with xtrabackup to remote server ?
we do not have enough space to copy backup files and then restore them .
is it any way like xbstream that backup on remote server , ...
1
vote
0
answers
12
views
Dump-based incremental backups of immutable rows MySQL
I have a database where only SELECT AND INSERT privileges are granted. My idea was to do incremental dumps based on the last backed up row of the last dump (autoincrement PK). Something like --where '...
- 111
0
votes
0
answers
136
views
Oracle Rman recovery to another database on different location
We had production user facing data loss from production Oracle database and only wanted to recover just one schema in the test database from a week ago. Backup team was able to retrieve the physical ...
Color Senz
1
vote
2
answers
167
views
InnoDB: Cannot close file ./tablefile.ibd because of 1 pending operations
MariaDB Version: '10.5.13-9
I am facing multiple unsuccessful data migration(Copy) attempts from my old legacy data environment to my DBaaS Container Environment. Performing this data migration using ...
0
votes
2
answers
69
views
Restoring secondary backup files on primary server in sql server
I want to restore log backup file on copy-only full backup in restoring mode on primary replica server
these backups were taken from secondary replica .
I took copy only full back up on secondary ...
- 1
2
votes
1
answer
127
views
SQL Server Availability group and Backups
SQL Server availability group backup preferences.
We have 3 nodes for our AG.
I would like to take full and differential backups on primary, log backups on secondary.
When I configured "any ...
- 23
0
votes
1
answer
51
views
Backing up a DB on remote server
I need to backup a postgres DB which is located on a remote server. This server also hosts a lot of other stuff, and that's why I don't have a general access to the server itself. Therefore I believe ...
- 101
0
votes
2
answers
52
views
Does only a full backup (and no tlog backup) of a db in full recovery model allow for point in time recovery?
I have a database in full recovery model.
Full backups are configured to run every Sunday and log backups run every day.
Log backup files are destroyed after 30 days. Full backups are destroyed after ...
- 2,239
0
votes
1
answer
47
views
SQL Server Access Database in Filesystem
We have a Windows Server 2008 which is offline. We no longer have access to the server OS, or any GUI tools, but we do have a backup of the entire C:/ of this server.
This server used to host an SQL ...
- 177
5
votes
3
answers
858
views
Does GDPR require deleted backups to be rendered unrecoverable?
Although GDPR has been in place for some time, my organisation has had a dispensation to essentially ignore it up until now. The dispensation was because the contract from the government we were on ...
- 201
0
votes
2
answers
162
views
upgrade to postgres 14 from postgres 13 using pg_basebackup
I want to upgrade/move a running timescale cluster manage by Patroni using PostgreSQL 13 to a new hardware with PostgreSQL 14, the dataset is ~ 40GB but is taking ages take a backup using:
pg_dump -j ...
- 139
0
votes
1
answer
85
views
How to backup from MySQL Ubuntu to Synology NAS MariaDB
I am facing difficulties when setting up MariaDB on Synology NAS as slave to replicate my server on Ubuntu. But there are missing commands and files (my.cnf) in the installation. Need help on any ...
- 1
0
votes
2
answers
77
views
How to optimize a big table for backup
I have a table that is not too much big but still, it takes 30GB of storage.
When I try to make a backup with mysqldump it takes a lot of time and resources and I want to optimize it but I don't know ...
- 103
1
vote
1
answer
85
views
Why store /var/lib/mysql when you can just create SQL dumps for backup purposes?
Tools like mariabackup offer the possibility to create full and incremental file system backups of /var/lib/mysql but I don't quite understand what additional safety layer this would give me if I ...
- 111