For questions about database backups.

learn more… | top users | synonyms

0
votes
1answer
29 views

Backup a huge database 200gb+

i have a mysql database where i need to take a backup of the log database. the problem is the log database i over 200gb and contains over 280 millions of rows, i need right now to remove a kind of ...
1
vote
2answers
34 views

Restore a newer filegroup backup

So this is my set up. In our data warehouse we have mostly tables that are filled with data from a ETL-process. We do not take backup of these tables since we have an option to do a full reset using ...
0
votes
0answers
14 views

MongoDB Backup & purge [duplicate]

I'm exploring solutions for a basic dbadmin need : periodically backing up and purging data in MongoDB. Basically, I need a logrotate for mongodb. I have a backend program filling a collection. I ...
0
votes
0answers
6 views

MonetDB auto-backup mechanic problem

I'm trying to set up mechanism that will automatically create database backup. The idea is to create a script that will be executed by crontab. Seems easy but I'm struggling with the following ...
0
votes
1answer
25 views

How often to backup database and what are the favoroble practices to do so [closed]

Curious to know on how often you guys back up SaaS? I have determine that i need backups to be done every hour for an application I have, based on how often data is updated an amount of users. I have ...
-1
votes
0answers
16 views

Update local DB to online DB once a Day [closed]

I'm really facing this problem. I'm having one project with lot of local client and large Database. Here Net connection is very dead slow. So I want upload my latest updated Data to Online server. ...
0
votes
1answer
32 views

Having trouble designing my preferred backup scheme

First some background: I have two Windows servers running MS-SQL-2014 setup in an availability group (synchronous auto-failover, preferred backup on secondary). They host many databases. Right now ...
0
votes
0answers
8 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 ...
1
vote
1answer
21 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
36 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 ...
1
vote
2answers
26 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
35 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 ...
1
vote
1answer
23 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
87 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
30 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
63 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
33 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
128 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
51 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 ...
0
votes
2answers
21 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
61 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 ...
1
vote
2answers
43 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
1answer
15 views

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

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
40 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
72 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
22 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. ...
1
vote
1answer
82 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
67 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 ...
3
votes
1answer
63 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
1answer
38 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
14 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
42 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
44 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 ...
-3
votes
1answer
85 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 ...
4
votes
1answer
119 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 ...
7
votes
1answer
112 views

Can SQL Server be configured to backup to a network share through a separate NIC?

We're in the process having our SQL Server instances backup to a network share, but our network admins want to try and divert the bandwidth from the backups through a different network segment. I was ...
0
votes
0answers
19 views

Restore databases from prod to test server with data over say X days in SQL Server 2005

We've got a list from app owners to restore say 20 databases from a total of 100 available production server databases onto a test server on weekly basis. Moreover, they require it in a way that ...
0
votes
1answer
34 views

Maintenance plan to backup differentials hourly each to a new file name in SQL Server 2012

In addition to a nightly full backup, I'd like to set up an hourly differential backup maintenance plan in SQL Server 2012, where each differential backup file should receive a different name. It ...
0
votes
0answers
41 views

PostgreSQL 9.3.5 database restore error : plpgsql already exists

I have a .net program to restore a PostgreSQL database backup. What it is doing is 1) Delete the existing database. 2) Create it again. 3) Initialize some variables/properties. 4) Restore the ...
-1
votes
1answer
35 views

SQL Server database backup file is successfully created in a path but no such file path is available in my local machine

When I tried to take backup of SQL Server database, it was successfully created in C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Backup\ but no such path is available on my local ...
0
votes
0answers
83 views

Where is the SQLS database backup virtual device string stored in the system tables?

In my SQLS Server 2005 log, when backups occur, I see something like: Database backed up. Database: blahblah, creation date(time): 2011/08/11(15:49:19), pages dumped: 1, first LSN: 142:489:1, ...
3
votes
1answer
61 views

Full to Simple recovery mode during massive data update?

I`ve got a 50 Gb database, in which a table takes up 43 GB, and it's full of bad data(over 90%), and i plan to clean it. Database is in Full recovery mode. My plan is: 0 - take a backup for safety ...
0
votes
1answer
46 views

How to delete the old backup differencial files?

I'm (trying) managing a large number of sql server instances among a number of machinces running SQL Server 2005 and 2008. Almost all the DB are in Simple Recovery Model. I'm doing full backups every ...
0
votes
1answer
193 views

Best practice for archiving old data? [closed]

We are migrating 3 slightly different SQL databases into one (SQL Server 2008R2). We want to keep old databases "alive" for some period of time but once we've gone live we don’t want staff ...
1
vote
1answer
64 views

Backup a remote database, from my machine, to another server (SQL Server 2008)

I'm trying to backup a database, of a remote server, from my machine, to another server. SERVER1 >>> BACKUPSERVER \ / \ / \ / ...
1
vote
1answer
46 views

SQL server compress backup for lower version databases

Recently our development team migrated couple of sql server 2000 Databases onto SQL2K8R2. Now we creating the backup strategy, and just had a doubt, that: 1) Compatibility level of those DB's still ...
3
votes
0answers
65 views

Database corrupt after restore and upgrade on another instance

Just wondering, if someone faced the same issue. We have got a SQL Server 2008 R2 (10.50.2789) and SQL Server 2014 (12.0.2000) and there is a process of backup on MSSQL Server 2008 R2 and restore on ...
0
votes
0answers
20 views

pg_dump in 1G VPS crashes

I'm trying to run pg_dump on a relatively small database (2G), but pg_dump keeps crashing with an out of memory error. du -h --max-depth=0 9.4 1.9G 9.4 The command: pg_dump -Fp -h "$HOSTNAME" ...
2
votes
2answers
93 views

Backup compression in SQL server 2008R2 and above

Recently we got a new server to take care of and found that there are two data drive: S: 1 TB where resides 10 databases(mdfs and ldf's, though they should be on different drives but that's how we ...
1
vote
0answers
120 views

Backup and FTP SQL Server databases

We plan to backup our SQL Server 2012 databases every night, FTP the backup files to our test servers and restore them. Then deploy the latest schemas to those databases. The reason for this is so we ...