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,599
questions
1
vote
0
answers
22
views
backup a single user , password and privileges from postgresql
I am moving a database user form one postgresql server . I need to take backup of the user name , password and privileges and restore into another pgsql server. I looked into the documentation and ...
- 11
1
vote
2
answers
64
views
Why do we do weekly and monthly database backups - why not just daily?
I'm sure I'm missing something obvious here, but if I'm doing a full database backup every day, why do I also need separate weekly and monthly ones? Or is it a case of not needing separate weekly and ...
- 155
2
votes
1
answer
42
views
100 GB SQL Server database stuck on "Restoring..." after restoring from backup
I've restored lots of SQL Server databases before but none quite this large. I got a 100GB+ .bak file that I restored recently but has been stuck with this "restoring" flag for about a half ...
Tyler Moore
0
votes
2
answers
90
views
Take Backup of a Database without the Corrupted rows
I have DB of size 170GB. One of the table has 339500 rows out of which around 2000 rows are corrupted.
When I tried backing up the database I get "Backup with 'Checksum' gave error"
SQL ...
0
votes
1
answer
36
views
Upgrate postgresql database
I'm going to upgrade postgresql from the version 9 to 11, I exported all the cluster using the command pg_dumpall -h localhost -p 5450 > /tmp/all.sql I have installed postgresql 11 on my new ...
0
votes
0
answers
22
views
Backup with Compression of large TDE databases
I'm looking for help with Backup Compression for TDE databases, I'm working out of SQL 2016 (SP3-CU1) and am aware that the MaxTransferSize must be specified as over 64K. A few these DBs are over ...
4
votes
0
answers
48
views
Log Backup occasionally blocked by automated update
We have a canary table in each of our databases that our automation updates once a minute. The automation is a sql server agent job that utilizes a cursor to iterate over the databases and then ...
- 2,968
2
votes
1
answer
108
views
Diff backup fails with error 3035 but log backup succeeds
We have a SQL Server 2014 Enterprise where the DIFF backups fail.
This is the error message we get:
Msg 3035, Level 16, State 1, Server sqltest, Line 1
Cannot perform a differential backup for ...
- 1,982
0
votes
0
answers
26
views
Why is restoring a fresh database from a backup failing due to a duplicate key error?
I'm trying to build a replica from an active database with no downtime for replication purposes.
I run the following statement to get a backup, avoid locking the tables, and flush the logs so that the ...
- 167
0
votes
0
answers
59
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
58
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
39
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
99
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
0
votes
1
answer
21
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,375
0
votes
1
answer
26
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,375
-3
votes
2
answers
89
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
37
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,375
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,375
3
votes
1
answer
100
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
66
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 ...
- 701
0
votes
1
answer
62
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
96
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
46
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
62
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
68
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
42
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
17
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
48
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 ...
- 171
0
votes
0
answers
13
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
55
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
51
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,934
2
votes
2
answers
62
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
52
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
84
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 ...
- 701
1
vote
0
answers
45
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
72
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
64
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
113
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 &...
- 383
0
votes
1
answer
39
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 ...
0
votes
1
answer
36
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 ...
- 13
0
votes
0
answers
51
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
195
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
200
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
83
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
148
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
67
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
56
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,375