Making copies of data which may be restored after a data loss event or to recover data from some earlier point in time.

learn more… | top users | synonyms (1)

0
votes
0answers
20 views

How to backup huge Mysql db containing both InnoDB & MyISAM tables in Aws RDS?

I am running a Mysql RDS with 150GB+ data. The DB size is growing very fast(But normal considering the application's nature) Till now we were having only InnoDB storage engine, so we were using the ...
0
votes
1answer
73 views

SQL Server restore full backup + partial differential backups

I created a full backup of my database using SQL Server Management Studio wizard, and then I perform differential partial backup each day via cmd to the same file. SQL Server version is 2008 R2. ...
1
vote
1answer
49 views

Need for backing up MySQL databases information_schema, performance_schema, mysql and phpmyadmin?

I know it's not necessary to backup the information_schema database, but what about the following databases (besides the user-defined databases)? performance_schema mysql phpmyadmin (So, in case ...
0
votes
1answer
49 views

Saving SQL Server DMV's for later use [closed]

Is it possible to save DMV's in SQL server database backup, which can be restored on different server, I mean with master db details( views and all)? If not, what's the best way to maintain 2 ...
4
votes
1answer
203 views

Large Transaction Backup

On my SQL database I run a full backup at 6am and transactional backups every 15 minutes on week days starting at 8am. Every Monday the first transactional backup is 7 Gb. I want to know why, my ...
4
votes
2answers
78 views

Have full SQL Server restore but losing 1 day of data

I have SQL 2008 R2 64bit and it is backed up with ASIGRA SQL backup. The issue I have is that we had corruption on the server and the DB got corrupted yet the LDF file is in tact and does have all the ...
1
vote
2answers
32 views

Backup Error (.bak)

I need to backup the database in SQL Server 2014. When I am trying to do so, I am facing this problem which is not saving backup as a (.bak) extension. And when I try to select (Files and ...
2
votes
2answers
39 views

what is the most simple and easiest way to backup and restore on oracle 11g?

Im new on oracle 11g i come from SQL Server administration and the process to back up and restore its very easy and intuitive. I was searching how to make backup and restore on oracle 11g in many ...
0
votes
1answer
48 views

Restore user db from UNC

I need to create a job that restores all user databases from UNC to my SQL Server. All the backups, for 3 days, are located in the same folder and I need to restore the last modified backup. What is ...
1
vote
1answer
51 views

How to confirm if the backups are going to tape in SQL Server 2005 and 2008 R2

We have many of our SQL Servers where we take the backup locally on the server as well as over the network to other server in case of disaster. Also, we have a process set that server support team ...
1
vote
1answer
26 views

pg_dump does not honor -n

I'm using pg_dump (9.2 database), to extract one schema and load this into another database (9.4). well, here's the command: pg_dump -f file.sql -F plain --inserts -n schema database Ok. My ...
2
votes
1answer
159 views

Can I backup (Full) the Log-Shipping Secondary Database?

I have a Highly pressured Production Environment with Database name DB1. And I want to run a weekly DBCC CHECKDB process on one of the databases there. (You can understand,I can't do it on my ...
0
votes
1answer
31 views

Transfer data to New Laptop [closed]

I am completely new to PostgreSQL My data is in the directory c:\postgres.......data and the database name is GXPGRAN. I need to copy this to a new laptop. Can somebody please give me all the steps ...
2
votes
1answer
82 views

BACKUP AND RESTORE FileGroup (PRIMARY) - WHY after restore I still see Other FileGroups?

/********************************** CREATE DATABASE PiecemealDB *************************************/ use [master] go if exists (select * from sys.databases where database_id = DB_ID('PiecemealDB')) ...
1
vote
0answers
35 views

Make a backup file or save a DB in PostgreSQL

I have deployed for my data base in production a new groups of users; An admin user with full access to the DB ; A read only user ; A super admin user to manage all the DBs ; The matter is for ...
2
votes
1answer
198 views

RMAN backup is stuck/taking a long time

I am trying to run an RMAN backup that is either hung or is taking a very long time. Some background: I inherited this database, and I am unfamiliar with Oracle, as I am an SQL Server guy, so please ...
0
votes
1answer
82 views

How to know that , Is it Maintenance Cleanup Task is working properly from maintenance Plan or not through T-SQL?

I would like to say that i had configured "Automatic DB Backup" as well as "Automatic DB Cleanup Task" through "Maintenance Plan" in MS SQL Server 2012 on my Production Database. And that is working ...
3
votes
1answer
56 views

Backup of VM having SQL Server in it

I have SQL Server running on a virtual machine (VM). Weekly VM backup is done. My question is when we backup the VM, does it locks down the SQL Server or the databases residing in that SQL Server? I ...
2
votes
1answer
33 views

How to generate an error when backing up to an existing file

I'm using SQL Server's BACKUP command and I want the operation to generate an error if I attempt to write to an existing backup file. By default, SQL Server seems to append to an existing file. ...
1
vote
2answers
34 views

How to check if restored database is the same as original

Is there a way to check if restored backup of Oracle database is the same as the original database? Is there a simple way to check it if I have the original database?
1
vote
2answers
100 views

Backup to local and MIRROR TO Azure Files returns ERROR

I have an Azure VM with SQL Server 2014, with a local drive (X:) for storing backups. Using Ola Hallengren's scripts. I added an Azure Files share and tried to do a mirror backup, but I get the ...
2
votes
1answer
106 views

Use transaction logs multiple times

Every night a full backup is made of all the user databases. Every 15 minutes, transaction logs are created. Today i succesfully restored a database with the use of transaction logs. I set the time ...
0
votes
0answers
43 views

Query to List Backup Files on Azure Blob Storage

In SQL Server 2014, it is possible to restore a database from a backup stored on a URL: SQL Server Backup and Restore With Windows Azure Blob Storage RESTORE DATABASE [some_database] FROM URL = ...
1
vote
2answers
61 views

postgreSQL hot_standby pg_dump on slave

I have master-slave (hot_standby) pgsql configuration and I want to make backups from one of my slaves. I don't want PITR, just good old database dump. I switched to postgres from MySQL. With MySQL ...
1
vote
2answers
72 views

Switch from full to simple recovery

This is a theoretical question to help my understanding. What is the process to switch from full to simple recovery model in sql server? Is the process as follows: Take a trans log backup before ...
0
votes
1answer
29 views

Differential Backup since a date

Hi is it possible to do a differential backup in ssms 2014, so that it gets all changes since a specified date?
1
vote
1answer
23 views

Why do you have to execute a full backup after a new database for trans backup jobs to run [on hold]

Playing around on my local sql server at home after an issue occurred at work. We have full backup jobs scheduled on Mondays only. I created a DB on Tuesday (when doffs and trans are scheduled). ...
0
votes
1answer
41 views

SQL Server 2008 R2: From a SQL Server Log file, how do I find out what is causing an event

Problem: The attached image is a screen shot of the SQL Server log showing an event that happens every Tuesday at around 1:20 AM. This event is causing the transaction log backup chain to break ...
0
votes
0answers
96 views

Database in Suspect mode

One of my user database is showing suspect mode. To repair I have executed these scripts: Step 1: EXEC sp_resetstatus axlive’; Step 2: ALTER DATABASE axlive SET EMERGENCY Step 3: DBCC checkdb ...
0
votes
1answer
36 views

Ubuntu broken need to recover mysql db

With a recent Ubuntu upgrade it has broken my system. I now only have access to the filesystem through a live CD. I had a MySQL database on the system with many objects and views I would hate to lose. ...
0
votes
1answer
26 views

backup a specific set of tables to be moved to a remote system [duplicate]

I need to generate either backups or data dumps for about 30 tables. I want to generate a file of some sort that contains the data for these tables and transfer them to a different system. Each ...
1
vote
1answer
30 views

Recover deleted data SQL Server

On 03/19 one user had deleted the data from 3 tables from one of the databases that we have. Now we have the full backup of that database each day. What we want to do is to restore the deleted data ...
1
vote
1answer
101 views

Backup Specific days monthly SQL Server

How to backup only specific days each month on SQL Server (I use both SQL Server 2005 and 2008) using a maintenance plan or Agent job. I mean by that to backup my databases from 28th of each month to ...
0
votes
1answer
101 views

How we resolve Mysql Enterprise online backup error with “CORRUPT LOG RECORD FOUND” log error

I have configured my production MySQL database with MySQL Enterprise "online Backup" option. The configuration was went through successfully. When the assigned scheduler is try to take backup then i ...
2
votes
3answers
99 views

How can I get SQL Server restore start and end time information?

SQL Server error log reports only the end of the restore (ah doc restore) How can I get the start time? Is it stored somewhere?
0
votes
0answers
271 views

How to restore mysql database in XAMPP using backup of mysql folder?

I have a backup of the entire xampp/mysql folder. How can I use it to recover my old db on a fresh installation of XAMPP? Simply copying the old xampp/mysql folder to new xampp leads to mysql errors ...
0
votes
1answer
26 views

How to list files in oracle backupset

I've backupset created with RMAN, and I want to see what this set contains. How to do that?
3
votes
1answer
79 views

SQL Server Differential Backup Bloat

I perform daily full backups of all databases. Differential backups are performed every hour. The issue I am having is that around the same time each morning, a few hours after the full backup, the ...
0
votes
0answers
23 views

Does MySQL Backup Restore affect Master-Master Replication

Hello I got some problems with a MySQL shemas and it seems that the schemas got deleted for an unknown reason. I try to find in the binlog for more information of this but I didn't find the way to see ...
0
votes
1answer
48 views

Scheduled Database Backup job fails due to lack of disk space

Two of my scheduled SQL Server backups failed over the weekend because of a lack of space. The C: drive has 25.3 GB of free space out of 400 GB. The primary space taker is SQL. 149.9 GB C:\Program ...
0
votes
0answers
32 views

Restore from mysqlbackup not showing tables

I have searched but can't find an answer to this question. I tried following the directions of creating a new slave from MySQL using mysqlbackup. The backup seemed to go fine, and I had a fresh ...
1
vote
1answer
88 views

Dump All Databases in MySQL - Fails on mysql and performance_schema

I have had two attempts at dumping all databases but both have failed, one with the mysql database and then with the performance_schema database. The precised errors are:- 11:01:01 Dumping mysql - ...
0
votes
0answers
16 views

2 database sharing 1 shared data folder

I'm planning to install a database (same configuration) on two separate machines, PC1 and PC2. PC1 is the main database while PC2 is the backup.. Is it possible that they can have the same datadir in ...
0
votes
0answers
54 views

Backup File Size Almost 50% of Database File Size with TDE Enabled

I'm really hoping someone can help shed some light on this for me. I receive a full backup of a very large database once per week from a vendor. It contains transactional data which we then load into ...
0
votes
3answers
62 views

Oracle RMAN Back-up files in red hat can be read in windows?

We have performed a cold back-up of a database using Oracle RMAN. The back-up ran on a Red Hat Server and then the files were copied to a mounted external hard-drive. Can this back-up files then be ...
0
votes
1answer
186 views

How to implement Ola Hallengren backup plan on the server for some databases nightly full backups and for other weekly full backup only

I recently implemented Ola Hallengren Maintenance solution on all of my production servers(SQL server 2005,2008,2008R2 and 2012). It works great. My problem is how to implement Ola Hallengren backup ...
4
votes
1answer
182 views

Is there a way to list the “last backup” file of a Database?

I'm trying to do something really simple, but with one problem: declare @cmd varchar(1000) set @cmd='restore verifyonly from disk =''\\server\backup_folder\''?''' exec sp_msforeachdb @cmd ...
-3
votes
1answer
188 views

SQL Server 2012 Express Database Backup Script [closed]

Just a quick one. I want to do a full weekly backup of my SQL Server 2012 Express database. I have created a SQL script and batch file to automatically do a full backup of my database each week and ...
3
votes
1answer
142 views

I can backup my SQL Server 2008 R2 but can't restore from the very same folder

I ran a backup into a folder. The Network Service has full control access to this folder. The backup process didn't work until I granted that account full control. I try to restore that same file but ...
4
votes
1answer
179 views

Postgres pg_basebackup reports directory exists but is not empty

I have postgreSQL 9.4.1 installed on a Win 2012 Server. I am looking to setup replication between this and another server of the same spec. So I am following guidance on preparing the master ...