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
1
vote
2answers
33 views

RMAN restoring datafile out of ASM

Why is RMAN restoring the datafiles out of ASM and how to restore a backup into ASM? Here is one output. The tablespace triscaltb was restored in /u01/app/oracle/product/12.1.0/dbhome_1/dbs/...
2
votes
2answers
31 views

Is it possible to prevent data loss with Postgres WAL archiving?

As I understand from the docs, a WAL segment is archived when the segment file reaches some size or due to archive_timeout. So if the database crashes, all the data from the incomplete, currently ...
0
votes
1answer
39 views

Ola Hallengren Transaction Log Backups of System Databases

I am attempting to backup the transaction logs of master, model in addition to the msdb. MSDB transaction log backs up without any issues, but the master and model do not. Here is the script that ...
0
votes
0answers
30 views

DatabaseBackup - SYSTEM_DATABASES - LOG [on hold]

I've recently started using Ola Hallengren's scripts for backups and I'm curious what others are doing for System Databases that are in Full Recovery Mode vs. Simple. A job was not created for "...
0
votes
0answers
15 views

SQL Server Windows backup restore on centos

I have installed sql server 2017 on my centos 7 machine. I need to restore my database backups from windows machine to this machine. I could successfully run filelistonly. However, for restore, I'm ...
3
votes
2answers
93 views

How to query data in backups?

I have an ASP.NET app using SQL Server 2017. There's a bug somewhere that's causing some records to be deleted, and I'm trying to recover the data and find the cause of the bug. We take daily backups, ...
1
vote
2answers
31 views

copy entire PostgreSQL cluster to another (identical) server

I'm looking to clone a PostgreSQL 10 cluster from server1 to server2, which is running the same Postgres version on identical hardware. The purpose is load-balancing and HA. Things to keep in mind: ...
0
votes
1answer
38 views

SQL Full Backup job is taking too long to complete

I am facing a strange issue with daily FULL backup. We have a total of 23 databases. We have 1.21 TB big database in this SQL server 2012 Standard Edition. We are taking daily FULL database backup for ...
0
votes
2answers
28 views

SQL Server Backup Database not .bak file format

I've been using SQL Server 2012 for as long as I can remember. When I do a backup it's always saved as .bak file format. However, there's this other server that has SQL Server 2012 and when I do a ...
3
votes
3answers
125 views

Is there a limit to how many backups can be appended to a single file?

A recent question got me looking at MS Documents and wondering. Is there a limit to how many backups can be appended to a single file? By default SQL Server uses NOINIT to append new backups to the ...
0
votes
2answers
50 views

Not able to delete transaction log backup file

I have a big SQL Server database (~1.5 TB) and i didn't take log backup of that database for last two weeks for some reason. Today i found that the .ldf file of that database became huge around 1.5 TB....
1
vote
1answer
25 views

Hourly differential backups with append option

With simple recovery mode, a nightly full backup, and hourly differential backups, if the hourly differential backup is set to "append" will the differential file continue to grow day after day after ...
0
votes
0answers
18 views

How to prevent regular users to backup database, in Postgresql

How can I prevent/restrict regular users, that do have select rights granted on tables etc, to perform backup of Postgres database? Is there a way to enable users to connect, select, update etc. ...
0
votes
1answer
14 views

Incomplete dumps using mysqldump

I am running Mysql server with master and slave replication. From past few days i found that backups on my master server are incomplete. When i ran manually on master it's returning the below error ...
0
votes
1answer
43 views

How to check there is enough disk space before overwriting a DB with restore command

I need to automate the restore of a database each night from a backup but I want to first check if there is enough disk space. In the below Microsoft link it says the verifyonly command is able to do ...
0
votes
0answers
17 views

mysqlbackup 8.0.16 does not recognise --defaults-extra-file option

OS-RHEL 7.4 MySQL Server- 8.0.16 commercial (trial) defaults-file=/mysql_data/config/options.cnf defaults-extra-file=/mysql_data/config/extra_options.cnf [root@exampledb01 logical_backup]# ls -l /...
0
votes
1answer
19 views

Converting MongoDB instance from Standalone to Replica Set and Backing Up

I want to convert my MongoDB 3.6 standalone server to a replica set so I can watch a collection using change streams, which requires an oplog. I only want to use change streams so will keep this as a ...
0
votes
1answer
27 views

How to succesfully set up sp_AllNightLog to create a Reporting Server?

I would like to set up a secondary, mirrored SQL Server for reporting purposes. The reporting database doesn't have to be up to date with the primary and can generally lag behind the production ...
0
votes
0answers
52 views

End of file reached. Error 38 in SQL. Passes verification checks

Having issues restoring a database in SSMS, error 38. The databases are transferred up to google via their Drive API. Download it on my side and has error. If I transfer it through teamviewer ...
0
votes
3answers
55 views

Simple and Full recovery models

Not an SQL admin and new to ola-hallengren great scripts. Just wondering if people are mostly doing a blanket user database backup with his full/diff script regardless on if a DB is in Simple or ...
1
vote
0answers
7 views

Mongodb - Small and Larger deployment

I read the following information from "https://docs.mongodb.com/manual/core/backups/" "mongodump and mongorestore are simple and efficient tools for backing up and restoring small MongoDB ...
2
votes
2answers
48 views

How is the behaviour of backupset in RMAN?

I found this definition on WEB: A logical grouping of backup files -- the backup pieces -- that are created when you issue an RMAN backup command. A backup set is RMAN’s name for a collection ...
0
votes
1answer
23 views

Database backup and restore incase Always Encrypted feature is enabled

I would like to know that How SQL database backup and its restoration on other server will work if Always Encrypted feature is implemented on most of its tables? Thanks
0
votes
0answers
17 views

Azure ARM template SQL backup deployment intermediate failure

I am having an intermittent error when trying to deploy a backup solution during provisioning. The error I get sometimes is: Deployment failed. Correlation ID: bb100978-3c7b-46f4-bcca-8b9abb490a98. {...
1
vote
2answers
43 views

How to verify the restored MS SQL DB from Backup matches with the source?

Once you restore the backup, how do you verify that the source and destination are in sync (schema, datatypes, number of records etc)? assuming that the source has not change. Appreciate your insights....
2
votes
2answers
66 views

Backup a single table

I need to Truncate a table in Sql server which containing around 250GB data but before truncating i need to take backup of this,it may to csv file or other mode. What is best way to do it.
2
votes
1answer
78 views

How to check if backups are reliable?

I generally have to restore databases to different servers after important data imports or other important and delicate database operations. I need to be sure that my backups up to that point in time ...
2
votes
1answer
60 views

Unable to backup to a UNC path with a gMSA

I'm trying to automate backups using Ola Hallengren's backup scripts. I'm testing this out on a SQL express instance 2008 R2 (I know it's EOL today). I've setup the jobs and I created a scheduled ...
0
votes
1answer
32 views

Which mechanism is best for previous data archived in oracle?

Our company has a big data server in which large data is stored, like images, video, audio, etc. Our company wants a process running with the new year, such that in 2020 the previous year's 2019 data ...
0
votes
0answers
26 views

Forgot to add a table in Transactional Replication : Initialize with backup

I have a transactional replication(with initialize from backup) setup in my server. So i setup replication as below: Used full backup(publisher database full back is scheduled every night) from the ...
2
votes
1answer
23 views

How to apply TagName for all backup files

I perform oracle database backup using the following rman command: RUN { ALLOCATE CHANNEL disk1 DEVICE TYPE DISK FORMAT 'C:\Windows\TEMP\%u'; ALLOCATE CHANNEL disk2 DEVICE TYPE DISK FORMAT '...
1
vote
1answer
32 views

Give me suggestion about backup of schema and full backup in oracle

I need your help about backup in oracle database. Currently I am using Export Utility of Schema Backup but taking more time to complete and size is 40GB. For full database backup using Image Copy and ...
2
votes
2answers
58 views

Backup on Share NFS fails - Windows Server 2008 R2

I've a network disk where backups are stored every night, but after some hour the backup fails with the following error: Executing the query "BACKUP DATABASE [foo] TO DISK = N'\\XXX.XX.XX...." ...
0
votes
0answers
24 views

mysqlpump --set-gtid-purged=OFF still adds @SESSION.SQL_LOG_BIN=0;

Whenever I add --set-gtid-purged=OFF, it still adds @@SESSION.SQL_LOG_BIN=0; to the output. According to the documentation, shouldn't it get removed? --set-gtid-purged=OFF: SET @@SESSION.SQL_LOG_BIN=...
0
votes
1answer
32 views

Impact of moving the ldf and mdf files temporarily for few hours [duplicate]

I want to copy my database files(ldf and mdf) into a separate box for few hours as there is a disk space issue in my current sql server box. Currently i have mdf in one drive(:D) and ldf in another ...
1
vote
1answer
62 views

SQL Server Backup failing Error :3041

I am running SQL Server 2008R2 Express edition. For all databases full backup, I am using expressmaint.exe. In this, I am using the command -S server name -D ALL -T DB -R D:\SQL_BACKUP\...
1
vote
1answer
33 views

PostgreSQL - do we need to DROP the database and recreate it if we want to RESTORE it?

I worked with many different databases (SQL Server, Oracle, IBM db2) and for all of them if we have a backup it is just enough to execute RESTORE command in order to restore the data. I am beginner ...
0
votes
1answer
23 views

Backing up and restoring all databases in MySQL on linux

I plan to dump all databases on one computer and restore them on another using the following 2 commands:- mysqldump -u username -p --all-databases > dump.sql mysql -u username -p < dump.sql ...
0
votes
0answers
30 views

Striped SQL Backup - Benefits [duplicate]

We have a 3TB database, and current backup schedule is - Weekly Full Backup, Daily Diff and hourly transaction log from maintenance plans. All these backups are performed using Backup command and ...
0
votes
1answer
35 views

Can you restore purged MySQL binary logs?

I have two situations I need some clarification. 1) Let's say I made a backup of all the MySQL binary logs before I purged a single binary log file (the oldest one, possibly the very first one). ...
0
votes
1answer
19 views

What kind of changes does snapshot file store?

Assume that I created a database called [DBS] and inside that database I created a table called [products]. Then I inserted 4 rows into [products]. Afterwards I took a snapshot of [DBS]. As a result,...
0
votes
0answers
10 views

Migrate data from database on MarkLogic 7 to database on MarkLogic 9

I need to copy data from a MarkLogic 7 database to MarkLogic 9 database on another system. I tried backup and restore option provided by the MarkLogic Admin console. The original database in MarkLogic ...
2
votes
1answer
27 views

How to attach a sql db with blobs using a shared folder?

I use the following query for attaching a sql db: CREATE DATABASE [myDb] ON (FILENAME=N'C:\myDb\myDb.mdf'), (FILENAME=N'C:\myDb\myDb_log.ldf'), (FILENAME=N'C:\myDb\FILESTORE') FOR ATTACH In ...
1
vote
1answer
42 views

Show backups at server level

I have an SSRS report which shows the 'last backup time' next to each server in the list. I am getting this information by using: SELECT TOP 1 @@SERVERNAME as serverName, sdb.Name AS DatabaseName, ...
0
votes
0answers
11 views

MABS - Synchronization frequency for New Protection Group is not showing up for a user database

I am trying to create a user database policy that does incremental 15 min log backup, however when I get to "Specify Short-Term Goals" in the "Create New Protection Group" wizard, the "Synchronization ...
0
votes
2answers
27 views

Took a full backup of a running mariadb server and restored, but none of the databases are visible

I'm setting up a mariadb galera cluster to ultimately switch production to. However, I don't have the ability to stop the production instance so I'm trying to set this up using various workarounds I'...
0
votes
0answers
29 views

Azure sql database backup and exporting data-tier application

Currently i have an azure subscription in it has a server and a database. How could i setup azure SQL database backups that will run automatically for example every 15 mins? is there a way? if yes ...
2
votes
1answer
44 views

Does the SQL Server Service Account have to have access to a network share to perform a backup?

I've been provided a specific domain account to handle backups from my sysadmins. I am slightly confused as I've never been provided a separate domain account to handle backups in the past. I still ...
0
votes
0answers
16 views

What is a good backup method for Azure SQL?

I maintain a Azure SQL database with the Basic plan. 7 days point in time restore is enough for our daily needs. What we are looking to improve is a daily backup outside Azure in the case that we lose ...
2
votes
1answer
41 views

Oracle isn't restoring correctly a backup

First of all I'll say I'm using: Oracle Database 11g Express Edition Oracle SQL developer What I'm trying to achieve Create a backup and restore it, so for example I can delete a table after a ...