Making copies of data which may be restored after a data loss event or to recover data from some earlier point in time.
0
votes
1answer
22 views
Need some good tutorial regarding Rman,datagaurd,rac and performance tuning [closed]
As i am very new in oracle database, i need some good tutorial,configuration file,book for ASM,omf(oracle managed file),data guard,Rac,troubleshhoting & performance tuning.Thanks.
1
vote
1answer
37 views
Should my Postgres backup server be as beefy (IO, processor, RAM) as my master?
I've set up a Postgres database on a server with 2 CPU cores, 4GB of RAM and an SSD volume (on top of RAID 10 of course). This is our (sort-of) "beefy" production database server (I can easily add ...
2
votes
2answers
58 views
Transaction Log maintenance when switching to Simple Recovery
Background:
I recently inherited 50+ SQL Servers with 450+ databases. The nightly backups are roughly 8TB and, needless to say, we're using more disk space than we'd like. All of the databases are ...
2
votes
1answer
58 views
SQL restore duration
I am trying to determine the duration of backup restore. I executed a few restore command to restore some backups located on network share drive. Here is command and summary,
RESTORE DATABASE [test]
...
1
vote
0answers
18 views
how to verify mysql backup file
Is There any tool to verify the backup taken using mysqldump without manual restoration ?
I have to take full backup daily so it is difficult for me to verify the backups daily by restoring them. As ...
0
votes
0answers
34 views
Is it recommended to run a Oracle schema backup when there are active sessions?
I need to backup two schemas in a Production database (Oracle11gR2) that are being accessed by an application and some other systems. These schemas are quite small and exp will be used for the export.
...
-1
votes
0answers
29 views
How do I clear log copy queue red gate sql backup? [closed]
I was wondering if anyone knew the steps to take to clear the Log Copy Queue in Red Gate's Sql Monitor software?
2
votes
2answers
43 views
Recovering a lost datafile with no backup available
How do you recover a lost datafile if:
the database is running in archivelog mode
there is no backup is available
2
votes
1answer
39 views
Recovering from the loss of datafile in NOARCHIVELOG mode?
How do you recover from the loss of datafile if the database is running in NOARCHIVELOG mode?
4
votes
4answers
80 views
Backup not creating a new file
I run a daily backup of my database through command prompt:
c:\sqlcmd -H localhost -Q "BACKUP DATABASE test TO DISK='c:\test.bak'"
But the new backup replaces the previous backup. Please tell me ...
-2
votes
0answers
24 views
How to Full Backup, Differential Backup & Transactional Backup Oracle in Linux OS [closed]
I'm beginner in Oracle. I just wanted to add to my knowledge. I have an Oracle database. I've done a full export of my database. It works pretty well so far.
My question is whether export is the same ...
0
votes
4answers
87 views
How can I create a fresh copy of a large database on SQL Server?
I have a very large database (400GB) that is now corrupted. I tried repairing it with the repair_allow_data_loss option, but that did not fix the problem so my next option is to restore to a previous ...
0
votes
0answers
24 views
Rackspace Cloud Databases: incremental backup
Rackspace Cloud Databases are a little bit special in that we do not have access to the bin_log file, they are not servers in the traditional sense. I do have a couple of Cloud Servers with them but I ...
3
votes
2answers
94 views
How large will the Transaction Log backup be?
I encountered a production database of 12 GB with a log of 90 GB. Full and differential database backups are made with a third-party backup tool, but no one is backing up the transaction log so it got ...
2
votes
2answers
79 views
How can I dynamically back up all SSAS databases on a given instance?
I want to dynamically back up all the databases on a given SSAS instance using a SQL Agent job (which would most likely involve executing an SSIS package). It is imperative that this is a dynamic ...
0
votes
2answers
61 views
Restore Oracle tablespace to 2 days before
I have multiple test tablespaces in an Oracle SID. One of the tablespace is updated with wrong data. It works fine 2 days before. I want to restore the tablespace to 2 days before.
Can anyone ...
1
vote
1answer
29 views
How to restore from a backup of a very old version of DB2 (version 6.1 backup)?
I am helping a client with some legacy application that is still running DB2 6.1 on Windows 2000! I am helping them migrate to newer software/hardware infrastructure.
I have a backup of the DB2 6.1 ...
2
votes
1answer
63 views
Backup on an empty SSAS database hangs
I created an SSIS package to iterate through all databases on an SSAS instance. It grabs the DatabaseId using AMO in a vbscript, then generates the XMLA to backup each database.
Most databases ...
0
votes
2answers
48 views
Backup SQL Server To NAS
I have seen that there are similar questions like this but I tried all of them and my problem still exist. I want to backup a db.
I created a shared folder on NAS
I can reach this shared folder ...
-4
votes
1answer
44 views
Oracle database and data has been corrupted. Is there a way to get it back? [closed]
The Oracle database has been corrupted and both the data and backups were lost in the corruption. Is there anything I can do to recover my data? It would be terrible if it were all lost.
0
votes
1answer
26 views
Postgres backup and WAL to S3
We are looking for a solution for the following problem:
We have set up streaming replication so we have a master DB and a slave DB, we want to have basebackups and WAL files sent to our S3 storage ...
2
votes
1answer
72 views
How to restore IBM DB2 database from AIX to Windows?
I had made backup from remote IBM DB2 server in AIX using this command:
./db2 backup database DBEMP to /home/dbemp/backup
Then I grab the backup file using FTP Client from my Windows.
I run this ...
1
vote
0answers
46 views
Is it possible to use 'restore UNTIL SCN' with rman and Oracle 9i in NOCATALOG mode?
I'm trying to do a hot backup with rman that I can copy to a USB drive so I can recover it on a new server.
The backup was done two days ago and the restore database command was working on the same ...
3
votes
6answers
143 views
Backup very large table
I have to update certain values of a large table (for the sake of a presumed example, it is called 'Resource' and it is over 5M rows) and thus I have to make a backup before performing the changes. We ...
2
votes
0answers
42 views
Backup very large table in SQL Server [duplicate]
everyone.
I'm deeply sorry if this is an amateurish question, but I have to update certain values of a large table (for the sake of a presumed example, it is called 'Resource' and it is over 5M rows) ...
1
vote
1answer
43 views
Help with best practice of merging databases
Bad news, our website server (Windows 2003) crashed because of dead RAID controller.
Luckily few hours later our backup server was up and website was live again.
Hopefully tomorrow our original ...
2
votes
2answers
133 views
How to backup IBM DB2 Database online?
I tried to backup the IBM DB2 (LUW) Database using this command:
./db2 backup database DBEMP to /home/user1/db2bkup
But I got this message:
SQL1035N The database is currently in use. ...
-1
votes
1answer
65 views
How to merge data from 2 databases [duplicate]
I have a SQL-Server database that crashed while I was away on vacation. All info from 5/2/13 is missing from our current database because my replacement implemented a back-up of the database from ...
0
votes
1answer
43 views
passing --single-transaction in mysqldump command line tool
I'm using MySQL GUI tool to backup my innodb database and I use the option '--single-transaction' to get a consistent copy as backup.
I have however, noticed that if I backup using command line ...
0
votes
0answers
24 views
'Offline' MySQL backup - server not starting
The MySQL server is no longer starting because the partition is too full. The issue seems to be ibdata (40GB). I wanted to follow these instructions (at 'InnoDB Infrastructure Cleanup')
Now I already ...
1
vote
3answers
67 views
Restore database with zero size log file [duplicate]
SQL Server backups contain meta-data about the size of the original log (LDF) file.
So if you backup a database that has a 5GB LDF file, when you restore it, you will get an (empty) 5GB LDF file. ...
2
votes
1answer
35 views
To make a LVM backup of a MySQL database, would I have to reduce the logical volume size?
I am trying to learn how to do a Ubuntu LVM backup of a MySQL database.
For this test I installed a fresh copy of Ubuntu 12.04.2 LTS on a new box, along with MySQL 5.5. The box has one hard drive. ...
1
vote
2answers
75 views
How to backup databases to ensure data recovery
I have 15 customer databases that have minimum replication at different sites. I currently do nightly back-ups and transfer the database back-up nightly to our main server via 7zip. We recently had ...
1
vote
1answer
79 views
How do I refresh SQL server cross database references after a database is reattached with a different name? (Are there hidden synonyms?)
I have 2 seperate SQL databases on the same SQL instance. Database1 references tables on Database2 in its views and stored procedures. Everything was working fine until we had to create a fresh ...
1
vote
4answers
247 views
Daily and Differential Backups
Is there a program with which I can create daily MySQL, PostgreSQL and MariaDB backups with these requirements:
The first time, make a full backup.
The second time, only the changes since the last ...
2
votes
2answers
96 views
Is it possible to backup a database that is not ONLINE?
We have a job which backs up all ONLINE databases nightly, but for some reason it didn't back up msdb. So the issue is at that time msdb was in some status was other then 0. So my question is : is it ...
0
votes
1answer
30 views
OK to put temp tablespace on volatile storage or to omit it from backups? (Postgresql)
I would intuit that it's fine, but I just want to make sure there are
no gotchas from a recovery point of view:
If I were to lose my temp tablespace upon system crash, would this
prevent proper crash ...
1
vote
1answer
28 views
xtrabackup backup grants?
I'm using MySQL 5.5 + Opensuse 12.3 .
After face an issue with mysqldump (appear be a bug with OpenSuse Mysql distribution) I have looking for others backup solution.
I found the xtrabackup from ...
0
votes
0answers
28 views
Should I keep pg_xlog on the same disk as data if using disk snapshotting?
We're running on EBS volumes on EC2. We're interested in leveraging
EBS snapshotting for backups. However, does this mean we'd need to
ensure our pg_xlog is on the same EBS volume as our data?
(I ...
1
vote
2answers
199 views
How to backup to local drive and network drive simultaneously?
I can backup to a local drive and mirror:
BACKUP DATABASE [xxx]
TO DISK = N'XXXX.bak'
MIRROR TO DISK =N'Network path \XXX.bak'
WITH INIT
--directly to network drive
BACKUP DATABASE [xxx]
TO DISK ...
0
votes
1answer
40 views
Recover data from accidental update
I have done an incorrect update and hence I restored the DB with a backup from the previous day. I have not taken a copy of the corrupted data before restoring the backup. Is there any possibility to ...
1
vote
2answers
66 views
After moving database (backup, restore), I have to re-add user
I occasionally move a database (SQL Express 2012) from a development machine to a server, or vice versa, using database backup and restore in SQL Server Management Studio.
Whenever I do this, the ...
1
vote
2answers
90 views
Shrinking log files with SMO
I know I can use the following t-SQL to shrink a log file:
BACKUP LOG db1 TO DISK = '\\server\share\db1_log1.trn';
DBCC ShrinkFile([db1_log], 0);
How do I do the same with SMO? I tried:
$server = ...
6
votes
2answers
150 views
How best to maintain SQL log file sizes
I'm somewhat of a new DBA and I'm managing a SQL Server 2012 instance that has a fair amount of activity. I'm running in Full Recovery mode because we need point in time recovery.
Right now, I'm ...
3
votes
2answers
96 views
Error while taking backup using SSMS
I am using SSMS. I have about 5 logins. For a particular login I have all server roles other than sysadmin. It is a sql login (not windows authentication). In user roles it has all permission for ...
1
vote
2answers
47 views
Live backup without lock
In our company we have a lot of MySQL databases. Some of these are critical and we want to take a back-up of all databases. These databases can't be locked because the application can change these ...
5
votes
1answer
192 views
How do I shrink the physical Transaction Log file when it's the principal in a mirror?
We setup database mirroring over the weekend, and forgot to re-enable the job that backs up the transaction logs. When I came in this morning, the transaction log had ballooned to 58GB, and was taking ...
3
votes
1answer
82 views
Backing up file groups with restore to earlier backup
I have a task: I have created a database with a filegroup lamb that has a few tables.
I need to extract a csv into a table in a filegroup named lamb and back up that filegroup.
Then extract another ...
0
votes
3answers
63 views
Reasons for incremental backup on Progress OpenEdge
In the case that storage is not a problem: are there actually any good reasons for doing incremental backups instead of just doing full backups?
Edit
This could actually refer to any database with ...
1
vote
1answer
122 views
Compress backup file using T-SQL
Is it possible to compress a backup file to .zip (or another) in a stored procedure invoked from a maintenance plan?
My maintenance plan contains these steps:
check DB (consistency, re_index, maybe ...
