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,901
questions
0
votes
2answers
42 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
5 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
42 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
20 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
8 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
40 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
63 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
68 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
56 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
31 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
25 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
31 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
47 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
19 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
54 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
31 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
29 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
33 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
26 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
10 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
0answers
21 views
Copying partitions from one clickhouse instance to another, won't attach
I am currently working out a solution to free up space from one clickhouse node (not clustered as of yet) by freezing old partitions and attaching them to a different node, then deleting them from the ...
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
20 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
41 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
15 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
40 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 ...
5
votes
2answers
185 views
Full backup on database creation
When new databases are created the Differential and transaction log backup maintenance plans start failing and sending alerts as full backup is not taken. What could be the best solution to handle it.
...
0
votes
1answer
18 views
How can I import an old pgdump into an updated schema?
I'm DB newb doing a software upgrade, and my predecessor's original migration plan may not have been as well thought out as I thought...
The Plan was to use our backup, created via
pg_dump -U derp -...
5
votes
2answers
989 views
Do I need full recovery mode when I have multiple daily backup?
I have created 5 maintenance plans on my SQL server (say 50 !) which generate databse backup 5 times daily. As I read in this Q/A the full recovery is good when I need Point-in-time recovery.
My ...
1
vote
1answer
51 views
Sensible database backup retention policy? [closed]
Scenario:
DB is replicated in two availability zones (for high-availability)
DB is backed-up daily in geographically separate location (for disaster recovery)
App-level user events are stored in the ...
0
votes
1answer
19 views
PSQL incomplete backup : how to debug
I've been doing backups of my database " screen ".
after connecting to PSQL and typing \l+
I'm getting (among other things):
Name | Owner | Encoding | Collate | Ctype | ...
1
vote
0answers
24 views
Which PgBackRest policy for differential backups in PostgreSQL
I set up pgBackRest and PostgreSQL configuration in two differents servers.
I set up with crontab one full backup a week and one differential backup a day.
0 1 * * 0 pgbackrest --type=...
0
votes
1answer
28 views
Barman: What's the best way to switch from backup_method postgres (streaming) to rsync (ssh)?
My production postgresql server is currently backed up with barman using the backup_method postgres (streaming server). I would like to switch to rsync method (ssh) to benefit from better compression. ...
1
vote
0answers
53 views
OCI KBHS-00719: Error 'unknown'; Archived object is not restored
I am encountering below error message from RMAN backup to OCI.
Either the bucket named 'DB_BACKUP' does not exist in the namespace
'UNIcredits' or you are not authorized to access it. KBHS-01404:...
0
votes
1answer
25 views
Monitoring PostgreSQL backup
I am new to PostgreSQL and have questions regarding the backup procedure.
How do I check whether a PostgreSQL database was backed up successfully?
And how do I monitor the backup?
I have tried the ...
0
votes
1answer
15 views
Will this RedGate backup plan interfere with a new differential backup plan I want to create?
First, I need to get an assumption verified: If I setup a differential backup plan and someone comes along and manually creates a backup without specifying COPY_ONLY then it's going to throw the plan ...
1
vote
1answer
62 views
What will be inside the last differential backup file?
I am new in DBA and while learning different types of backup, one question came into my mind. So the question is, what will be inside the last differential backup, just the sum of the previous ...
2
votes
2answers
26 views
Will I be notified that BACKUP encountered a CHECKSUM error if I use CONTINUE_AFTER_ERROR?
I am in the process of adding the WITH CHECKSUM flag on our daily SQL backups, as part of an effort to better ensure data integrity.
I definitely want to know if a checksum error is ever encountered, ...
7
votes
3answers
425 views
Can full drive backup be used instead of MSSQL database backup?
I have a MSSQL Express server running on a VM. Hosting provider I use has an option to create drive snapshots. The server is running all the time and is not stopped during the drive backup. Backup ...
0
votes
1answer
47 views
UTL_RAW “invalid identifier” error message
When I execute the following:
select utl_raw.cast_to_raw('8') from dual;
I receive the error message below:
invalid identifier
...while in other PC with the same Oracle version, i.e., 11g, the ...
0
votes
2answers
40 views
Backup MS SQL AG on a non-production environment
We've created a non-production environment for SQL Server.
This environment uses the SQL Server Always-On Availability Groups as a HA-solution.
To work with SQL Server AG's you have to set the ...
0
votes
0answers
28 views
mysqldump writes dumped data to output
I'm trying to bring incremental backups to one old setup. The script I create worked perfectly when run directly. However when I run it from crontab or when redirecting shell output all data is ...
0
votes
2answers
25 views
What is the behavior of SQL Server Maintenance Plan - Clean Up task for deleting old backups
This seems pretty obvious, but it's remarkably hard to find an actual document that addresses this.
The scenario:
Full Backup - Weekly (Set to expire after 7 days)
Differential Backup - Daily (Set ...
1
vote
1answer
84 views
SQL Server TDE Vs SQL Server Database Backups
Can anyone please help me understand below case:
Kindly advise on below case:
SQL Server is on 2014 SP2 GDR version
I read Compression and TDE does not go hand in hand .
I have 2 PRD Environments:...
