backup's questions - Chinese 1answer

1.766 backup questions.

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 ...

I understand that both NO TRUNCATE and COPY ONLY options don't truncate the transaction log or affect the chain of backups. So what is the difference or use case for these?

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

Is there a way to run a backup of a mysql database using sql? We have scripts which run updates against our databases. They only have mysql user credentials, not system login credentials. Is there ...

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 ...

I have tried my hand at building a shell script to backup our wordpress database using tar balls and chron jobs on a Debian environment. The problem I am facing now is that our wp database after ...

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 ...

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 ...

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 ...

While I try to take incremental backup level 0 by using the command RMAN> backup incremental level 0 database plus archivelog; , encountered this error. RMAN-00571: ==============================...

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 ...

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 ...

I have a database and want to move the .mdf and .ldf files to another location. But I do not want to stop the MSSQLSERVER service, and I do not want to export to another server. How can I do this?

I want to change dbid of oracle 11g database. Current dbid = 2241883xxx And want to set dbid = 1380515xxx

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 ...

MongoDB version is 2.4.12 Production Server has 3 shards and each shard have another 2 replica sets. Config server & router also runs on these servers. Backup procedure : 1. Shutdown one of ...

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?

I have a small shared windows server on which i'have installed MySQL 5.1 engine for hosting my user's mysql databases. I backup the complete MySQL databases each day by running this script as batch ...

How I can configure AutoMySQLBackup to backup some selected tables ones per week while the other tables will be backed up every day? Thanks. P.S. My google search ninja skills is not working. :)

I suddenly start to get the message while performing backup, I know i have taken backup of the certificate and stored it in my password manager which I still have access to. My question is that do we ...

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 ...

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 ...

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 ...

I recently made a rather stupid mistake and corrupt my Ubuntu installation. To resolve it, I booted with a live cd and copied the database files over. However, now I have copied the folders from the ...

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 ...

I took a backups of a few db's on server A (2008R2), Then restored it to server B (2012). One database had TDE enable, so I disabled it, took a back up then proceeded to server B. The other database, ...

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'. ...

When taking backups from databases, is it "good practice" to use logical backup device for backup location? What is the benefit of using backup devices?

I would like to create a backup of different MyISAM tables on a server using mysqlhotcopy. These tables are about 6GB in size. I would like to know, does mysqlhotcopy block users from SELECTing (...

I was trying to take backup using oplog based on ts using below code import pymongo import traceback from pymongo.cursor import CursorType c = pymongo.MongoClient('mongodb://localhost:...

I do have a DB on MySQL Galera 5.6.34 with a table that contains an index on ID,date. The table is fully functional and I have used repair and check to verify the table. However, upon backup/restore ...

I'm seeing this error in mysqlerror.log at various times during the day, but I also noticed I got a bunch of these errors when I try to execute my backup. Now I'm not using mysqldump because it kept ...

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

mysqldump Error 2013

4 answers, 24.405 views mysql backup mysqldump
I have a database installed, that I would like to backup in mysql. The problem is mysqldump fails on exporting the 'maia_mail' table # mysqldump -u root -p maia > maia.sql mysqldump: Error 2013:...

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 ...

I have a fairly large (~240GB) Mongo database that I need to transfer across a sluggish network and onto a new server. Traditionally for these situations, I've found that a mongodump followed by a ...

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 ...

Related tags

Hot questions

Language

Popular Tags