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
0
votes
1answer
58 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
69 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
60 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
8 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
57 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
52 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
65 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
44 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
74 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
82 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
118 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
30 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
32 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
37 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
79 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
87 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
43 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
100 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
123 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
27 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
31 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
53 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
23 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
13 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
51 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
24 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
34 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
139 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
122 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
25 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
53 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
189 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
24 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
1k 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
87 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
31 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 | ...
0
votes
1answer
133 views

Which PgBackRest policy for differential backups in PostgreSQL

I set up pgBackRest and PostgreSQL configuration in two different 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
68 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
105 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
62 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
19 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
94 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
38 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
429 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
84 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
42 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
30 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
114 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 ...