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
2answers
46 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
12 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
40 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
29 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
40 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
14 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
46 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
38 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
111 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
34 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
81 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
62 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
30 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
23 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
59 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
30 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
73 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
62 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
191 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 ...
0
votes
0answers
36 views
Backup daily for MySQL, MariaDB or PostgreSQL [duplicate]
Good day:
I wonder if there is a program with which I can create daily backups with these requirements:
The first time, make a full backup.
The second time, only the changes since the last backup, ...
2
votes
2answers
87 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
23 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
24 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
134 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
30 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
53 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
82 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 = ...
5
votes
2answers
144 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
86 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
40 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
134 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
63 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
51 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
92 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 ...
-3
votes
1answer
79 views
SQL Server backup devices autentification by user without access to local computer account or AD [closed]
Please is there way to create procedure to create Backup Device by using different user account, for user account without acces to local computer and not defined in AD too, because description from ...
0
votes
1answer
38 views
Reinstall MySql but keep database tables and data
Please help!
There are server issues and MySql is no longer running on our server (Ubuntu). The service is not recognized and needs to be reinstalled. Unfortunately, the database has not been ...
7
votes
1answer
148 views
SQL Server Transaction Backups vs Logs
I've inherited a moderately-sized business-critical SQL Server 2008 database and am trying to wrap my head around backup planning. (I'm a developer, not a DBA.)
The way our system is set up right now ...
2
votes
1answer
28 views
Which MySQL directories to back up using FTP
My server has been hacked and I only have FTP access to recover my data before reinstalling the OS.
Which/where are the directories that needs to be backed up? Will MySQL be recovered back to its ...
1
vote
1answer
30 views
Best way to perform backups with filegroups and then restore those backups
Scenario:
Database consists of these file groups:
PRIMARY
xxTEST2
xxTEST3
xxTEST4
Database consists of the following files in those file groups:
xxTEST_RESTORE - Rows Data - PRIMARY - ...
0
votes
2answers
59 views
How does mysql transaction works?
I already know how to use transactions, what I want to know is how MySQL transaction handles data being processed...
For example, consider the following:
1. I have 2 databases (db1 and db2) ...
2
votes
1answer
85 views
Windows native backups makes SQL Server think that databases backup has been done
community.
I've Windows Server 2008 R2 which hosts few virtual machines.
One of machines is Windows 2008 R2 server with SQL server 2008 R2 Express installed.
Here's the thing:
I wrote a script that ...
1
vote
1answer
221 views
ORACLE restore - how to restore specific .bkp file?
I just started working with oracle and I have some issue.
My database is NONARCHIVELOG mode.
I made two backups:
they are at locations:
...
0
votes
4answers
87 views
Shortest method to upload database to server
I have a SQL Server script file which ranges size of 3gb and I am in need to upload the script file to an external server.
i generated script for my 6gb database by following these steps
...
0
votes
1answer
36 views
PostgreSQL backup error
I am trying to backup my company PostgreSQL database using pgAdmin III, so I selected our company DB from the tree, then right clicked on it and selected 'Backup', selected the destination folder ...
2
votes
3answers
114 views
Backups script completes, but doesn't back up all dbs
I'm running sql server 2005 and I've made a simple backup script that backs up all the databases on one server. The script always succeeds, but when I go to check the log or the files, I see it has ...
4
votes
1answer
87 views
Process attempted to unlock a resource it does not own
SQL Server 2005 SP4 32-Bit
I have a DBCC CHECKDB job running nightly. Last night, soon after the job started, I got the errors below. The database is NOT in suspect mode, and CHECKDB comes back clean ...
1
vote
3answers
110 views
Automated SQL backup on a timely fashion, & cleaup the database for the backed up data
I need to back up SQL database (historian), on a timely fashion, and then clean up the database by removing the backed up data.
I am using MS SQL 2008 (R2), on a Windows XP machine. The biggest issue ...
-1
votes
1answer
81 views
IO Frozen in error SQL error log
The log shows IO DBName is Frozen follow by thaw but yet my database schedule backup task which normally been running isn't since the network team are doing backs (not database backups, according to ...
