Skip to main content

New answers tagged

1 vote

Oracle database backup recovery

There are two separate task here: restore and recover database and perform upgrade. Let's start with the first one. Let's pretend you have instance of 10G installed. First of all you have to create an ...
SergeyA's user avatar
  • 763
2 votes

Does it make sense to Full Back up weekly or Back up Transaction Log every 15 min?

First thing you need to consider is your tolerance to data loss in case of a disaster. RTOs/RPOs define your backup strategy and not the overhead of management. For example : If you have a server ...
Ramakant Dadhichi's user avatar
4 votes
Accepted

Does it make sense to Full Back up weekly or Back up Transaction Log every 15 min?

Which option makes more sense / easier? First question is what problem you are going to solve? How are you going to use your backup? Are you setting log shipping to other party? Do you need point in ...
SergeyA's user avatar
  • 763
3 votes

Does it make sense to Full Back up weekly or Back up Transaction Log every 15 min?

Yes. Refer to How to Configure Ola Hallengren’s Database Maintenance Scripts for Backups To summarize: Run Maintenance Solution.sql Configure the Agent Job(s) with the correct database name(s) & ...
Peter Vandivier's user avatar
1 vote

Is there a full copy of data on each node if RF=3 and DC has 3 nodes?

The quick answer is yes, each replica owns 100% of the range when the replication factor and number of nodes in the DC are the same. However, 100% ownership does not guarantee that each replica (node) ...
Erick Ramirez's user avatar
0 votes

How do I restore a PostgreSQL/TimescaleDB pg_basebackup tar on Windows? postgresql-x64-15 immediately stops on start

The issue was twofold, leaving here in case it helps anyone else. First, I had a docker container running a timescale instance that was occupying the port that was used where the backup was taken. ...
Scott's user avatar
  • 101
0 votes

MySQL Backup (.cfk) file to Microsoft SQL Server

so what if i want to back it up with MySQL You can't, it's incompatible. If you want to transfer your database from MySQL to SQL Server, you have two main options: Script out the entire database as ...
J.D.'s user avatar
  • 38.1k
0 votes

unknown database backup file extension *.gbk

It is Firebird or Interbase. The database generally has an extension of .gdb or .fdb and the backup is generally .gbk From Destructor.de GBAK Firebird Backup and Restore For backups, is the ...
Rohit Gupta's user avatar
  • 1,678
1 vote

unknown database backup file extension *.gbk

It cloud be InterBase or Firebird.
M. Behrens's user avatar
2 votes

Can we take a copy-only backup for filegroups on the SQL Server from a secondary HA replica?

The Docs state this is possible (emphasis mine): BACKUP DATABASE supports only copy-only full backups of databases, files, or filegroups when it's executed on secondary replicas. Copy-only backups ...
Sean Gallardy's user avatar

Top 50 recent answers are included