Stack Overflow
Stack Overflow

Questions tagged [backup-strategies]

169 questions
0
votes
1 answer

Libreoffice Multiple Backups?

Is there a way, setting, macro, or otherwise, that can automatically create backups of the current document in a series? Such as, working on a Writer document, pressing a macro button, and creating a backup at that time, so that there is another…
solologos
  • 3
  • 1
0
votes
1 answer

getting permission denied for relation in potgresql

I connected to my db using this command psql -U bm_clients -d Bayne_DB and then I tried to run this command Bayne_DB=> GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA abcd TO bm_clients; For which I received this error ERROR: permission denied for…
shubhendu
  • 341
  • 2
  • 17
0
votes
1 answer

How to make this bash script NOT delete all my files?

I have a cron job, every 5 minutes, backing up my MYSQL to files ending in .sql.gz. But this is hundreds of files a day. So I searched the internet and found this bash script which I expected to just work on the files in the /backup folder specified…
Norman Bird
  • 642
  • 3
  • 10
  • 29
0
votes
1 answer

How to take druid segment data backup?

I am new to druid. In our application we use druid for timeseries data and this can go pretty large(10-20TBs). Druid provide you facility of deep storage. But if this deep storage crashes/or not reachable then it will result in data loss and which…
Rahul Vedpathak
  • 1,346
  • 3
  • 16
  • 30
0
votes
1 answer

How to save a snapshot of Azure Synapse SQL Pool (Data Warehouse) in another Active Directory Subscription?

There is a data warehouse (Azure Synapse SQL Pool) in Azure Active Directory (ABC). For learning purpose, we wanted to create same copy in another Azure Active Directory (XYZ). Currently, I couldn't find any option to save the restore point in…
Itz.Irshad
  • 1,014
  • 5
  • 23
  • 44
0
votes
0 answers

SQL Server Database Backup Size Variation

When I did a database backup a day before yesterday, it was 413 MB big. When I did it yesterday, the size was 389 MB. When I run the backup today, the size is about 452 MB. What is the reason for the variation on database backup size?
Jag's
  • 9
  • 1
0
votes
2 answers

Postgresql - restore SQL dump with tablespaces

I'm planning to move some tables to different tablespaces (folders) on my PROD Linux box. Overnight DB backups are done using pg_dumpall I have also DEV environment working under Windows OS Im usually restoring sql dump (made on Linux). Im worrying…
Maciej
  • 10,423
  • 17
  • 64
  • 97
0
votes
1 answer

Synchronize File Server and Database Backups?

I'm currently building a backend application that will need to store and serve a lot of images and videos (> 1 Mio. each). The files will obviously get uploaded and sometimes deleted but not updated. I did some reading on the issue of whether to…
Wecherowski
  • 818
  • 11
  • 24
0
votes
1 answer

move part of table postgresql to another database

I have a mission and searching for advice. On my postgresql database one of tables contains data from few years - I want to move part of it to another database. Condition of splitting will be record create date, but this filed is varchar. This table…
DekeR
  • 55
  • 8
0
votes
1 answer

Azure Recovery Vault backup configuration missing the Cross Region Restore option?

My recovery vault is in the West US 2 region, and I cannot see the option to enable a Cross region restore as seen in the Azure documentation here. Screenshot from documentation shows this option: My Azure UI: Question: Why is this feature not…
Prashanth Subramanian
  • 593
  • 7
  • 26
0
votes
0 answers

C# desktop app/SQL Server backup strategies

I am planning to make a C# desktop app with SQL Server 2019 Express. Because I am not so familiar with SQL Sever, it'd be appreciated if any advice given on the feasibility of my thoughts, thanks in advance! Here are my planned backup…
a_pp
  • 39
  • 7
0
votes
1 answer

Best way to backup Rundeck

I need your help on a subject. I need to perform a backup of our Rundeck system and send it to a server in the GCP, but there are more than 90GB of information and I don't know how to make this backup. All my attempts to compress using gzip, bzip2,…
Carlos Nascimento
  • 1
  • 1
0
votes
0 answers

Backups Best Practice for SQL Server IaaS

What is considered best practice for SQL backups for SQL Servers (specifically 2017) running in an Azure VM? I'm aware of: Normal SQL Backups to Local Disks Azure Backup Backup to URL VM Snapshots What I'm considering is: Running an Azure…
Philip
  • 2,460
  • 4
  • 27
  • 52
0
votes
2 answers

Partial import of Sql server 2005 database for local developement

So at work, my team is using a central SQL server 2005 database server for integration testing and I want to move to testing on my local database. The only problem is that the central database is in excess of 10 Gb. I am interested in importing the…
user35559
  • 1,018
  • 3
  • 11
  • 21
0
votes
1 answer

Using Ola Hallengren's backup scripts, I want to back up each hour but only keep 1 backup per day more than 1 day old

We have a full backup hourly, which really builds up, even when we have set our Ola Hallengren statements to 'cleanuptime = 168' which removes old backups > 1 week. This is still too many backups to keep and our disk space is limited. We don't want…
cloudsafe
  • 2,444
  • 1
  • 8
  • 24
1 2 3
…
11 12