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

Recover Mysql data

I have a mysql database, and today I woke up and noticed that some of my tables are empty (like if they were truncated) but some aren't. This is not an SQL injection since I took care of that, but ...
0
votes
1answer
119 views

How safe is to use BACKUP LOG WITH TRUNCATE_ONLY

As per the title, how much is it safe to use BACKUP LOG db_name WITH TRUNCATE_ONLY in last STEP of any SQL-job execution? Randomly found on google that this Code line can be very harmful in use. But ...
4
votes
2answers
336 views

Ola Hallengreen Backup Retry

Is there a way to do an automatic backup re-try utilizing Ola Hallengren's back up scripts for just one database back up if there is a failure? Looking for a way to complete the back up without re-...
2
votes
0answers
76 views

TransactionalLog Backup Job failed

We have a three jobs scheduled on production server. Full backup, Differential backup and Transaction Log backup. The first two backup successfully, but the Transaction Log backup is failing. It shows ...
0
votes
0answers
184 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
1
vote
1answer
977 views

No shardIdentity document - MongoDB

Having a sharded cluster in production which has been running for a good year now without issues. Everything is on 4.0, classic 3-3-3(config) + 2 mongos. While revisiting our back-up strategy i ...
-1
votes
1answer
90 views

Postgres pg_dumpall failing

Recently on my debian server with postgres 10.6, pg_dumpall has started to fail with the following error: su - postgres -c pg_dumpall | gzip > /temp/directory/postgres_backup.gz pg_dumpall: query ...
0
votes
0answers
27 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 ...
1
vote
1answer
381 views

xp_delete_file - error message when no files for deleting

I have a job that deletes transaction log backups older than 3 days. if for some reason there are no files to delete, it comes out with the following error message: Msg 22049, Sev 16, State 1: ...
1
vote
2answers
228 views

SQL Server Backup failing for just 1 DB (“The system cannot find the path specified.”)

For the last few mornings, I have had a backup of our ReportServerTempDB fail. We are not using SSRS on this server yet, but will in the next month, so the DB is the default 8mb .mdf and 8mb .ldf (i.e....
1
vote
3answers
121 views

Recovering a SQL Server database

In a series of unfortunate mistakes, I lost 4 months of data and all the rapid database modifications. I’m not a database administrator, I’m a programmer who also designs and happens to maintain a ...
4
votes
1answer
138 views

Backups with Split Availability Groups

I have been a DBA for about 2 years now, and there are some subtleties that I still do not understand about AlwaysOn availability groups. First off, they have been nothing but trouble as far as I can ...
0
votes
1answer
54 views

Backup Structured Data and Unstructured Data seperately in SQL Server - Is it Possible?

Can I get some inputs on below: SQL Server Version : 2014 SP2 GDR with AOAG environment. Is it possible to backup Structured Data & Unstructured Data (FileStream) separately in SQL Server ? For ...
4
votes
2answers
157 views

Index deletion and Backup size

If I delete some huge non-clustered indexes will the backup size of that database also decrease? I am facing issue with huge backup files and don't have enough disk space to hold those backups. I ...
2
votes
2answers
308 views

Restoring database with less data than the backup file

I'm not really experienced with DBA and SQL, so I need some recommendations from you. I have a production database backup file, however it is very large, so when I'm executing restore, for example, ...
0
votes
1answer
110 views

Does an ad hoc, full backup, using Oracle RMAN, flag files, so they are not backed up by the regular backup?

If I run a simple RMAN full backup, ad hoc, outside of the regular backup scheduled, does that flag files so when the regular backup runs, that regular backup won't get some of the log files? For ...
0
votes
1answer
59 views

Server version error where restoring backup with SQL Server Management Studio

I have SSMS v17.9.1 freshly installed. I believe the only later versions as of this post's date and time are only preview versions. I am attempting to restore a .bak file. I get the error that: The ...
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
746 views

How to enable NULL values in MySQL timestamp fields?

I need to restore backup from one MariaDB server (version 10.1.23) to another MariaDB server (version 10.1.37). But this version has a much stricter mode by default and does not allow NULL values in ...
0
votes
1answer
26 views

How to plan for change to log backup schedule?

I've looked everywhere but can't find an answer for this. I know it's an easy question, but I want to be sure I don't screw anything up. I want to change our log backup from every 30 minutes to every ...
1
vote
2answers
88 views

Restore a single database backup (.bak) file into multiple filegroups

I have a SQL Server 2014 database DB01 (single filegroup - PRIMARY) and I took a backup of it into a DB01.bak file in SSMS. I have another database DB02 with 1 primary filegroup (1 file) and one ...
0
votes
1answer
528 views

sp_DatabaseRestore msg 50000

I used Ola's script to backup my database (SQL Server 2017) and now I'm trying to restore it using Brent's sp_DatabaseRestore. Currently trying to do a Full restore only. Here is my code, written ...
0
votes
1answer
69 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
1answer
820 views

How to create SQL Agent job to automatically restore a database from latest backups?

There are 3 different folders which store respectively full, differential, and log backups. Different types of backups occur in different schedules. Now I need to create a new job which will ...
0
votes
0answers
212 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
229 views

Why does msdb.dbo.backupset have entries for each database every 15 minutes?

I have 134 separate databases on a SQL Server. Every 15 minutes an entry appears in the msdb.dbo.backupset table for each database on the server. Why does this happen every 15 minutes? What is ...
1
vote
3answers
85 views

Is it a bad backup strategy in Oracle to have only Level 0 backups and Archive Logs in between with no incremental? [closed]

If you backup the database with a Level 0 every six hours, then do the archive logs in between, every 15 minutes perhaps, what benefit would I have to incorporating a differential backup? Essentially,...
0
votes
1answer
185 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
46 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 ...
1
vote
1answer
87 views

how to integrate ola hallengren solution with log shipping?

I need to set up log-shipping from my SQLPROD2 to server2 but I am facing the following problems: 1) I already use ola hallegren backup solution, and it provides the 15 min log backups for all ...
0
votes
3answers
775 views

Does MSSQL Log shipping truncate the transaction log?

I have setup log shipping on a database in Microsoft SQL Server 2012. I was having issues with my secondary server and I found that this was probably due to a scheduled backup job messing up the log ...
1
vote
1answer
31 views

Questions to Continuous Archiving and Point-in-Time Recovery with PostgreSQL

I'm planning my database backup strategy and came across the continuous archiving concept of PostgreSQL which is exactly what I'm looking for. I have two questions on this. I'm planning to mount ...
0
votes
3answers
76 views

How to choose which backup files to restore when identical timestamps exist for diff and log backups

I can see from an earlier question that log file backup may be performed simultaneously with either full or differential data file backups. Imagine for a moment that full backups run during a window ...
-2
votes
1answer
312 views

schedule backup Oracle [closed]

I want to schedule backups in Oracle 12c. I currently work with Windows task manager. Now I want to do it internally in Oracle to have backups every 10 minutes. Could anyone help me with that?
0
votes
1answer
1k 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;"<...
2
votes
4answers
798 views

.bak file not visible for restoration

There is a database on a server of which I would like a copy on my local machine for testing purposes, so I created a backup in the default disk location (C:\Program Files (x86)\Microsoft SQL Server\...
0
votes
1answer
60 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
2answers
26 views

Backup MySQL after inactivity

I currently backup daily which I think is fine, however, I want to backup more frequently when there's no activity (e.g., after X minutes of no INSERT/UPDATE/DELETE excluding SELECT). I'm currently ...
1
vote
2answers
111 views

How to dump multiple databases of the same cluster in single execution?

I have 100 databases in my cluster. I need to backup 30 databases (as single file or multiple file, anything is fine). I could do it for tables using pg_dump with -t. Is there any way to do ...
0
votes
1answer
50 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 , ...
1
vote
1answer
53 views

SQL Server 2014 SP2, backup and restore with powershell

I have a task where i have to take the backup with encryption and restore it to destination using the powershell. I used the invoke-sql command and use the tsql in it but this command is not ...
2
votes
1answer
556 views

Galera - single database backup & restore

I have a MariaDB Galera cluster. One of its nodes is dedicated for the backups (pc.weight=0 and the MaxScale SQL proxy doesn't know it exists). I'm using mariabackup --backup --galera-info --target-...
0
votes
0answers
47 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
196 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 ...
1
vote
0answers
31 views

How to fully dump mySQL database via workbench?

I am exporting database in SQL file using workbench. Export is done successfully, but when I import data and compare record counts with older database, some of the records are missing. Not all records ...
2
votes
1answer
54 views

Secondary filegroup for Full Text Index only - rebuild when lost

Here's our config: We have all our data in PRIMARY file group We have our Full Text Index in another SECONDARY file group which resides on a very fast (but very unreliable) SSD drive. By "unreliable" ...
0
votes
1answer
46 views

verify barman backed up files after failure [closed]

I have a barman that get backups from a postgres installed on another server. its config is: active: True archive_mode: on archived_count: 47588 archiver: True archiver_batch_size:...
2
votes
1answer
74 views

SQLServer: Backup a database on a server and restore it on another server

I would like to create a process where everyday or every week I backup a database from my production server and restore it on my staging server for testing purpose. My first idea was to create a ...
3
votes
3answers
113 views

Backing up a SQL 2008 DB, then restoring, gives a SQL 2005 (compatibility level 90) DB

We have four different databases on a SQL Server 2008 (not SP2 - don't ask me why) database server that have an odd problem. When listed from sys.databases, these databases report that their ...