New answers tagged backup
0
votes
Difference between Backup and Snapshot
Since this can concern filesystems, databases, version control systems, and other things, I'll just use the term "data" for whatever it is you're backing up or snapshotting, and "system&...
- 811
5
votes
Difference between Backup and Snapshot
You have to be very specific about the terminology used.
SQL Server Database Backups
Backing up your SQL Server database is essential for protecting your data. This discussion covers backup types, ...
- 17.4k
2
votes
Difference between Backup and Snapshot
Just want to point something for snapshot usage. Both snapshot and backup will let you recover database when needed but the ways that they are stored and used are quite different.
Backup, I mean full ...
- 46
3
votes
Difference between Backup and Snapshot
Everything is made in a point in time. That's just how physics work. Unless you live in a black hole where time does not exist or something. That phrase just makes no sense to me. The back up is made ...
- 35.2k
0
votes
Reading data from PostgreSQL backup directory
Edit pg_hba.conf and add this line on top:
local all all trust
After reloading the server, you should be able to establish a local (domain socket) connection without entering a password. To avoid ...
- 48k
0
votes
Merging old backup in current database mysql
There is a solution to this, but you may not be able to employ it.
The solution is to use the binary logs, which contain serial events that updated data. The idea is that you would restore your backup,...
- 13.9k
0
votes
Get postgres snapshot from Amazon RDS
Navigate to the snapshot list in AWS RDS console
Select a desired snapshot with a checkbox
In the "Actions" dropdown button in the top right corner select "Export to S3"
Download ...
1
vote
Accepted
how percona hot backup works / innodb crash recovery works?
The LSN (Log Sequence Number) is analogous to binary log position, but the redo log is a different log. It applies only to InnoDB pages, and it contains physical diffs of the pages affected. During ...
- 13.9k
1
vote
Accepted
RMAN backup restoration
Try using these init parameter file settings in the destination:
*.DB_FILE_NAME_CONVERT = "/u01/app/oracle/oradata/db1/datafile","/u01/app/oracle/oradata/db2/datafile"
*....
- 196
0
votes
maintaing backup log sequence after executing BACKUP DATABASE databasename command manually
Is supposed in my scenario a break did occur in my log backup chain ,
how can I restore normal flow
Differential backup let you jump over gaps in log backup chain.
- 393
3
votes
maintaing backup log sequence after executing BACKUP DATABASE databasename command manually
If you use the COPY_ONLY option, the new backup does not interrupt (or otherwise take part in) your normal backup chain.
- 32k
1
vote
What sql statements is mysqldump executing and how does it affect database performance?
Yes, mysqldump runs long-running queries like SELECT * FROM <table> WHERE .... Mysqldump is single-threaded, so it will do one table at a time.
You could create a distinct MySQL user to run ...
- 13.9k
1
vote
Accepted
Does a SQL Server Log Backup Include Log Records Backed Up in a Previous Full or Differential Backup?
A log backup taken after a full or differential backup will include any log records created between the time of the last log backup and the time of the current log backup.
A full backup includes ...
- 46
Top 50 recent answers are included