Making copies of data which may be restored after a data loss event or to recover data from some earlier point in time.
2
votes
2answers
122 views
Why isn't the transaction log getting truncated when taking a full backup?
In full recovery model, if we take a full backup, the log file is not truncated. It is done when we take a transaction log backup.
Any particular reason of why it is done this way?
2
votes
1answer
91 views
Software for backing up SQL Server databases
Since using the new version of Symantec, I've experienced lots of problems doing incremental backups of clients' SQL databases.
Is Windows Server backup a good alternative to Symantec Backup Exec ...
3
votes
1answer
78 views
Necessary to use a checksum on a backup and not solely the 'verify backup' option?
If want to ensure the integrity of a backup, would it be a necessity to use a checksum on all of my backups and not just the 'verify backup' option?
2
votes
1answer
431 views
Does the Amazon RDS backup/snapshot service lock tables?
We have a database that is 100+GB. Most tables use the InnoDB engine.
A regular dump takes 1-2 hours.
If we moved to Amazon RDS, would this backup cause table locks?
Does Amazon use a simple ...
1
vote
1answer
309 views
Postgresql WAL Archiving, How to do it properly?
Basically I have one (for now) mission critical postgresql database that I will need up to the minute recovery for, I've never implemented a working WAL archival before so I would like to know what is ...
0
votes
5answers
51 views
Copy my data from a existing db to a new db
I have a database which has my data's that I have been working for months. Now, I want to delete that db. What concern's me is that the data's that I have might come in handy in the future ...
2
votes
2answers
161 views
Set Backup Compression on SQL Server 2008R2 on by default
I can't seem to find the option to set the server property that will enable compression on SQL database backup to be ON by default, so I don't have to manually set it every time.
Ca anyone point me ...
2
votes
1answer
103 views
How do I ensure consistent MySQL backups?
How can we ensure MySQL backups are consistent when they are taken as full backups as well as incremental backups using binlogs?
According to me, I record the COUNT(*) from random tables after ...
0
votes
1answer
530 views
How to automatically regularly a week backup SQL Server database if changes exist in the database for the previous week
I´m new to SQL Server administration.
I´d like to create automatically backup database every sunday night, if there was any change in previous week (if not, backup is unnecessary).
Is there some way ...
3
votes
1answer
232 views
Microsoft SQL Server 2008 R2 backup error
I'm trying to do a simple backup to an external disk and getting this error:
Backup failed for Server 'Server-name'
Additional information:
System.Data.SqlClient.SqlError: The media loaded ...
2
votes
2answers
113 views
SQL Server Transaction Log Initial Data Load
What is the standard process when initially populating a database with 5GB+ to avoid a large transaction log? From my understanding the log file would jump to a large size after the initial load and ...
2
votes
3answers
630 views
Copy PostgreSQL data from one PC to another
I am migrating my server application from the existing system to another system. Unfortunately, the existing system is also the database server. It has data stored. Is it possible to copy this data to ...
7
votes
1answer
121 views
SQL Server considerations when backing up / restoring a database that uses replication
In the event that I need to restore a database involved in replication, what considerations to I need to keep in mind?
Do I need to keep backups of both the publisher and the subscriber?
Can I ...
0
votes
1answer
660 views
Can we back up mysql databases by copying files?
I tried to reinstall mysql on my machine, but it keeps failing. Everytime it fails, it does this locking and that locking and future effort would fail again.
Finally I decided to do truly clean ...
3
votes
1answer
230 views
How to create a SQL Server 2008 backup without logs with mirroring
How do I create a backup of a SQL Server 2008 in a mirrored setup without any logs?
We need to do this so that when we restore our local development databases, we would have the most up to date ...
4
votes
1answer
371 views
Transaction Log Truncation with Copy Only
I have a database backup job set to use full backup with the Copy only option on once daily. The copy only is on because from what I have read that is the only way to backup a database that is ...
2
votes
1answer
340 views
On SQL Server Backup: Msg 3271, Level 16, State 1, Server Line 1 A nonrecoverable I/O error occurred on file
I am trying to back up a pretty big database and I keep getting this error:
Msg 3271, Level 16, State 1, Server {Server Name}, Line 1 A
nonrecoverable I/O error occurred on file "{Backup File ...
2
votes
1answer
189 views
Assertion failure from InnoDB while restoring using Innobackupex
I thought I would give back to all those people who help me when I have a problem. This might be something old, but I did not find it anywhere so here goes:
We recently upgraded our production DBs ...
1
vote
1answer
118 views
Access denied Error in MySQL and Drupal
We are trying to deploy a Drupal application on our production server.
We see this strange error Lost connection to MySQL server at ''Access denied root@ipaddres password(yes) after deploying.
We ...
0
votes
1answer
165 views
New transactions during a Sybase “dump database” command
I have a Sybase 15.5 database which is backed up every night using the DUMP DATABASE command. The process takes about 30 minutes.
What happens to the transactions that occur within those 30 minutes? ...
0
votes
1answer
595 views
Oracle big datafile restore fails using Netbackup (ORA-19511, ORA-27190)
I am restoring datafiles about 1000GB in size. I am using Netbackup as a backup server.
After 2 hours reading Netbackup fails with the following error:
7/25/2012 3:27:50 PM - Error bpbrm(pid=1176) ...
2
votes
6answers
296 views
Taking backup of all the databases in SQL Server
I have a Microsoft SQL Server 2005 DB server. In the DB server, I have around 250 user databases. I have to take a back up of all these databases. Since, manually taking backup consumes lot of time, I ...
0
votes
1answer
456 views
ORA-00379 no free buffers
I'm trying to do collection_manager in OVPI but I'm getting db error
ORA-00379 no free buffers available in buffer pool default for block
size 32k
oracle 10.2
Thanks for any help in advance
1
vote
1answer
141 views
Failed to restore mysql database with zmanda
I want to setup a slave from my backup version of mysql using zmanda (it's a full backup).
I've followed this guide.
Result of mysql-zrm-reporter
backup_set backup_date ...
1
vote
1answer
147 views
Questions about PostgreSQL backup/restores
I've inherited a large PostgreSQL 8.4.7 database that is currently not being backup at all. The database itself I believe is around 100GB, I've been reading about the different methods to backup this ...
2
votes
3answers
375 views
How can you save all user-defined functions to txt files on your local hard drive?
I am running SQL Server 2008 and need to back up the UDF scripts/queries that I have created. How can this be done in a timely manner? I tried right clicking on the folder icon where the UDF are saved ...
3
votes
1answer
356 views
AG and SQL Backups
I am using always on in sql 2012 and have an AG setup. I would like to know if i were to backup the primary database and restore it would that be allowed without taking the cluster down etc.
...
3
votes
2answers
211 views
Writing transactions to .MYD file to take Backup
I'm trying to backup MySQL DB by archiving the data directory of required databases.
I'm doing FLUSH TABLES WITH READ LOCK before taking the backup, but even then some of the transactions were not ...
0
votes
0answers
131 views
change database name controlfiles after restore?
I have restored database with the name DB to another database called DB01
it is in STARTED status (not mounted) and it seems I can not change the name if it is not mounts, and I can not mount it ...
4
votes
1answer
279 views
Why would a SQL Server 2008 R2 database disable a table index when upgraded to SQL Server 2012
I've restored a database backup in a new SQL Server 2012 server from a .bak made in SQL Server 2008 R2, and one of the tables has it's primary key index disabled. This doesn't happen when I restore to ...
1
vote
1answer
349 views
Oracle backup with RMAN Options?
I'm trying to learn RMAN but getting confused everytime I read Oracle docs!
Can someone help me what are the differences and when to use the following?
BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT
...
2
votes
3answers
726 views
MySQL backup with no downtime
I'm running a M/S replication of MySQL 5.5 / innoDB (over ubuntu).
My DB is pretty large: ~250GB.
I'm looking for a backup tool/service that will do the following:
full backup
no downtime / locks ...
2
votes
1answer
222 views
Wrong behavior in Backups
Checking my Native backup this morning something wierd happened. I will describe the problem here.
1) The msdb table backup set shows me the backup was done successfully.
2) The errorlog shows me ...
3
votes
1answer
770 views
Why is my postmaster process (sometimes) becoming unmanageable after a WAL base restore?
TL;DR: Un-stoppable, unusable postmaster is being spawned when Postgres is started right after restoring its data directory from a WAL base backup. Why?
Context:
We run postgresql 8.4, on CentOS 6, ...
6
votes
2answers
285 views
PostgreSQL PITR restore
I have a PostgreSQL 9.1 server running on a CentOS 5.8 32bit OS and I have enabled WAL archiving. On this server, there are three databases: databaseA, databaseB and databaseC. Someone deletes a ...
4
votes
2answers
3k views
Can I restore a SQL Server .bak files without SQL Server?
I have some large .bak files from a SQL Server 2005 dump.
Can I restore these without using SQL Server, either to PostgreSQL, MySQL, or to flat text files?
An open source solution would be most ...
0
votes
1answer
400 views
Incremental level 1 backup with no Incremental level 0?
I have done the following steps:
Backed up database with INCREMENTAL LEVEL 0
Delete INCREMENTAL LEVEL 0 backup without telling controlfile. So deleted it by hand. And did not make crosscheck.
Backed ...
2
votes
2answers
274 views
Would it be possible/wise to execute 2 parallel restores from a single backup?
Every night I create a backup (to disk) of a particular database. Subsequently that backup has to be restored to 2 different servers. These restores now happen sequentially and take about half an hour ...
4
votes
1answer
547 views
What's the fastest way to replicate a MySQL database from one machine to another?
What's the fastest way to replicate a MySQL database from one machine to another? The two machines are connected via LAN. How to do it without mysqldump?
If using mysqldump, is the fastest way
$ ...
2
votes
2answers
2k views
How to log error details when using using try/catch for dynamic SQL backup commands
When issuing a backup command within a stored procedure that uses a try catch and dynamic sql, the error messages are very general when compared to running the backup command directly.
Try/Catch ...
-1
votes
2answers
2k views
Extract mdf & ldf files from backup file?
Is there a way to extract SQL Server files (.mdf & .ldf) from a backup file (.bak) to a physical location, without restore database?
I need a restore query or script to restore files from bak ...
0
votes
1answer
120 views
Backup and trimming data idea
Our main table, tblLink, will have its primary key as foreign in a few other tables too and one of the tables will be tblMainData which over time will be millions of rows.
We would like to maintain ...
0
votes
0answers
193 views
log 1 sequence# not archived, no available destinations
i'm facing a problem with my oracle 10.2.0 database
it's running on HP-UX 11.31
the problem is when ever i try to run
SQL> alter system archive log all;
it show that error
alter system archive log ...
3
votes
1answer
466 views
Script to Restore/Create SQL Server 2000 Database from Another Database's Backup
I'm trying to create a database, NewClientDB, by restoring another database's, OldClientDB, backup, d:...oldclientdb.bak. I've always done this via SQL 2000 Enterprise Manager, but the GUI keeps ...
3
votes
2answers
143 views
SQL database backups methods-tools-procedures
Currently, I am investigating some way to more efficiently backup 4 Production SQL Databases (3 different servers/instances) and would like to know if anyone else has had the problems we are having ...
4
votes
2answers
194 views
Change Location of VALIDATE RECOVERY FILES work area
Is there a way to tell the VALIDATE RECOVERY FILES command to use a different location with more available disk space?
When I run the command in RMAN, it fails with the following error stack:
...
3
votes
1answer
83 views
Does MySQL Enterprise Backup work across Operating Systems?
The problem with testing is that one can never be sure (it may seem to work and then you find some thing changed later). A definitive statement from the vendor would definitely be helpful (I cannot ...
2
votes
2answers
78 views
Incremental backups - differences
What is the differene between:
BACKUP INCREMENTAL LEVEL 0 DATABASE;
and
BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE;
? I read some manuals, but I don't get the idea beacuse of my poor ...
2
votes
1answer
256 views
How to write a shell script to check the mysql database backup status.
I have mysql production databases running in main server(Linux) and from this server every night the backup is taken into local server.
Now i want to find a shell script to check if all the databases ...
3
votes
1answer
78 views
Is it imperative that I backup my index files?
I have a few different instances (SQL 2000, 2005) with indexes placed in a separate filegroup. Do i need to ensure that this group is backed up, or will it be rebuilt by a restore of of the database?
