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
-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, ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
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 /...
user avatar
  • 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 ...
user avatar
  • 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. ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
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. ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
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' ...
user avatar
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. ...
user avatar
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 ...
user avatar
-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: ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
  • 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 &...
user avatar
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 ...
user avatar
-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 ...
user avatar
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 , ...
user avatar
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 '...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
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 ...
user avatar

1
2 3 4 5
52