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.
1,802 questions
0
votes
0answers
27 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
15 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
29 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
1answer
55 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....
4
votes
1answer
88 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
33 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
115 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
295 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
35 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
29 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
0answers
9 views
postgresql backup DB restore error
PostgreSQL 10 with PostGIS 2.4 linked to a Django (1.11.18). Currently moving my DB to a remote server and going through the backup and restore process.
Backup Process
PGAdminIII - backing up with ...
0
votes
1answer
16 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
26 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
25 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
37 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
74 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
32 views
+100
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
42 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
19 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
62 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
54 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
63 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
20 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
38 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
53 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
23 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
56 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
45 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
51 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
95 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
28 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
23 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
34 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
22 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
26 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
0answers
46 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
25 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
54 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
14 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
19 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
14 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
59 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
106 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 ...
1
vote
1answer
91 views
How to make a distibutable .bak file?
I am trying to restore 2 databases. One is adventureworks database downloaded from msdn(its .bak file), and another one is created by me from one databases from my old server. Both have .bak extension,...
2
votes
1answer
408 views
Killed Backup in Rollback State for Days
I killed a backup job of an 80 MB database which has been rolling back for days...
I tried to take the database into single user mode, but that too hung in rollback state.
I tried killing all ...
1
vote
2answers
43 views
Restore a database by pointing to one or more directories containing backup files and specifying a STOPAT time [duplicate]
I'm working on prepping/testing migration of our ERP and other auxiliary systems to a new database server. This will involve restoring database backups from the old server onto the new one.
For the ...
1
vote
0answers
108 views
PostgreSQL 10.3 pg_dumpall fails: server closed the connection unexpectedly
System: Windows 10 Pro 64bit, Version 10.0.17134 Build 17134. with Postgres 10.3 db server.
I backup my postgres db using the following statements:
"C:\PostgreSQL\pg10\bin\pg_dumpall.exe" -U ...
0
votes
1answer
57 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
2answers
51 views
backup the difference with sql server express between 2 timestamps
I am newbie to sql and have sql server express edition installed on my PC and contains
a database 'Jdatabase' on 1sept and took a backup(by right clicking on database -> tasks->backup using 'sql ...
