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

1
2 3 4 5
52