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)

2
votes
1answer
378 views

SQL Backup issues / Operating system error 995

Last night backups of some databases failed. Backups are being performed using CommVault. Below is error message in SQL Server logs 01/05/2016 ...
-1
votes
2answers
66 views

Database BackupSize has Changed after migration from SQL Server 2012 Exterprise to SQL Server 2012 Express [closed]

I would like to say that after migration of MS SQL server 2012 Enterprise to MS SQL Server 2012 Express. I have seen there is some subtle diffence in DB backupsize as well as in "LSN" of all ...
8
votes
2answers
193 views

How many backup devices is recommended to improve backup performance?

In order to improve performance of our SQL Server backups we backup to multiple backup files. On most blog posts about this topic they say to use multiple backup files but, is there a point where ...
1
vote
0answers
18 views

How to merge MySQL backup files (*.sql) [duplicate]

We have several MySQL backup files of a database in *.SQL format and we want to restore the database by using these files. However, as the sql files contains "DROP TABLE" definitions, running one ...
1
vote
0answers
18 views

Automatic incremental backup of MySql on windows

I have three Mysql Servers, Server-1, Server-2 and Server-3 all running on Windows. I have to configure Master-Master replication on Server-2 and Server-3. But Server-2 has to be a mirror of ...
4
votes
1answer
419 views

Oracle crashing on CentOS

Here is alert_XE.log: kkjcre1p: unable to spawn jobq slave process Errors in file /u01/app/oracle/diag/rdbms/xe/XE/trace/XE_cjq0_23146.trc: Process J000 died, see its trace file kkjcre1p: unable to ...
-2
votes
1answer
63 views

Backup file from SQL Server 2012 to 2008 [duplicate]

I have a backup file of SQL Server version 2012 but I want to restore that backup on SQL Server 2008. Question: Is this possible ?
4
votes
1answer
67 views

How to extract the structure out of DB2 (Back up Structure)?

Is there a way in db2 to take a backup of the database structure (Metadata) without actual data? My purpose is to pull structure (tables, views, indexes, triggers, procedures and functions) from an ...
15
votes
3answers
889 views

Database disaster prevention [closed]

My database is larger than 250GB. I make scheduled backups with a third party Tool. Are schedule database backups the best way to protect SQL Server database from corruption? Or can you recommend ...
10
votes
4answers
526 views

Using third party tools to backup

Is there any advantages to use Third Party Tools to make Backups ? I'm not referring one in particular but I want to know if someone using them to DB greater than 200 GB. Servers are mostly MSSQL ...
4
votes
3answers
364 views

How to correctly discard old backups?

I have an Execute SQL Task in my SSIS control flow that's backing up a number of databases before it proceeds to run the overnight ETL: EXECUTE master.dbo.xp_create_subdir N'G:\Backups\DQ' GO EXECUTE ...
6
votes
2answers
101 views

SQL Server Backup transaction error

Hi I am attempting to backup the transaction log file to setup mirroring in SQL Server I execute BACKUP LOG CUSTOMER TO DISK ='K:\JonDB\CUSTOMER.trn' WITH INIT GO And I receive Processed 6587361 ...
9
votes
3answers
332 views

What is the use of restore headeronly when performing a backup?

When I monitor my backups with the following query: SELECT command, percent_complete, 'elapsed' = total_elapsed_time / 60000.0, 'remaining' = estimated_completion_time / ...
11
votes
2answers
57 views

Why do my Batch Requests increase when doing a Differential Backup

I have started doing some long-term tracking of various activities on our 2012 SQL Server and I have noticed an increase in Batch Requests during our incremental backups. To give an idea, normal ...
2
votes
1answer
85 views

SQL Server Database Migration - Backup/Restore while Original DB still in Production

I have a very large DB in full recovery mode. My SQL Server is 2008 R2. The thing is that I need to migrate to a new server while having the original DB still in production. Both backup and restore ...
0
votes
2answers
75 views

Phantom SQL Server database backups. How can I find the cause? [duplicate]

I've noticed from the event log, that something is backing up SQL Server databases, separately to our maintenance plan backups. We can see something running SQL backups at 03:00. Our intended backups ...
0
votes
0answers
18 views

How to align restore strategy with backup history cleanup? [duplicate]

I was curious about how that particular problem is tackled. 1) Full backups performed on saturdays. 2) Differentials every other day. 3) Tlog backups every 15 minutes. When trying to restore a ...
0
votes
0answers
29 views

Is it possiable to force WiredTiger use multiple files to avoid large Incremental backups?

MongoDB's original storage engine creates sequential files, so the old data is located in old files, in that case incremental backups are done with the new file for each database, in wiredTiger the ...
0
votes
1answer
64 views

ODBC connection fail when running AD account for SQL Server services

I am following up a question from Remote backup to folder path in domain I asked earlier. I could not get my proxy SQL Server Agent user to work to back up to a remote location and have given up for ...
1
vote
1answer
47 views

Jetbrains 0xDBE : How can I load a SQL Server .bak file?

I'm trying this new Jetbrains IDE and I can't figure out how to load a SQL Server 2008 R2 .bak file. Maybe I'm looking in the wrong menus. Is it possible?
0
votes
1answer
27 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
197 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
85 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
24 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
42 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
37 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
145 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
111 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
264 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
36 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
34 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
56 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
142 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
22 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
93 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
170 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
29 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
49 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
41 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
64 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 ...
2
votes
1answer
192 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
210 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
60 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 ...