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
1answer
89 views

SQL Server TDE Vs SQL Server Database Backups

Can anyone please help me understand below case: Kindly advise on below case: SQL Server is on 2014 SP2 GDR version I read Compression and TDE does not go hand in hand . I have 2 PRD Environments:...
2
votes
3answers
240 views

Is there a way to retrieve the logical filename from a backup file?

I would like to write an automation script that restores a SQL Server DB from its backup file. However, doing this is not a straightforward procedure in SQL because the main query needs additional ...
0
votes
0answers
158 views

I can not Ola Hallengren database backup script to Data Domain make works

Ola Hallengren has a nice SQL Maintenance scripts that I installed to our dev SQL server. The backup script works very well to a local drive, however it does not work to Data Domain. At all. Here is ...
1
vote
1answer
248 views

mariabackup of database running in docker

I have MariaDB running in a Docker container with the container's data directory /var/lib/mysql/ mapped to the host directory /mnt/data/. I want to run mariabackup from the host to create a physical ...
0
votes
0answers
13 views

Can pgBackRest be integrated with third-party backup suftware?

I am trying to figure out pgBackRest to backup PostgreSQL databases. So far my understanding is that it can use a local file system or S3 for backup storage. Is there any way to get it to use third-...
7
votes
2answers
2k views

Why is my log file so massive? 22gb. I am running log backups

I can't seem to figure out the answer. I've seen multiple answers like this: Why Does the Transaction Log Keep Growing or Run Out of Space? and everyone talks about running back ups on your log file ...
1
vote
0answers
13 views

How to : gcloud Snapshot MariaDB Galera Node?

How to do a gcloud snapshot of Mariadb Galera Node for backup and restore ? I heard of people talking about gcloud snapshots and nowhere explains the full process of doing it. Kindly delight with the ...
0
votes
0answers
69 views

How to speed up MySQLl loading from dump file?

I'm using mysqld Ver 5.7.25-0 in Ubuntu 16.04. I dumped from AWS Relational Database Service (RDS) with mysqldump --single-transaction --quick --max_allowed_packet 1G ... and now when I tried to load ...
0
votes
2answers
218 views

Attempting to backup to remote NAS but access is denied

I was attempting to use Ola Hallengren's scripts to backup to a remote NAS, but it was failing and not giving any direct errors, so I tried doing it manually using Server Management Studio and got the ...
1
vote
0answers
26 views

Oracle Secure Backup (OSB) issue - “failed to read configuration data - Network is unreachable”

I am using Oracle 12.2.0.1 on Linux 6.8. I am using OSB to take a backup to tape. After an unknown host name error in the backup log, I edited the /etc/hosts file and restarted the server. After ...
2
votes
2answers
176 views

How to minimize\plan ahead the effect of running sp_delete_backuphistory? Measure the gains too!

while running the following query: -- DATEADD (datepart , number , date ) DECLARE @dt DATETIME SELECT @dt = DATEADD(month,-6,getdate()) select @dt EXEC msdb.dbo.sp_delete_backuphistory @...
1
vote
2answers
113 views

sp_databaserestore: “stopat” gives error “no database backup found”

Unfortunately I get: “No backups for “database xxx” found in “\xxx\xxx$\…” as soon as I add the @StopAt = ‘2019-03-27T04:05:20 Parameter. When I comment this Parameter, everything works fine, ...
0
votes
0answers
169 views

Full backup job failed after changing backup location

In AG Environment, for the last 30 days, the daily Full backup job is failing for a few of the larger databases. The rest of the databases are getting through daily so far. We recently changed the ...
0
votes
1answer
221 views

Create publication is not working in PostgreSQL

I am trying to create a publication (for logical replication) in PostgreSQL database but it throws an error: indsolv_dev=# CREATE PUBLICATION my_publication; ERROR: syntax error at or near "...
1
vote
1answer
101 views

Having the backup file, how to work out the total disk space required to do the restore?

I have a nice query that gives me the date of last full backup, size and location, even when I backup to multiple backup files. what I don't have is an estimate of the total backup size (for each of ...
3
votes
1answer
114 views

How are database backups conducted using SQL Server VSS Writer Service

We have few servers where backups are running from an unknown source. The physical_device_name in the backupmediafamily table is something like {922DDBA9-0686-46B8-94BC-XXXXXXXXXX}2. I was checking ...
0
votes
1answer
52 views

How to clear all configurations on RMAN

How can I clear all configurations listed with the command show all on RMAN to default? I just found how to clear one unique configuration for exemple: CONFIGURE CHANNEL DEVICE TYPE DISK clear
1
vote
0answers
90 views

rman backup takes too long time on oracle 10g

I have a problem that my RMAN backup on our sl45 tape drive takes 2 days to backup 450GB database. The problem that the log shows is that the backup waits too long between finishing a certain task and ...
1
vote
1answer
41 views

SQL Server Backups-Order of FULL & T-log backups

I have an elementary question. I just started as a DBA with no administration experience and upon reviewing the Backup schedule, I noticed on one instance that the maintenance plan that performs the ...
1
vote
1answer
284 views

File permissions for database backups and certificate backups

I have backed up a database and backed up the database master key to the very same folder. Everyone has full access to this folder, however, only the database backup inherits the permissions of the ...
1
vote
2answers
88 views

How much time should a backup of a 100Gb database take using streaming server setup?

I've installed barman on a dedicated server to backup all my postgresql servers. One of the server is now using 100Gb space and the instruction barman backup myserver takes 23 hours. I find it too ...
1
vote
0answers
38 views

Couchbase backup and restote through copy data files

I was exploring couchbase backup and restoring procedures then we found standard procedures. But, if I can take data directory backup in the form of .tar and untar data directory whenever restore ...
2
votes
2answers
59 views

Handling partial backups from many different databases

I've got an issue and I'm looking for best practice advice / whatever I can do to make this work. I need to come up with a way to automate getting a backup from many offsite databases of unknown name,...
3
votes
2answers
407 views

Database Backup for data and log files

I have been told that for data files backup operate at extent level and for log file, backup operates at page level. I know that the file type for data file is always "Rows Data" and is stored in the ...
0
votes
1answer
43 views

Split Backup of MSSQL VS Stripe Backup of Sybase ASE

I recently came to know about concept of split backup in MSSQL Server whereas I have been working on stripe backup in Sybase ASE. Stripe backup in Sybase ASE is faster than normal backup and if we ...
0
votes
1answer
37 views

Restoring PostgreSQL tables faster

There's a PostgreSQL PITR system running on a fairly large system, with hundreds of databases with hundreds of tables in each, and we're running into time constraint-based problems when trying to ...
0
votes
0answers
35 views

MYSQL #1146 : does it mean the data was lost?

I delete WampServer with all databases and install a new version (AppServ) with php,mysql,apache before I deleted it I copy the wamp64 folder to D:\wamp64 then I just move the folder D:\wamp64\bin\...
2
votes
1answer
58 views

Creating encrypted backups inhouse to be restored at client

I am trying to understand the mechanics of database backup encryptions, but there are some issues, which I can't seem to wrap my head around. I have 2 requirements: I need to be able to create and ...
1
vote
0answers
27 views

Can I restore a Replication Subscriber backup without needing to re-configer/re-initialize

I've been trying to read up on this and there are quite a few of posts about restoring a subscribers' backup on a different machine but my question is about -- in my opinion -- a much more simple ...
1
vote
1answer
71 views

Differential Backups with Replication?

I am pretty sure that Differential Backups with Replication is ok, but I am not finding anything that clearly says it. Nor am I finding anything indicating issues with it. Just looking for validation ...
0
votes
1answer
531 views

Barman not able to connect: fe_sendauth: no password supplied

I'm trying to setup streaming replication to a Barman server. Barman config is pretty much basic, I'm using backup_method = postgres. [barman] barman_home = /var/lib/barman barman_user = barman ...
2
votes
1answer
56 views

How to find out the oldest full backup still existing on disk?

one of the things I like to find out is what is the oldest full backup file still living in my servers. it is the custom to delete or move those files to a different place after a number of days. How ...
0
votes
1answer
67 views

How to do a configuration on RMAN with run block without save this configuration on rman

I want to do a run block with this configuration for test: run { CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 50M; BACKUP DATABASE; } But I don't want that the configuration CONFIGURE CHANNEL ...
25
votes
1answer
1k views

SQL Server 2017 crashes when backing up because filepath is wrong

I was trying to restore my database and SQL Server kept crashing. I would get a message in SSMS that said there was a network transport error (the connection dropped bc the crash). I checked the logs ...
1
vote
0answers
260 views

Slow SQL backup to local disk problem, with odd workaround

I have some SQL Server 2017 (14.0.3037) servers, both Standard Edition and Developer Edition, running on Windows Server 2016 Standard in a VMware environment (v6.5). The disks are on fast SAN storage ...
0
votes
2answers
142 views

Database Maintenance Job and Backup Scheduling

I would request to have expert advise on scheduling maintenance and backup jobs. Below was the scenario prior to my change: Full backup of database scheduled to run at 12:30AM everyday. Differential ...
-1
votes
1answer
61 views

Running Backup on single DB when scheduled job (USER_DATABASES) has failed

I'm using Ola Hallengren's sp to take backup of database. FULL DIFF and LOG backup is created with respective schedules (agent job) and has been working great. Due to not enough free disk space on ...
2
votes
2answers
93 views

SQL Server mistaken update rows without backup

I did a mistake UPDATE query yesterday. Database engine is MSSQL and the version is 2017. I have not any backups. All I have is the database itself. Do you know any ways to redo my modifications to ...
1
vote
1answer
127 views

Any correct procedure for couchbase backup and restore?

I have just started using couchbase server and trying to configure backup and restore method. We require to take backup for each couchbase node or cluster backup also available ?
0
votes
1answer
355 views

Migrate complete postgres database cluster to another machine using pg_dump

I am referring to How to get a working and complete PostgreSQL DB backup and test In this example/solution, which part of the restore process does actually the "CREATE DATABASE sandbox"? I have been ...
-1
votes
1answer
251 views

Restoring more than one .bak files in a TSQL query

Can any one share a script that will allow me to restore all the .bak files in my one folder into SQL Server using a TSQL script?
2
votes
2answers
893 views

SQL query to check if secondary database is removed from availability group

I have an AG with one primary replica and one secondary replica. I have created a script that queries transaction log backups from these database replicas and restores them to a target database. ...
4
votes
1answer
213 views

SQL Server: are backups between same major/minor version but different build compatible among them?

For example a backup executed on SQL Server 10.50.6000.34 can always be restored on SQL Server 10.50.4000.0 or 10.50.2500.0. All of them indicates an SQL Server 2008 R2 (10.50.xxxx.xx) but different ...
2
votes
0answers
78 views

Streamline MSSQL backups using Veeam

I am looking for advice on managing backups using Veeam and optimizing storage space for backups. We have about 2TB across 20 DB My current backups are Image Level (Veeam) Replication to DR ...
1
vote
0answers
92 views

Correct config wal-e s3 for minio

Try run PostgreSQL + WAL-E + Minio. Minio: https://github.com/minio/ yum install -y https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-7-x86_64/pgdg-centos96-9.6-3.noarch.rpm yum install -...
0
votes
2answers
64 views

(Partially) clone a huge DB for DEV purposes

I want to setup a dev and test environment for website that has a huge MySQL database. Since this DB is so big, it is quite inconvenient to clone it 1-on-1, because it simply takes too long and uses ...
0
votes
1answer
94 views

error writing input to commandERROR: Invalid username and/or password

This is the error I have been getting on my RMAN notifcations on my backup jobs for the last day or so. The title is exactly how the message is formatted. ~~~End Step Output/Error Log~~~ Error Log:...
0
votes
2answers
56 views

get-dbabackuphistory bug in high availability environment

I am very fond of dbatools.io for SQL Server DBA maintenance For some time now I have been using get-dbabackuphistory to check the backups of the last week on all databases / instances. Currently we ...
0
votes
2answers
118 views

Using Ola Hallengren's full backup but database option is for simple?

Each database on the server is set for simple recovery. I'm using Ola's script with 'full' in the script. I tried looking on Google, but it seems backup and recovery are almost synonymous. Is there ...
4
votes
1answer
162 views

How do I reclaim space in filestream data files for database in a SQL Server Availability Groups

I have a SQL 2016 Ent. Edition AG with 3 nodes. We have a database in the AG with 5 filestream tables. Each table is in it's own filestream data file. Today I fixed a bug where all of the files were ...