Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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
0answers
22 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....
4
votes
0answers
31 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
38 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
50 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
35 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
37 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
20 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
29 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
50 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 ...
0
votes
1answer
25 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
39 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
102 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
48 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
59 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
428 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
43 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
155 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 ...
1
vote
2answers
195 views

After a full backup, how does system know which transactions to restore from the transaction log backup?

Full backup does not truncate the transaction log file. Assuming the Following Scenario Full backup at 6AM TLog backup at 10AM Full backup at 1PM TLog backup at 6PM Crash immediately at the next ...
2
votes
1answer
28 views

Schedule database backup question

Good day. This may be a stupid question and you can give me a stupid answer if you need to. I know you can schedule a task to backup a sql database at logon, shutdown, specific time, etc. But What I ...
0
votes
1answer
21 views

Help to understand 'log space used' metric

The chart below comes from a monitoring tool. The metric shown is "log space used" for SQL Server 2016 for the last 7 days. I'm looking for help to understand what's going on here. What I do know is ...
0
votes
1answer
14 views

Running MySQL Backups to network location

We have a MySQL server with several databases for development work and we want to back up some of the DBs to a NAS device. These have been backed up previously but the backups have not worked for some ...
2
votes
1answer
27 views

Suggestions for large DB maintenance

i have one large database (more than 1,500 tables and total db size of 56GB) and i would like to ask for tips and guidance regarding the maintenance of such large database! Will the size be a problem ...
1
vote
1answer
47 views

Under what conditions could restore of a huge database get delayed, in SQL server 2016, hosted on VM?

I have system where my database gets restored every night, and off late the restore is taking a lot longer from past few days. Here is server config: ES 2637 XEON @ 3.5 Ghz Windows virtual server ...
1
vote
1answer
28 views

MYSQL database failover

Current status I have a MySQL (MariaDB 10.2) server with various databases, to which a lot of people have access to. Which means that users can create MyISAM or InnoDB tables/databases. Problem ...
0
votes
0answers
16 views

How to import one specific oracle table with all constraints

I need to drop or truncate an Oracle table and then import it from a backup file with all constrain triggers index. What's the best way to do it? What is better using cmd or toad 11.5?
0
votes
1answer
37 views

Do I need to detach a database to attach it?

I am trying to move data from one SQL Server server to another (located on another computer). I know of the detach/attach method, but I don't want to disturb the prod environment (detaching a prod ...
0
votes
0answers
8 views

Copy Postgres database from DEV to PROD on Amazon RDS using pgAdminIII

I am running pgAdminIII on Windows 10 and trying to copy my PostgreSQL database to production. I am able to Backup to a file. I am also able to connect to the PROD server on Amazon RDS and make ...
0
votes
0answers
17 views

Compare different modes of backups

Ive been searching to find any script or a method for below: Case1 : we have litespeed backups running without checksum and verify backups taking x mins for an instances with TBs of dbs Case 2: we ...
1
vote
1answer
76 views

How to do per-tenant backups for multi-tenant databases?

Are there any best practices, experiences or guidelines when it comes to do per-tenant backups/restores in a microservice multi-tenant application? In my case I have multiple Postgres servers which ...
1
vote
1answer
49 views

Error 9002 Transaction log full SUSDB

I am running a WSUS Server on Windows Server 2016. The WSUS Service stops because transition log is full. The Event viewer says: The transaction log for database 'SUSDB' is full due to 'CHECKPOINT'. ...
-4
votes
1answer
37 views

SQL Server Backup does not run

After changing the sa password of SQL server 2012, the automatic backup doesn't run any more. Please see the log history:
0
votes
1answer
63 views

Backup Plan on Always On using Maintenance Wizard doing Tlogs on Primary and Secondary

I have my set my back up preference set to primary and the secondary is not readable. Then I did the following: Setup the same maintenance plan on all replicas in the AG through the maintenance ...
1
vote
1answer
69 views

Restoring development database from production backup triggered production database to restore as well

We backed up our production database to restore our development database. When we restored our development database from the backup it triggered the production database to restore as well. The ...
0
votes
1answer
26 views

How do I use a different domain and username in a SQL Server BACKUP LOG command?

I looked here, https://docs.microsoft.com/en-us/sql/t-sql/statements/backup-transact-sql?view=sql-server-2017#security I want to backup my log to a different server. When I do this through the SSMS,...
2
votes
1answer
434 views

The backup or restore was aborted - what could it be?

use master go ALTER DATABASE Apcore SET SINGLE_USER WITH ROLLBACK IMMEDIATE RESTORE DATABASE Apcore FROM DISK=N'C:\Backups\QG-V-SQL-TS$AIFS_DEVELOPMENT_APCore_FULL_20180909_230034.bak' WITH FILE = ...
0
votes
0answers
62 views

How long to keep SQL Server Backup before backing up to separate storage

We use ola hallengran scripts for SQL Server backups. We perform full backups daily. We keep SQL Server backups 7 days and tlogs for 48 hours. We perform 4 weekly checkpoints, or snapshots, to our ...
1
vote
1answer
44 views

How to export user with tables and tablespace oracle

I'm a newbie to Oracle World. I have to export, from computer A, tables and their data, to computer B. So, my question is: is there a way to export user, tablespace, tables and their data with one ...
0
votes
1answer
38 views

SQL server tool - backup & restore to different servers different locations

I need to back up 100s of databases and restore them to 20 different servers, and different data file locations for destination servers. Are there any tool that allows me to copy 1 database/all ...
1
vote
0answers
22 views

Oracle Database Recovery [closed]

I recently develop an app using Oracle Application Express on a Windows OS, after uploading lots of data. Unfortunately for me the OS field before I could make any backup but, I salvage the data files ...
0
votes
1answer
32 views

TSQL retrieve backup date from database after restore

Usecase: MSSQL Database is hosted in the cloud, I download the database thrue FTP and restore it on-premise automatically for reporting. Now I want to retrieve the date/time when the backup was made, ...
0
votes
0answers
15 views

Setting up Log Shipping WIth Data domain DDBoost

Is there is any way to set up Log Shipping with Data Domain. My thought process was to have data domain do the full back up and skip the Transaction Logs. I will have a separate job that does the T ...
0
votes
1answer
19 views

Mongo doesn't restore user password

I have following scenario: Dump Mongo database (cmd mongodump) Change password from one of admin users Restore Mongo database (cmd mongorestore) EDIT: I use following command for db dump: ...
0
votes
1answer
44 views

Can not backup multiple (not all) databases Ola Hallengren [closed]

This error is quite easy to replicate. So before I send a bug to Ola, I'd like to check if maybe I'm doing it wrong. Version is 2018-06-27 20:44:12 I created 3 databases. DB1, DB2 and DB3. I'd like ...
0
votes
0answers
11 views

SQL Server Backup Service Master Key - Multiple Passwords

Ignoring the reasons behind the request, if I backup the Service Master Key twice, using a different password each time, is either a valid backup for restoration purposes (assuming the correct ...
1
vote
1answer
52 views

Does SQL Server allow moving backwards with standby file?

I have a database in standby mode. -- STEP 1 -- Restore path F1 > T7 RESTORE DATABASE [TestRestore] FROM DISK = N'C:\Temp\F1.BAK' WITH FILE = 1, NORECOVERY, NOUNLOAD, REPLACE, STATS = 5 GO -- ...
1
vote
2answers
83 views

How to get to know that db files are inaccessible?

Let me explain my case. I have a mount with database files on my local PC. I attach the database (from this mount). And then close this mount (in other word i attach db and then delete db files). So ...
1
vote
0answers
14 views

How to migrate InnoDB tables with 10s of partitions from the data directory onto another drive on the same server

I am trying to move some of the older partitions from larger tables located at the main data directory to another drive/mount point on the same server. I want all the partitions/tables to be ...
0
votes
0answers
18 views

Process to Archive off DB Backups in Azure Blob Storage

I'm looking for ideas on how to start on Archiving some of our SQL Server Database Backups that are on the Azure Blob Storage. It's getting to an unmanageable state. I'd like to drive this using ...
3
votes
2answers
298 views

Understanding CleanupTime in Ola Hallengren's SQL Server scripts in relation to FULL backups and LOG backups

I am having trouble understanding what exactly to expect from the CleanupTime option in the Ola Hallengren Server Maintenance Solution. I'm finding some related questions, and elaborate answers, but ...
0
votes
2answers
66 views

SQL Server 2016 Availability Group on DPM 2016

I'm trying to backup my availability group in SQL Server 2016 using DPM 2016, but after I add the cluster in DPM, availability group show nothing to back up. I've set every secondary node to be ...