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.
0
votes
1answer
16 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
0
votes
0answers
14 views
rman backup takes too long time on oracle 10g
i have a problem that my rman backup on sl45 tape drive takes 2 days to backup 450GB database, the problem that the log shows that the backup waits too long periods between finishing a certain task ...
1
vote
1answer
33 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
52 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
1answer
28 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 ...
0
votes
0answers
5 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
55 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
361 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
30 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
28 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
22 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
38 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
22 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
27 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
37 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
31 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
16 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 ...
24
votes
1answer
978 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
73 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
93 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
17 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
84 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
26 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
27 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 ...
0
votes
2answers
61 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
81 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
195 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
53 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 ...
0
votes
0answers
19 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
30 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 ...
1
vote
0answers
55 views
Giving Access to only one SQL Agent Job
I will only need to allow a user to execute a specific sql agent job rather than be able to execute the other jobs that are there . Please advice how to accomplish this
0
votes
1answer
23 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
40 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
75 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
41 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 ...
0
votes
1answer
29 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
42 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
204 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
56 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
24 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
114 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 ...
0
votes
1answer
50 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
22 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
54 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
89 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
106 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
97 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
37 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
119 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
301 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, ...
