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
1
vote
1answer
24 views

Can you Identify the sql server name from sql backup file(.bak)?

I have a backup file from an SQL 2016 server and I need to identify which SQL server the file was created on. Is there a way to identify the original SQL server where the file originated at? Thank ...
0
votes
1answer
59 views

SQL Server can't see already mapped network drives

I'm trying to backup databases through SSMS and cannot see any already-mapped network drives. The SQL Server service account is what I'm using to log in, and it has permissions to the network share, ...
0
votes
0answers
12 views

how to restore wal file that is in tar format in postgresql

I am trying to use incremental backup provided by postgres. It is working if I copy the WAL files as it is in another folder and then recover. But if I make .tar.gz of WAL file then try to recover db ...
5
votes
2answers
344 views

SQL server backup message

Could you please give little clarification about SQL server backup message For example : BACKUP DATABASE successfully processed 19696388 pages in 1945.648 seconds (79.088 MB/sec). For example ...
0
votes
0answers
42 views

How do I stop Amazon Web Service's RDS from locking out connections during backups?

I've been using RDS for years, and this only became an issue a few months ago. I was pulling my hair out trying to find the source of the issue... only to figure out it's suddenly RDS. I've made no ...
5
votes
4answers
175 views

What is the best SQL server backup strategy for large DB with few tables and lots of immutable data?

We have a large DB (500GB and expanding). 95%+ of the data is stored in 3 tables (one table has 2bn+ rows). The data is largely immutable - i.e. once it's added it's only then read afterwards. We can'...
6
votes
3answers
1k views

Is it possible to take a database offline when doing a backup using an SQL job?

I have the scenario where I have to generate a backup of the database (SQL Server 2008) and restore into the new server (SQL Server 2016). While taking backup data should not be changed in any case. ...
0
votes
1answer
94 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
106 views

Postgres backup PITR strategies [closed]

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
41 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
127 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
72 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
39 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
37 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
84 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
83 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
14 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
74 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
45 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
81 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
13 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
34 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
588 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
66 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
83 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
65 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
113 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
20 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
111 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
82 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
50 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
52 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
53 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
95 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
78 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
76 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
75 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
29 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
99 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
51 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
56 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
231 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 ...
7
votes
3answers
247 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
58 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
30 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
22 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. ...
-1
votes
1answer
141 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
53 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 ...