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.
2,018
questions
0
votes
1answer
40 views
SQL Server with small database size and huge log file size
I have several databases, for some log file size is growing more than normal even though very little data is added to few table around 50-100 rows a month. i.e. Database 12 data file size is 79MB and ...
1
vote
1answer
22 views
Postgres backup PITR strategies [on hold]
Note:-Might be the question sounds too broad. But, I believe ,it's very good platform(stackexchange) and I can get advice from worldwide expert DBA here. Since, I'm not able to make decision or choose ...
1
vote
1answer
20 views
Ignore a database in an Availability group when using @AvailabilityGroups = instead of @Databases with ola-hallengren backup solution
I’m using the @AvailabilityGroups= parameter to backup availability groups, is it possible to NOT backup (exclude) a database in the Availability group?
If using the @Databases parameter I could use -...
0
votes
2answers
34 views
pg_basebackup failing from another server
I want to take backup of my PostgreSQL database cluster from another server. I'm using below command ,from another server:
[root@shiwangini2 pgsql]# sudo -u postgres pg_basebackup -h 192.168.XX.XX -...
0
votes
0answers
13 views
mariabackup slave info and multi-master replication
I have several master databases using mariadb 10.3 and replicate then all to one replica using multi-master replication. All is working fine.
I want to backup that replica server, so i can restore it ...
13
votes
1answer
2k views
Temporarily moving a SQL Server 2016 database to SQL Server 2017 and then moving back. Is it possible?
If I take a backup of a database from a SQL Server 2016 instance and then restore it to a 2017 instance to do some work on it.
Can I then turn around and back up that database from the 2017 instance ...
0
votes
1answer
33 views
Incremental backup split across files
I have to move a database from one cloud provider to another. It has to be done in an hour window. The DB is 16Gb, and the line speed between the current host, and Azure (The final destination) ...
0
votes
0answers
35 views
Can stopping a backup job while its in progress affect future backup jobs?
Can stopping a backup job while its in progress affect future backup jobs? i stopped a backup because it was taking too long and affecting production, and since then all my backup jobs have failed. ...
0
votes
1answer
25 views
How to solve a mail issue Failed to initialize sqlcmd library with error number -2147467259?
I got an error while trying to send an email:
Msg 22050, Level 16, State 1, Line 0
Failed to initialize sqlcmd library with error number -2147467259.
Here is my query:
DECLARE @Table TABLE (
...
1
vote
2answers
68 views
Sql Server Restoring Process Time Takes Too Long Time
I have 7 databases on my reporting server. I restore those databases every night with differetial backups. Normally, the differential restore time was taking about 1 or 1.5 hour for each databases. ...
0
votes
1answer
12 views
Azure PostgreSQL pg_dump impact on backup “chain”
I'm a SQL Serve DBA new to PostgreSQL. Does pg_dump have an impact on the backup chain, i.e., in SQL Server if I needed a copy of a database I would peform a COPYONLY backup so as not to break the ...
0
votes
1answer
68 views
Error 23 on transaction log backup, full backup works fine
I have a database with the database files on the E: drive, and logs files on the D: drive.
I'm getting the following error when trying to run a transaction log backup:
Read on "D:\LOG\AOA_Log.ldf" ...
0
votes
1answer
34 views
How to add multiple query results into one csv file?
By the help of the members of this community I have created a script which shows recent T-log backup for each database in the server. Instead of sp_MSforeachdb I used a customized script written by ...
0
votes
1answer
43 views
How to exclude tempdb from sp_MSforeachdb?
Below I have a code to get info about t-log backups for each database in the server. I want to exclude tempdb from this list.
exec sp_MSforeachdb 'SELECT server_name, sysdb.name AS DatabaseName, bkup....
0
votes
1answer
11 views
How do I know which binary log file to open for continous backup?
This really has me confused, I want to have point in time recovery so I plan to take occasional full database dumps, and then between those dumps I plan to use stop-never with mysqlbinlog. But I'm ...
0
votes
1answer
25 views
How to grant xp_delete_file to non-sysadmin login?
I want to delete old backups from shared folder, which are located on separate NAS storage, using newly created SQL login. Is there any workaround to execute xp_delete_file using another account which ...
5
votes
2answers
570 views
SQL Always On COPY ONLY backups - what's the point if I cant restore the AG from these backups?
Think I already know the answer to this but I'll ask anyway.
Situation is:
SQL 2012 Always On - 2 synchronous replicas.
7 TB worth of Sharepoint DBs in 1 AG.
Before patching - I want a Full DB ...
1
vote
1answer
57 views
What is the purpose of keeping filegroup or filestream backup in MSSQL?
I'm a new DBA for SQL SERVER. Currently I'm learning about filestream on SQL server. So I tried to restore only filegroup of filestream to other database, but I get an error message:
An exception ...
0
votes
2answers
79 views
Database Doesn't Contain Current Data After Restoring Last Full Backup from Production
I restored my last full backup from production database to reporting database server, but last restored database on my reporting server doesn't contain current tables, procedures, functions etc. What ...
-3
votes
1answer
56 views
Recommend SQL database backup for db size 1TB
Currently, our NAV 2013 database has been growing. It takes about 1TB now and is running on SQL Server 2008 R2 on Windows Server 2008 R2 Enterprise Edition.
We would like to check if there any best ...
0
votes
1answer
31 views
postgresql recovery.conf file location in 11.5
I'm new to postgres. We need to take incremental backups for postgres databases as well as we must be able to perform PITR. I searched a lot on internet and tried to find out any article referencing ...
1
vote
2answers
15 views
Using MySQL binary logs to keep backups between database dumps?
I currently take a full database backup using mysqldump once a day. I'd like to make this more granular (e.g. every 15 minutes), but can't just take more full dumps due to size constraints. Can I use ...
7
votes
1answer
104 views
Why does SQL Server require a private key to encrypt a backup?
I am setting up an experiment where I only have the public key portion of a certificate on the server. The certificate was generated on another server and I did not restore the private key.
When I ...
1
vote
1answer
35 views
Why do we add NO_TRUNCATE and NORECOVERY options while taking tail log Backup?
Assume that my mdf file is deleted and I set my database into single user mode. The first thing that I do is take tail log backup. My question is do I need to add NORECOVERY option while taking tail ...
11
votes
4answers
1k views
Alternatives to Network Backup
In our environment we have some servers that are in an Always On Availability Group, and some that are standalone.
We normally backup to a network share, but we have recently observed that as the ...
0
votes
1answer
33 views
Why Postgres replication write_lag is measured in seconds
I'm running pg_receivewal locally, without compression, it stores segments on the same drive with the db files. Here's the replication statistic:
imbolc=# select * from pg_stat_replication;
-[ RECORD ...
1
vote
1answer
48 views
Incremental backup between now and backup taken one week ago
We do a full backup of our SQL Server 2012 database every night.
A new developer needs an incremental (or differential) backup of a backup we took one week ago. The reason is that for them, ...
0
votes
1answer
29 views
MongoDB restoring to existing replica set (avoid creating a new one)
I have a MongoDB cluster runnning on 3 AWS EC2 instances, 1 for primary and 2 secondary nodes. I'm trying to perform a backup and restore without having to recreate the replica set. mongodump seems a ...
1
vote
1answer
32 views
How to deal with `.partial` WAL segments generated by Postgres `pg_receivewal` command?
pg_receivewal creates a .partial file for incomplete WAL segment. My question is how to deal with this file during recovery. If I just leave it as it is, last transactions don't recover. If I rename ...
1
vote
2answers
46 views
RMAN restoring datafile out of ASM
Why is RMAN restoring the datafiles out of ASM and how to restore a backup into ASM?
Here is one output. The tablespace triscaltb was restored in /u01/app/oracle/product/12.1.0/dbhome_1/dbs/...
2
votes
2answers
45 views
Is it possible to prevent data loss with Postgres WAL archiving?
As I understand from the docs, a WAL segment is archived when the segment file reaches some size or due to archive_timeout.
So if the database crashes, all the data from the incomplete, currently ...
0
votes
1answer
47 views
Ola Hallengren Transaction Log Backups of System Databases
I am attempting to backup the transaction logs of master, model in addition to the msdb.
MSDB transaction log backs up without any issues, but the master and model do not.
Here is the script that ...
0
votes
0answers
21 views
SQL Server Windows backup restore on centos
I have installed sql server 2017 on my centos 7 machine. I need to restore my database backups from windows machine to this machine. I could successfully run filelistonly. However, for restore, I'm ...
3
votes
2answers
94 views
How to query data in backups?
I have an ASP.NET app using SQL Server 2017. There's a bug somewhere that's causing some records to be deleted, and I'm trying to recover the data and find the cause of the bug. We take daily backups, ...
1
vote
2answers
37 views
copy entire PostgreSQL cluster to another (identical) server
I'm looking to clone a PostgreSQL 10 cluster from server1 to server2, which is running the same Postgres version on identical hardware. The purpose is load-balancing and HA. Things to keep in mind:
...
0
votes
1answer
41 views
SQL Full Backup job is taking too long to complete
I am facing a strange issue with daily FULL backup. We have a total of 23 databases. We have 1.21 TB big database in this SQL server 2012 Standard Edition. We are taking daily FULL database backup for ...
0
votes
2answers
44 views
SQL Server Backup Database not .bak file format
I've been using SQL Server 2012 for as long as I can remember. When I do a backup it's always saved as .bak file format. However, there's this other server that has SQL Server 2012 and when I do a ...
5
votes
3answers
168 views
Is there a limit to how many backups can be appended to a single file?
A recent question got me looking at MS Documents and wondering.
Is there a limit to how many backups can be appended to a single file?
By default SQL Server uses NOINIT to append new backups to the ...
0
votes
2answers
53 views
Not able to delete transaction log backup file
I have a big SQL Server database (~1.5 TB) and i didn't take log backup of that database for last two weeks for some reason.
Today i found that the .ldf file of that database became huge around 1.5 TB....
1
vote
1answer
27 views
Hourly differential backups with append option
With simple recovery mode, a nightly full backup, and hourly differential backups, if the hourly differential backup is set to "append" will the differential file continue to grow day after day after ...
0
votes
0answers
21 views
How to prevent regular users to backup database, in Postgresql
How can I prevent/restrict regular users, that do have select rights granted on tables etc, to perform backup of Postgres database?
Is there a way to enable users to connect, select, update etc. ...
0
votes
1answer
38 views
Incomplete dumps using mysqldump
I am running Mysql server with master and slave replication. From past few days i found that backups on my master server are incomplete.
When i ran manually on master it's returning the below error
...
0
votes
1answer
45 views
How to check there is enough disk space before overwriting a DB with restore command
I need to automate the restore of a database each night from a backup but I want to first check if there is enough disk space. In the below Microsoft link it says the verifyonly command is able to do ...
0
votes
0answers
20 views
mysqlbackup 8.0.16 does not recognise --defaults-extra-file option
OS-RHEL 7.4
MySQL Server- 8.0.16 commercial (trial)
defaults-file=/mysql_data/config/options.cnf
defaults-extra-file=/mysql_data/config/extra_options.cnf
[root@exampledb01 logical_backup]# ls -l /...
0
votes
1answer
20 views
Converting MongoDB instance from Standalone to Replica Set and Backing Up
I want to convert my MongoDB 3.6 standalone server to a replica set so I can watch a collection using change streams, which requires an oplog. I only want to use change streams so will keep this as a ...
0
votes
1answer
35 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
55 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
57 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
7 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
49 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 ...
