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
1answer
26 views

Continuously backup/restore selected tables

I'm backing up production data locally to perform experiments and investigate production bugs. I need only a handful of tables from product DB. I'm using generic mysqldump and now facing a problem ...
1
vote
1answer
34 views

How to determine how much storage to store backups?

I was thinking about this question ( Here where I work, we have a lot of space so backups are dayli ok ), and i'm thinking about if I was hired in another company, and see that they don't have ...
5
votes
1answer
173 views

How does SQL Server calculate the initial size of a (compressed) backup?

When a backup is created, SQL Server guesses(?) the a size of the intial backup file. Later on, maybe when it appends the log the size will be re-adjusted, sometimes multiple times until the final ...
1
vote
0answers
81 views

SQL Server: Same backup copy is verified in the original server (SQL Server 2008 Standard) but not in other server (SQL Server 2008 Enterprise, …)

I have got a production server with SQL Server 2008 Standard version doing backup copies using maintenance plans. I am doing one full copy on Sundays and one differencial copy the rest of the days of ...
1
vote
1answer
22 views

Multiple database logs in backup device

I am working on tidying up our log back up Jobs (Sql 2008r2 ), which have grown into a bit of a mess! I am setting up a trn log back up job to a remote folder for each day ( in this example called ...
1
vote
1answer
38 views

Remote backup to folder path in domain

A simple question, We have just done a P2V and are re-testing the environment and moved from SQL 2005 to SQL 2008R2. I am taking this chance to redo my back up plans. I have set up a remote folder on ...
1
vote
1answer
36 views

How to restore a database, ignoring the free space within each file?

Using the following script I get all the disk space used by each file in my database: ;with radhe as ( SELECT DatabaseName = 'my Database', --DB_NAME(), a.FILEID, [FILE_SIZE_GB] = ...
5
votes
1answer
133 views

SQL Server Backup Schedule Overlap

I have a SQL SERVER DB that i want to backup via automated schedule (using GUI maintenance plan) . I have 2 choices when configuring a schedule : 1) do not bother about log backup , full backup and ...
0
votes
2answers
105 views

Tokudb HotBackup

I was trying to evaluate the latest tokudb Hotbackup for percona's tokudb engine. This install is under debian (Ubuntu 14) I was able to get all the packages installed with out error and get all the ...
0
votes
1answer
27 views

Can I take backup of those tables which are created with NOLOGGING in Oracle?

Can I take backup of those tables with data which were created with NOLOGIING option in Oracle. Is it true that backup can not be taken for these tables and I can not restore my data if I have some ...
2
votes
3answers
237 views

Backup database by copying the MDF and LDF files

I want to backup a SQL Server database by copying its files manually. Is copying the database.MDF and database.LDF files enough or should I also add more files? It might be not the proper way for ...
1
vote
1answer
33 views

Corruption in mariadb binlog

I have an installation with mariadb version 10.0.21. I need to backup the binlog file every 5 minutes to TSM, but as the binlog is being written every second, i am afraid of the file getting ...
0
votes
1answer
33 views

FLUSH LOGS command introduces a long sleep

I am using Percona mysql 5.0-92-log on Centos 6.6 final. I have logged in as a privileged user to mysql. If I issue command mysql> FLUSH LOGS; The terminal goes for a long sleep Below is the ...
1
vote
1answer
37 views

Default Backup to be Copy-Only

We have a 3rd party Payroll application which uses a SQL database on our server. On the database server we have weekly full backups, nightly differential and regular log backups. These are kept for a ...
0
votes
1answer
53 views

BACKUP Detected Corruption in the database log

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, ...
0
votes
0answers
18 views

Wordpress DB's and fixing corruption

I'm usually over in the Wordpress stack exchange but I thought this would be more pertinent in this community. Recently I took down a site I spent a few years developing it's content and closed the ...
0
votes
0answers
124 views

Could not locate a valid checkpoint record postgres

I have a database postgres in windows server and two slaves for reading. I need do Incremental Backup. What I've done: - Create Base Backup from pg_basebackup - Save WAL files Restore What ...
1
vote
1answer
21 views

Restore Structure Only

We have a database that is 3TB+ in size, and don't have enough space to restore it. However, we want to retrieve code (stored procs) from a 15 day old backup. Is is possible to restore the structure ...
0
votes
1answer
82 views

DISABLE SQLSERVER VSS backups [closed]

I have some automated backups that i want to disable. but i do not know how to do it. Apparently these are done via Volume Shadow copy Service . Can anyone tell how to get rid of these backups ?
1
vote
2answers
53 views

DB backups not secheduled

I have done backup plan to backup 1 DB . When look in the log i can see that the system has taken backup of all databases (master , reportserver ...etc) . However on the drive where data are backed ...
0
votes
1answer
149 views

How to automatically shrink a SQL Server transaction log only if it exceeds a certain limit (e.g. 20 GB)

Our database is set to FULL recovery mode and we take a database backup and a log backup every night. On several occasions we have noticed that the transaction log file is not truncated after the log ...
0
votes
1answer
28 views

Database backup with no frozen I/O

Is there a way to make automated backups of a DB without having the I/O frozen ? I am using an Amazon EC2 instance . I/O is frozen on database distribution. No user action is required. However, if ...
1
vote
0answers
47 views

Initial Full Backup Failing Immediately

This server was recently installed and configured. I was in the process of creating some maintenance plans to backup the logs and DBs on a daily basis. Regardless of my method to perform a full ...
0
votes
1answer
37 views

Referring to a network location without volume label in VBA for Access 2013

I run a database at work in Access 2013. The VBA corrupted after a day from the amount of people using it, so I attempted to split the database to solve the problem. The split worked after I ...
4
votes
2answers
43 views

Database Backups vs Server Backups

At my current job, I recently discovered that our MS SQL database servers had no backup devices set up for them. When I asked other IT members about this, the response was that the servers themselves ...
0
votes
1answer
54 views

Multiple instance of Mysql realtime backup

My current mysql backup strategy is replication. I setup one or more slaves following a master. If the master failed, I still have a clean and up to date copy of the data from one of the slaves. It ...
2
votes
1answer
43 views

Strange Backup and Alerting Issue

I received alerts from one of my database servers over the weekend that was somewhat disconcerting. There was an alert for each single database within the maintenance plan. A full backup has never ...
1
vote
1answer
161 views

How to verify that a PostgreSQL base + WAL backup has been restored correctly

Coworkers were trying to extract a PostgreSQL database copy from a backup made at a hot standby in version 9.1, but it wasn't reliable - we would run it daily, but usually it would end up with various ...
1
vote
1answer
176 views

RMAN backup of RAC database failing

Backup goes through if I don’t have any explicit connection to any instance : RUN { ALLOCATE CHANNEL ch1 TYPE DISK FORMAT '\\192.168.2.11\test\DF_CH00_%U'; ALLOCATE CHANNEL ch2 TYPE DISK FORMAT ...
0
votes
1answer
59 views

Simple or Full Recovery

I have numerous replication subscribers that have to have backups done to keep log files under control. They do get a LOT of inserts/deletes during the day. I have been using simple recovery because ...
2
votes
1answer
39 views

onsite and offsite backup question

We have an sql database of 165GB (includes filestreaming) and we do an onsite full backup every evening using veritas. We would like to also have an online backup in place just so that we don't need ...
0
votes
1answer
52 views

PostgreSQL-Backup from windows hard drive to linux

I'm in a bit of a pickle here. I managed to copy the whole postgresql installation directory to a backup drive but how would I retrieve it from Linux with the same architecture and version. Is this ...
1
vote
2answers
74 views

Partial backup restore of read-only file group on new database

Let's say, I have a database myModel2015 that contains two file groups - Primary A and Secondary Read-Only B. Then, I am creating a partial backup of the secondary file group. Now, let's create a new ...
3
votes
2answers
1k views

Archive Logs filling up Flash Recovery Area (FRA) space

I got hired to fill a position of DBA that I wasn't quite ready to fill, and while the training is getting me there, I am running close to a potential issue. My oracle 11g database's Flash Recovery ...
1
vote
1answer
72 views

Is it possible to convert .trn (transaction log) file to human readable form

I have used below SQL statement to get the transaction information done on 2015-10-26, but the information not in human readable form. ** SELECT * FROM fn_dump_dblog ...
0
votes
3answers
178 views

Is it possible to restore database only with .trn files?

How do I restore database only with .trn (transaction log backup) file? I did below two steps Microsoft SQL Server Management studio shows "Restoring". 1) RESTORE DATABASE [database_name] FROM ...
-3
votes
1answer
121 views

Generate Script Of Database in SQL Server 2008 [closed]

How to Create Script for the Database Objects in SQL server 2008 r2 and restore it in database.
2
votes
1answer
104 views

First log backup after FULL taking lots of space

In the backups I'm doing in my database, the first LOG backup I do after the FULL backup is taking too much space, even more than the full backup. For example: 4:50 AM: FULL BACKUP - .bak 7.2GB ...
1
vote
1answer
78 views

Restore a point between two full backups

I make two full backups on Oct 1 and Oct 10. I want to restore the server to a state in Oct 5. So I just do as follows: Perform a transaction log backup on the server on Oct 23. I have never backup ...
0
votes
1answer
105 views

What or Who is taking SQL Server backups [duplicate]

I have inherited a SQL Server 2008 R2 (SP3) Database. There are backups being taken daily at seemingly random times. The backups are not being saved locally on the server. I see the backup information ...
1
vote
1answer
69 views

SQL Server full backup location

I created a full backup with SQL Server 2014 Management Studio. After that I removed it and created Differential backup, everything worked with no errors. How the server knows against what ...
2
votes
0answers
339 views

mysqldump vs mysqlpump

I just heard about mysqlpump - it looks like it was released with MySQL 5.7, however MySQL 5.7 still includes mysqldump. They're both backup programs, but could anyone summarize the main differences? ...
0
votes
1answer
73 views

Why does sys.fn_hadr_backup_is_preferred_replica take so long? Is there a better way?

I am using sys.fn_hadr_backup_is_preferred_replica to query the databases on each of my Availability Group replicas to figure out if the database should be backed up on that replica - then, if the ...
0
votes
0answers
24 views

Best way to generate backups with 'INSERT ON DUPLICATE KEY UPDATE'

I have been using HeidiSQL to generate MySQL backups using 'REPLACE INTO' however have recently come across the problem this causes with foreign keys & have been told using to use 'INSERT ON ...
0
votes
1answer
86 views

Why take full backups when you can do COPY_ONLY?

With a SQL Server 2012 availability group, you can only take COPY_ONLY full backups on replica. You can make regular BACKUP LOG. As it's possible to restore logs backups after a database restoration ...
6
votes
1answer
92 views

RESTORE VERIFYONLY locks file in Azure Blob Storage

I'm using SQL Server 2012 SP2 to backup my transaction logs directly into Azure Blob Storage using the BACKUP TO URL statement. I am then attemtpting to verify my transaction log as follows: RESTORE ...
2
votes
2answers
49 views

Deleting data directly from backup file

Is it possible to update the data directly inside the backup file (*.bak) in SQL Server 2014? The scenario is that I want to automate the process of providing the "smaller" database to some ...
2
votes
2answers
58 views

How to optimize performance of backup process? Servers go down during backup

The context - So I am an intern (So I'll appreciate a more noob friendly response) and we have several websites on a server of which we do a backup daily, at midnight. We use MongoDB and there's a ...
1
vote
2answers
348 views

Script to backup all databases

I'm working on automating backups of SQL Server databases on SQL 2008 R2 Express. These backups are initiated daily by the Windows Task Scheduler, which execute a batch file, which in turns executes a ...
6
votes
1answer
1k views

Why do we use FILE = 1 in scripts for restoring a database

Recently when I came across the script for restoring a database, I got a doubt on why we have to use "FILE = 1"? Can't we restore a database without that statement!? Basically, what it is used for?