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
2answers
34 views
How to choose which backup files to restore when identical timestamps exist for diff and log backups
I can see from an earlier question that log file backup may be performed simultaneously with either full or differential data file backups.
Imagine for a moment that full backups run during a window ...
-2
votes
1answer
34 views
schedule backup Oracle [on hold]
I want to schedule backups in Oracle 12c. I currently work with Windows task manager. Now I want to do it internally in Oracle to have backups every 10 minutes. Could anyone help me with that?
0
votes
1answer
17 views
Postgresql - Large object exists in pg_largeobject table but cannot open with lo_open?
I have a problem with opening Large Object in postgresql version 9.2,
select * from pg_largeobject where loid = '19423';
will return data like this:
loid oid;page no integer;data bytea
19423;0;"<...
2
votes
4answers
61 views
.bak file not visible for restoration
There is a database on a server of which I would like a copy on my local machine for testing purposes, so I created a backup in the default disk location (C:\Program Files (x86)\Microsoft SQL Server\...
0
votes
1answer
23 views
Backup of MongoDB collection data and rename the collections [duplicate]
I want to take a collections data backup on a different host, with renaming the Collections.
I am very new to MongoDB. Please help me with this task.
0
votes
2answers
20 views
Backup MySQL after inactivity
I currently backup daily which I think is fine, however, I want to backup more frequently when there's no activity (e.g., after X minutes of no INSERT/UPDATE/DELETE excluding SELECT).
I'm currently ...
0
votes
0answers
12 views
Postgres sequence table not updated
I am new to postgres so just trying to get some insights, our postgres database is hosted on Azure and we had to restore our postgres database on the local server.We did take the backup through azure ...
-2
votes
0answers
9 views
Why we using the Online database instead of Physical database? [closed]
when we design the website then why we are using the online database, why we are not using the physical existence database, Is it costly or long process.
What is better way to choose via i am ...
1
vote
2answers
32 views
How to dump multiple databases of the same cluster in single execution?
I have 100 databases in my cluster. I need to backup 30 databases (as single file or multiple file, anything is fine). I could do it for tables using pg_dump with -t.
Is there any way to do ...
0
votes
0answers
23 views
How can a MariaDB master can get transactions back from another master after restore of backup?
I set up a Master-Master-replication with MariaDB 10.3.11 with enabled GTIDs and master_use_gtid=Slave_Pos. The two hosts (master1 and master2) have different domain-ids and different server_ids. ...
0
votes
0answers
13 views
Error 2013: Lost connection during Query when dumping the table
I try to add the column on the table by using alter query almost query is going to complete in that time it shows an error
Error Code: 2013. Lost connection to MySQL server during query.
I increase ...
0
votes
0answers
37 views
Ola Hallengren backup AG and directory path
I have please questions about Ola Hallengren backup
backups on AG -
If I have more than 1AG , the backup setting in case primary or secondary is based on first group ?
directory paths -
is there ...
0
votes
1answer
21 views
Full backup vs Simple TempDB usage [closed]
What is the difference in terms of I/O disk usage between Simple Backup and Full Backup?
Does full backup incur more reads and writes?
How does full backup mode impact reads and writes to TempDB's ...
0
votes
0answers
28 views
LDF file size is very huge even after doing Transaction log backup [duplicate]
I work on a SQL Server 2016 Database and in our production environment we have primary SQL server and a fail over SQL server.
All the transactions are occurring on the primary SQL server.
In primary , ...
1
vote
1answer
25 views
SQL Server 2014 SP2, backup and restore with powershell
I have a task where i have to take the backup with encryption and restore it to destination using the powershell.
I used the invoke-sql command and use the tsql in it but this command is not ...
2
votes
0answers
18 views
Galera - single database backup & restore
I have a MariaDB Galera cluster. One of its nodes is dedicated for the backups (pc.weight=0 and the MaxScale SQL proxy doesn't know it exists).
I'm using mariabackup --backup --galera-info --target-...
0
votes
0answers
18 views
Archiving SQL Server data on disk to be pottentially restored
Right now, we are backing up data per table into text/CSV files per month. This works fine for fairly small tables. For bigtables, the text files become so big that the restore process for a month ...
0
votes
1answer
34 views
The value for the parameter @MirrorDirectory is not supported error with Ola Hallengren Backup script
I am using Ola Hallengren's Maintenance Solution, and it's been working great for our environment.
Quick question regarding the User Database backups s proc. Currently, when I'm taking backups, the ...
1
vote
0answers
13 views
How to fully dump mySQL database via workbench?
I am exporting database in SQL file using workbench. Export is done successfully, but when I import data and compare record counts with older database, some of the records are missing. Not all records ...
2
votes
0answers
15 views
Secondary filegroup for Full Text Index only - rebuild when lost
Here's our config:
We have all our data in PRIMARY file group
We have our Full Text Index in another SECONDARY file group which resides on a very fast (but very unreliable) SSD drive. By "unreliable" ...
0
votes
1answer
14 views
verify barman backed up files after failure [closed]
I have a barman that get backups from a postgres installed on another server. its config is:
active: True
archive_mode: on
archived_count: 47588
archiver: True
archiver_batch_size:...
2
votes
1answer
59 views
SQLServer: Backup a database on a server and restore it on another server
I would like to create a process where everyday or every week I backup a database from my production server and restore it on my staging server for testing purpose.
My first idea was to create a ...
3
votes
3answers
105 views
Backing up a SQL 2008 DB, then restoring, gives a SQL 2005 (compatibility level 90) DB
We have four different databases on a SQL Server 2008 (not SP2 - don't ask me why) database server that have an odd problem.
When listed from sys.databases, these databases report that their ...
1
vote
1answer
90 views
How to make a distibutable .bak file?
I am trying to restore 2 databases. One is adventureworks database downloaded from msdn(its .bak file), and another one is created by me from one databases from my old server. Both have .bak extension,...
0
votes
0answers
32 views
Citus backup using barman
I'm trying to backup a Postgres Citus setup using Barman through a streaming-only configuration. I've set up server configs for the coordinator and backup nodes in Barman.
WAL streaming seems to work ...
2
votes
1answer
394 views
Killed Backup in Rollback State for Days
I killed a backup job of an 80 MB database which has been rolling back for days...
I tried to take the database into single user mode, but that too hung in rollback state.
I tried killing all ...
1
vote
2answers
41 views
Restore a database by pointing to one or more directories containing backup files and specifying a STOPAT time [duplicate]
I'm working on prepping/testing migration of our ERP and other auxiliary systems to a new database server. This will involve restoring database backups from the old server onto the new one.
For the ...
1
vote
0answers
50 views
PostgreSQL 10.3 pg_dumpall fails: server closed the connection unexpectedly
System: Windows 10 Pro 64bit, Version 10.0.17134 Build 17134. with Postgres 10.3 db server.
I backup my postgres db using the following statements:
"C:\PostgreSQL\pg10\bin\pg_dumpall.exe" -U ...
0
votes
1answer
57 views
Help me with sql backups please
I'am facing some difficulties regarding my Sql Backup method, i am not sure if my method is correct, i am using a backup method described below;
Created a Full backup named Xbackup in Maintenance ...
0
votes
2answers
49 views
backup the difference with sql server express between 2 timestamps
I am newbie to sql and have sql server express edition installed on my PC and contains
a database 'Jdatabase' on 1sept and took a backup(by right clicking on database -> tasks->backup using 'sql ...
0
votes
0answers
14 views
Provide variable for backup location
Is it possible to use a variable to populate the location where the backup files are to go (@Directory = @BULocation)? If yes how would that work.
0
votes
0answers
26 views
Azure SQL Database finding latest available restore point
From reading books online it is clear that there are two types of retention for Azure SQL Database.
Backups for point-in-time restore
Backups for long-term retention
When it comes to restore there ...
1
vote
0answers
67 views
Error with Ola Hallengren backup job after upgrading SQL Server 2016 to SP2 [closed]
Recently I updated SQL Server 2016 with SP2.
After that, the Ola Hallengren backup job failed throwing the error below:
Source: https://ola.hallengren.com
[SQLSTATE 01000] (Message 50000) ...
0
votes
0answers
41 views
SQL Server AlwaysOn backup transaction log on secondary, error appear in log
I have a SQL Server 2016 AlwaysOn with two nodes.
I set the backup preferences as follow: Primary, node1 50%, node2 50%. I configure a full backup job (custom script verifying sys....
5
votes
1answer
71 views
Managed backup large database to Azure
Got a bit of an issue here that I need some help to solve.
Hosting a database, that is about 400Gigs. This is giving us a little headache getting it to work with Managed Backup to Azure Storage ...
0
votes
1answer
40 views
Concurrent backups in MS SQLServer 2008 R2
Can anyone please point me to a piece of documentation that suggest how many concurrent backups initiated by different BACKUP statements are possible in Microsoft SQL server 2008?
The documentation ...
0
votes
2answers
52 views
Transaction log backup - Only full recovery model?
I am reading this book from Microsoft - it says:
"A log backup cannot be performed unless the database is in full recovery model and an initial full backup has been performed"
Is this correct? I know ...
0
votes
2answers
37 views
What is technical meaning of point in time recovery?
Please can I have a technical meaning of point in time recovery? Does it mean that given a backup file, we must be able to recover upto any point in time during the span of the time covered by the ...
0
votes
2answers
40 views
In Full recovery mode, when does the buffer/transaction log changes get applied to the database data pages?
When a change is to be made, the data page is fetched from the database data file into the buffer and changes are made to the buffer page and are also written to the transaction log. Write ahead ...
0
votes
1answer
24 views
How to accomplish such insert-or-update strategy?
Programming stored procedures isn't my strongest point when it comes to programming, but I'm trying to get better.
I've stumbled upon a business requirement that's kind of hard for me and I was ...
0
votes
1answer
46 views
How to change the SQL Server Backup file (.bak) file default icon?
As I would like to say that by mistake the SQL Server 2012 backup file (.bak) open with wordpad. Due to this reason all backup files of SQL Server (.bak) file change with wordpad icon in entire the ...
1
vote
0answers
53 views
Log Shipping with minimum synchronization gap
We will have an application that will go live soon. I will be using Log Shipping for Disaster Recovery but I am confused about the Job scheduling. The transaction logs will be taken every 10 minutes ...
1
vote
1answer
45 views
Backup via mysqldump. Is this safe to do on production or will it crash the server?
I want to run this command during the time in which the production server is running the application:
mysqldump -u sbp -p databasename_production > databasename_development_copy.sql
Is this safe ...
0
votes
1answer
45 views
SQL server - Re. Filegroup / partitioning
Assuming VLDB is split into multiple file groups, each having its own file and on a separate disk.
Now let's say there is a disk crash bringing down one of the file groups - then will the other parts ...
3
votes
2answers
139 views
Database backup - Use case of FORMAT and INIT
I understand that FORMAT looks at mediaset level and if set then creates a new media set so if there are any existing backupsets then they will no longer be available.
Also, INIT looks at backupset ...
0
votes
3answers
54 views
Very large MySQL backup
At our company we have a very large MySQL server with almost 1.000 databases with a total size of 500 GB. Every customer has is own database. And each database has about 120-125 tables!
In the past ...
1
vote
1answer
71 views
Full Database backup internals
My understanding of a full backup is (based on https://technet.microsoft.com/en-us/library/2009.07.sqlbackup.aspx - most of the below is copied, from this link):
Force a database checkpoint and make ...
4
votes
4answers
472 views
SQL server database backup - Destination Disk - Adding multiple files - does it duplicate or split backup into the files?
When we do full data backup (using SSMS UI), at the bottom of the window we have the option to specify the destination as Disk and also to add multiple files.
My question is - does adding multiple ...
1
vote
0answers
45 views
Handling backups of a large table (>1 TB) in Postgres?
I have a 1TB table (X) that is a pain to backup.
The table X contains historical log data that is not often updated after creation. We usually only access a single row at a time, so performance is ...
4
votes
2answers
163 views
Backup cut-off time for Full, Differential, Log, File, Partial backups
My understanding was that all backups contain data up to the time/point when backup operation was completed.
Administering a SQL Database Infrastructure - Exam Ref 70-764 says:
Full: This contains ...
