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
0
votes
0answers
198 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
260 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 "...
0
votes
0answers
38 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\...
0
votes
0answers
165 views

MySQL InnoDb crash when importing tablespace from remote machine

InnoDB crashes when importing ibd file from remote machine. Source version is MySQL-5.6.40, Destination version is MySQL-5.6.40. Database was backed up was backed Percona Xtrabackup with xbstream ...
0
votes
2answers
156 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 ...
0
votes
1answer
114 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
60 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
0answers
210 views

How to Recover overwritten database

I just maked an huge mistake.I overwrite database with my old database backup which was 3 months older. Is there any way that i can recover my orignal database with there record ?? please help me
0
votes
0answers
28 views

Proper way to fully backup and restore a database including indexes in a low-resource shared web host with ssh access?

I'm rather new to database management and I would like some advice on better practices by using the following experience as an example. Every time I update php software I do a quick export from ...
0
votes
1answer
30 views

Xtrabackup corrupt incremental backup

I have 3 nodes PXC 5.6 cluster. Xtrabackup 2.3.10. Centos 7.6 Percona-XtraDB-Cluster-56-5.6.41-28.28.1.el7.x86_64 I am using only single Node-1 for both read and write. And I use to take backup ...
0
votes
1answer
74 views

Postgres 9.6 - Taking differenctial backup

I have a few CentOS boxes running Postgres 9.6. I am planning a central server which can make local copies of all DBs on the other servers. These servers are accessible via SSH on Internet. What is ...
0
votes
0answers
228 views

Restore single database (or table-space) using PITR with PostgreSQL?

Is there any possibility restore a single database with WAL files.
0
votes
1answer
199 views

Percona Xtrabackup fails to backup InnoDB table with fulltext index

I'm trying to make a backup of a large InnoDB table with a fulltext index using Percona Xtrabackup (2.4.12). I have innodb_file_per_table set. To create the backup, I'm running: innobackupex --...
0
votes
0answers
50 views

point in time recovery not working with blackhole engine tables involved

The basic problem summary: I am trying to do a point in time recovery on a specific table. To speed things up I made every other table use the blackhole engine. Unfortunately this runs into errors ...
0
votes
1answer
2k views

Postgresql - Large object exists in pg_largeobject table but cannot open with lo_open?

I have a problem with opening Large Object in postgresql version 9.2, select * from pg_largeobject where loid = '19423'; will return data like this: loid oid;page no integer;data bytea 19423;0;"<...
0
votes
1answer
69 views

Backup of MongoDB collection data and rename the collections [duplicate]

I want to take a collections data backup on a different host, with renaming the Collections. I am very new to MongoDB. Please help me with this task.
0
votes
1answer
57 views

Full backup vs Simple TempDB usage [closed]

What is the difference in terms of I/O disk usage between Simple Backup and Full Backup? Does full backup incur more reads and writes? How does full backup mode impact reads and writes to TempDB's ...
0
votes
0answers
28 views

LDF file size is very huge even after doing Transaction log backup [duplicate]

I work on a SQL Server 2016 Database and in our production environment we have primary SQL server and a fail over SQL server. All the transactions are occurring on the primary SQL server. In primary , ...
0
votes
0answers
49 views

Archiving SQL Server data on disk to be pottentially restored

Right now, we are backing up data per table into text/CSV files per month. This works fine for fairly small tables. For bigtables, the text files become so big that the restore process for a month ...
0
votes
1answer
218 views

The value for the parameter @MirrorDirectory is not supported error with Ola Hallengren Backup script

I am using Ola Hallengren's Maintenance Solution, and it's been working great for our environment. Quick question regarding the User Database backups s proc. Currently, when I'm taking backups, the ...
0
votes
1answer
63 views

Help me with sql backups please

I'am facing some difficulties regarding my Sql Backup method, i am not sure if my method is correct, i am using a backup method described below; Created a Full backup named Xbackup in Maintenance ...
0
votes
1answer
158 views

ERROR: please confirm the keyfile is match and keyring plugin is loaded

I want to create a copy of my Production DB to a new instance. There is a innobackupex running on the prod every night looks like this: innobackupex --user=username --password=password --keyring-...
0
votes
1answer
52 views

How to accomplish such insert-or-update strategy?

Programming stored procedures isn't my strongest point when it comes to programming, but I'm trying to get better. I've stumbled upon a business requirement that's kind of hard for me and I was ...
0
votes
1answer
20 views

Running MySQL Backups to network location

We have a MySQL server with several databases for development work and we want to back up some of the DBs to a NAS device. These have been backed up previously but the backups have not worked for some ...
0
votes
2answers
668 views

SQL Server 2016 Availability Group on DPM 2016

I'm trying to backup my availability group in SQL Server 2016 using DPM 2016, but after I add the cluster in DPM, availability group show nothing to back up. I've set every secondary node to be ...
0
votes
1answer
139 views

Size of Log Backup is not reducing from past three days

Recently we implemented Incremental(Enabled allow incremental dumps) and Log Backup(Disabled trunc Log on chkpt) for Sybase ASE(15.7 SP139) running on HP-UX Itanium server and to our great surprise, ...
0
votes
0answers
146 views

MySQL8 Restore from Physical Files - Innodb

I recently had one of my VM's go down (MS Server 2016) and the only version I am able to get up and running is two weeks old. However, I do have a backup of my C:/ drive from last night that has my C:/...
0
votes
2answers
44 views

DBCC Shrinkfile after full backup restoration but before differential restoration

My database full backup file size is 760 GB and differential would be around 20 GB but the database size is around 2TB. As it is a production database, so to apply only a minimum downtime, i want to ...
0
votes
1answer
197 views

How to mount a pg_basebackup on a stand alone server to retrieve accidently deleted data

Had a bit of a brain fade the other day and deleted all the rows in one of the tables in our database and didn't realise until a couple of hours later. I have a pg_basebackup file system copy created ...
0
votes
0answers
177 views

Wal-e : “ pg_stop_backup still waiting for all required WAL segments to be archived”

I've been trying to use wal-e to take incremental backup of my postgresql database by following this blog. I've a database on my postgresql and using an AWS S3 bucket. while I'm using the following ...
0
votes
1answer
126 views

Log Shipping Server Restart Problem

I have Log Shipping setup from Primary Server A to Destination B. Server B is both Destination and Monitoring server. Yesterday, we restarted both servers around the same time for patching. On the Log ...
0
votes
1answer
159 views

Transactional Replication initialize from Backup Issues

I implemented Transaction Replication (pull subscription with distributor at subscriber) with initialize from backup. It was working good and today when i checked replication monitor,it shows error on ...
0
votes
1answer
1k views

MariaDB: point in time backup recovery with binary log using position

Following the below sequence of commands i expected the recovery of backup and subsequent point in time recovery using binary log. However, the database was restored to backup only: 1) CREATE TABLE ...
0
votes
1answer
18 views

Regularly clone/backup 2 MySQL databases unidirectionally from PC to Laptop both running Windows

I have a PC running Windows XP with a custom ERP system and MySQL Server 4.x (A) and a Laptop running Windows 10, same MySQL 4.x and same custom ERP (B). I'm afraid I can't upgrade PC nor MySQL, etc. ...
0
votes
1answer
732 views

create a backup table with million records

I want to move old records from TABLEA to TABLEA_AUDIT. TABLEA have around 1.5 million records and it have two nested tables. No of Records : 1557951 Size : 1024 MB I tried it by, 1.using ...
0
votes
1answer
287 views

mysql dump a list of query to file and restore to another database

I have 2 databases. The first one is a production have some data deleted. The 2nd one is a backup so it has everything. I traced the log so I got every records are deleted in production database by ...
0
votes
1answer
53 views

Correct way to re-use or recover databases from “PostgreSQL 9.3” to “PostgreSQL 9.5”

I was using PostgreSQL 9.3, then I installed PostgreSQL 9.5, then I unistalled PostgreSQL 9.3. Now I want to move the database from the folder of PostgreSQL/9.3/data/base of PostgresSQL 9.3 to ...
0
votes
0answers
48 views

Couchbase backup validation

Need help regarding backup validations for couchbase, what is the best way / easiest way to validate couchbase backups. we have recently moved to couchbase and totally new to couchbase, having some ...
0
votes
0answers
28 views

Analyzing the log backups to understand the pattern [duplicate]

I am not sure if my understanding is correct on this behavior of log backups. We believe the increase in traffic, as log backups have increased after migration event to cluster from stanadlone SQL ...
0
votes
1answer
542 views

mysql - How to repair & backup archive table, also stop growing .ARN extension file?

I have an MySQL table build with archive storage engine. The table has over 100k records. I have got disk full and it turned out to be a large .ARN file from an archive table. When I cleared some ...
0
votes
2answers
54 views

Filesystem copying inactive DBs on active MySQL server

My question is related to this question and answer: Copying datadir directory enough for backing up a database with InnoDB tables? I want to use a filesystem copy on a whole DB without shutting down ...
0
votes
1answer
34 views

Why provide database name when starting postgresql base backup

According to the postgresql 8 manual, before starting a base backup (i.e. copying the files out of the data directory), you need to issue a command like this: psql -d DATABASENAME -c "SELECT ...
0
votes
1answer
562 views

Restoring dump(backup): ERROR 1022 (23000) at line 44: Can't write; duplicate key in table

I'm doing tests to change a current table from my InnoDB database to Archive, but I had a problem trying to restore a dump after the change. After several tests, the problem is related to the value ...
0
votes
0answers
47 views

SQL Server - Partial Backup

I want to check if my Data Warehouse historical filegroup backups are valid with my most recent Primary Filegroup backup. I backup the Primary Filegroup every night but historical filegroup backups ...
0
votes
0answers
65 views

Help with improving query

Working on evaluating backup files with correction restoration path. Borrowed this query and made some tweaks.. wondering how could I make it even faster. like using maxdop or using better resource ...
0
votes
1answer
98 views

(re)creating empty tables in partially restored mysql database fails with “table exists”

Following situation: I have a MySQL Server (running Percona Server 5.7) set up as a replication slave. This server should hold only a partial replication. To get to this I made a partial backup of ...
0
votes
2answers
319 views

Unable to save and error on DBCC CHECKDB

I try to save my database ≈ 260 Mb I have this error : System.Data.SqlClient.SqlError : failure read function incorrect So I try : DBCC CHECKDB ('myDatabase') PHYSICAL_ONLY I have this error :...