The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
1answer
17 views

Backup/restore using OPENDATASOURCE OR OPENROWSET

Has anyone ever successfully taken a backup or restore to another server using OPENDATASOURCE/OPENROWSET? I am not able to use linked servers so I am exploring this idea.
1
vote
1answer
40 views

Restoring a database, changing recovery model

I regularly make a backup of my production database, then restore the same onto a test database, so developers can always have recent data for testing. The production database uses full recovery ...
1
vote
1answer
41 views

Maintenance plan backup and reload the same database

I want in my maintenance plan every night to copy the production database to a backup, and reload the newly-created backup into a test database. By reading here: Restore database - maintenance plan ...
2
votes
0answers
11 views

Sql Server Backup to URL (Azure) ERROR

I'm trying to take advantage of the new backup to url function in SQL Server. I have created a valid cert and tried a simple backup, but I get the same error every time no matter what I try. I have ...
-2
votes
0answers
27 views

live database and files backup [duplicate]

I am still new to databases but I was reading that if you needed to store file (images,pdfs,...) in a database it's recommended that you put them in their own directory and only put the files paths ...
0
votes
2answers
61 views

SQL Server Backup Proposal

Our current system setup sees each server backed up by 3rd party software(Veeam). The backup for our Database server occurs once each night. Alongside this, there is another 3rd party tool that ...
0
votes
1answer
23 views

How to confirm that chunk transfer is completed on a DB

I have one case where i create db for Daily data. I have some collections in this db which are sharded. My requirement is as follows: Create every day DB If There is a DB which is more than 7 days old ...
2
votes
1answer
69 views

Database backup taking longer than usual to a networkshare

The SQL server does backups with this command to a network share \BackupServer\weekeklybackups" BACKUP DATABASE DBNAME TO DISK = '\\BackupServer\weekeklybackups\DBNAME.BAK' There is a 1 gig network ...
0
votes
0answers
19 views

difference between pg_dump command's --column-insert and --attribute-insert

Background: I'm trying to create a dump file that only contains the data in my database. I would like it to create the data with the INSERT command. In reading the manual, ...
0
votes
1answer
22 views

How can I perform this database backup/sanitization task?

I have a 3-node MariaDB/Galera cluster. I need to do two things: Back up the database regularly (multiple gigs in size) for a normal, in-case-everything-crashes-I-can-restore-from-this backup. Have ...
1
vote
1answer
75 views

SQL Server DIFFERENTIAL BACKUP question?

Simple question At what point is a differential backup considered transactionally consistent? Is it the creation date of the DIFF, or the time at which it completes? That is if I restore it what ...
1
vote
1answer
47 views

Options to include with mysqldump when taking backup of hybrid databases

I'm planning on taking backups of all MySQL databases on a remote production server. The combined database size is around 2 GB. Most of the tables are InnoDB ~1.8 GB and the rest are MyISAM. Now I've ...
1
vote
1answer
34 views

database not restoring from dump file

I'm running the following command to create a dump of all database on my production server: prodserver:/# pg_dumpall -U postgres -h 1.1.1.1 > prod.sql on my development box, I also take a ...
0
votes
1answer
32 views

how to speed up cpu limited mysql database backup

I have a database that has a structure that unfortunately requires having a lot of tables (10k+). It's not possible to change the structure now. The database itself is not very large (<1GB), but ...
0
votes
0answers
52 views

Error while taking backup in Postgresql

While taking a backup from my PostgrSQL database, it is showing this: pg_dump: Dumping the contents of table "gtab17" failed: PQgetResult() failed. pg_dump: Error message from server: ERROR: invalid ...
0
votes
0answers
63 views

Archive log backup error and backup completed with errors

My prod DB backup completed with errors stating the below error. RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ...
0
votes
1answer
85 views

Consolidated realtime mysql backup with master/slave setup or binlog

I have 20+ mysql servers and their have low write requirements. So, I want to see if any way I can replicate the data/binlog from these servers to a single slave so realtime backup purpose. If I ...
3
votes
1answer
55 views

Impact of Log backups restore process after file\file group restore on a database

When we restore file\file group(backup1) backup on a database is it necessary to restore all log backups that were taken after backup1 to get database in consistent state?? and also what will be the ...
-1
votes
1answer
600 views

Sql Server Backup Job failed

I have a sql agent job setup for taking full backup every night. Last night the job failed with the following error message. Sql Server Error Log Message BackupIoRequest::ReportIoError: write ...
0
votes
1answer
174 views

How to know DB size using backup file without restoring it

Is there anyway so that we can estimated/know size of database using backup file without restoring it?
0
votes
1answer
349 views

MySQL database freezing after 'use'

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 ...
1
vote
1answer
260 views

How To Export-Import Database in Oracle 11g(Application Express Edition)?

I am beginner in Oracle 11g. I have created a database in oracle 11g(Application Express). I want to export this database with all data(whole workspace) and import this to another computer where I ...
0
votes
1answer
54 views

SQL Server - creating a historical data backup

I've run out of space on my SQL Server 2008 Express DB. i'm creating a "duplicate" SQL Server 2008 Express DB so i can backup my data before i purge my DB so i can start over. Is there a way in SQL ...
3
votes
3answers
93 views

Very high I/O on database during a backup maintenance plan

I've recently been having some hellacious problems with a specific maintenance plan. I found that part of the problem was that I had Shrink and Rebuild Index in my nightly plans, those have since ...
0
votes
1answer
77 views

postgresql backup and recovery

I’m trying to set up backup strategy for a production postgreSQL DB. It will have large amount of data and it should be running 24 X 7. Could you recommend some backup & recovery strategies that ...
0
votes
4answers
180 views

SQL Server Table Backup

A friend of mine has run into this problem on SQL Server 2008, please suggest a solution: He came to know that auto backup scheduled on server were not taking place since last couple of days, when he ...
0
votes
0answers
88 views

restore using mysqlbinlog failing

While doing restore from a MySQL binary log file, it is failing with the following error . mysqlbinlog mysql-bin.000036 | mysql -u root -p asdb ERROR 1032 (HY000) at line 48: Can't find record in ...
1
vote
2answers
1k views

Restore .Bak file to different Server

I Copied some database backups from one server to another server(new instance no databases are present).I tried restoring using below command Restore database dbname from disk='g:\e2bak\dbname.bak' ...
1
vote
1answer
429 views

mysqlbinlog failing with “ ERROR 1032 (HY000) at line 48: Can't find record in `` ” Error

I am facing some issue with PITR restore using mysqlbinlog . It is failing with the following error . # mysqlbinlog mysql-bin.000035 | mysql -u root -p db Enter password: ERROR 1032 (HY000) at ...
1
vote
2answers
71 views

Backup architecture for frequent backups of business critical DB

We've got a database (mysql) driven application which contains business critical information, were looking at building a system that will allow us to backup the db frequently (every 15 minutes, ...
0
votes
2answers
68 views

MS SQL Server 2012 Error on TLog Backup

I have a MS SQL Server 2012 installation on which I am restoring a SQL 2005 .bak which includes some full-text catalogues The original .bak has no conflicts with 2012 (as the migrate advisor was used ...
0
votes
2answers
348 views

Extract Archived Log Files from RMAN Backupset

I have an RMAN backup that is taken on 19th january with: BACKUP DATABASE PLUS ARCHIVELOG command. Now I need to restore Archived logs from that backupset to some other OS directory. Is there any way ...
1
vote
2answers
2k views

RMAN list archivelogs that are needed for to recover specified backup

I've taken backup of datafiles in 31.12.2013. It completed datafile backups successfully, but archivelog backups failed. Now, I want to determine what archivelogs should I backup to be sure that my ...
2
votes
2answers
226 views

What port is used by SQL Server to write backups to a remote server?

I have a SQL Server 2008 R2 Standard instance in a "DMZ", so that it can be client-facing. I am trying to have it write its backups to a central location that is within the network. The engineers ...
0
votes
0answers
319 views

Oracle EXP Error ORA-12704: character set mismatch

I need to duplicate a Oracle 11g Express Edition database from one computer to another computer. I tried exp sys/password FULL=Y FILE=backup.dump (the idea is to do a imp on the other pc) But it ...
0
votes
0answers
21 views

HBase NetApp snapshot

I would like to use NetApp snapshots to backup single node, no-hdfs HBase instance. Do I have to just disable tables or something alse?
0
votes
0answers
177 views

Database backuped, but “Last database backup” property shows bad date

I have this procedure below to backup database(procedure is in backuped database). Procedure is called by external program. Procedure runs fine, backups are created. But when I want to find out last ...
2
votes
2answers
314 views

Is it possible to Clone a RedShift Database?

For some test and development work we would like the ability to routinely clone existing RedShift databases (all schema and all data). Something like a backup-restore. The best I can find starts by ...
2
votes
0answers
109 views

TDP setup for SQL Server databases [closed]

I am looking for any tips/steps used by the DBA's for install and configuration of TDP backup for SQL databases. Hope this meets the criteria for the forum. Thanks
0
votes
1answer
61 views

How to give a client backups of their data without compromising our database design? [closed]

The client is asking for backups of their data, however we would not like to share our database design as it may lead to a security risk... inb4: Security by Obscurity is not a valid security control ...
1
vote
2answers
33 views

Fail plan on a release to production with differential backup

I am currently looking into a fail plan when we do a release to our production server. The context Currently we have one single production database (also production and testing but they are not ...
0
votes
1answer
3k views

Mysql backup from ibdata1, ib_logfile1, ib_logfile0

I accidentally deleted my word press mysql DB. Below is the list of log files that i see in my directory where i am hoping i can get back some of my data. I actually converted the first file ...
3
votes
1answer
424 views

failed with the following error: “Write on ”…bak" failed: 27(error not found) BACKUP DATABASE is terminating abnormally

This issue has been puzzling me for some time now and I'm running out of ideas! Any help would be much appreciated! Here's the problem: MS SQL Server 2008 running on Windows Server 2008R2 ...
3
votes
1answer
340 views

How to take pg_dump of a very large postgres database?

I have a production database server running Postgres 8.4 on Cent OS 6.5.The volume of data has increased recently and within few one month database now has 18500 tables amounting to approx 350GB ...
0
votes
1answer
73 views

synchronizing local and server database

I am developing a billing system software. For this I have created a database it contains many tables database and this is in local system all transactions data will be stored in local systems ...
1
vote
1answer
142 views

db2ckbkp - How to determine what tablespaces are temp-tablespace

I am writing a script to restore databases from backup. The script should need as little input as possible to fulfill this task (in an efficient way). The restore command takes the parallelism ...
4
votes
1answer
1k views

SQL Server backup fails on disk space error

SQL Server 2008 R2 RTM running on Windows 2008 64bit. Having problems backing up a single database with the following command backup database [somedatabase] to disk = ...
4
votes
3answers
203 views

Backup SQL Server with a system backup

I have installed a Microsoft SQL Server 2012 on a server that also are used as a file server. Each day the server is automatic backed up with Acronis Backup & Recovery to a USB-disc that we switch ...
1
vote
2answers
95 views

Information on a Database that was restored with NO RECOVERY

I'm working with SQL Server 2008Sp3. I have a database that was restored from a full backup WITH NO RECOVERY and it then was restored with Transaction log backup files - also WITH NO RECOVERY. At ...
9
votes
2answers
979 views

SQL Server transaction log backups: test whether tail log follows last known log backup

We are using SQL Server with full recovery mode. Given a full backup and a series of log backups, we would like to be able to check whether the log chain is complete from the last full backup to the ...