Making copies of data which may be restored after a data loss event or to recover data from some earlier point in time.

learn more… | top users | synonyms

2
votes
1answer
274 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 ...
2
votes
1answer
348 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 ...
2
votes
1answer
452 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 ...
2
votes
1answer
409 views

What happens if we copy neo4j's data folder while the server is running?

If my neo4j server is running and I copy the data folder using copy/rsync folder, what are the chances of data corruption?
2
votes
1answer
260 views

Initial recovery Postgres with backup in sync commit mode

I've got a master and a slave postgres 9.1.3 database. I would like to init the backup database for the first time. I did the following steps: Stopped master Copied all files to Slave Create ...
2
votes
1answer
712 views

Oracle 11g production database copy to USB drive

What is the correct commands for backing up a production Oracle 11g database (while still running) to an external USB drive or different directory. I am new to Oracle and but have experience with SQL ...
2
votes
3answers
2k views

How to detect a running mysqldump?

Here are the things I can't change: We got a mySQL myISAM replication running a master and some slaves. One slave is being used for nightly backups using mysqldump. The backups is using heavy locks ...
2
votes
1answer
377 views

Does mysqlhotcopy block SELECT statements from different clients?

I would like to create a backup of different MyISAM tables on a server using mysqlhotcopy. These tables are about 6GB in size. I would like to know, does mysqlhotcopy block users from SELECTing ...
2
votes
1answer
68 views

Oracle 10g Administration

Redo log files are not multiplexed in our database. Redo log blocks are corrupted in group 2, and archiving has stopped. All the redo logs are filled and database activity is halted. Database writer ...
2
votes
1answer
1k views

Maintenance Plan fails but the query it generates Runs

I have an SQL Server 2005 Enterprise Edition whose Maintenance plan fails constantly with the error: backup MYSERVER (MYSERVER) Backup Database on MYSERVER Databases that have a compatibility level ...
2
votes
1answer
473 views

How often do you back up the distribution database for transactional replication when sync with backup is set to true for the distribution database?

I'm trying to figure out how often to back up the distribution database when "sync with backup" is set to true. If I understand this correctly, sync with backup ensures the distribution database can ...
2
votes
2answers
196 views

Extract specific backupfiles from SQL Server 2008 backup

I have a big .bak file containing a full backup and some transaction log backups. Is it possible to extract only the transaction log backups so I can copy them to another PC? (the full backup has ...
2
votes
2answers
61 views

Backup status report from multiple server in sql server 2005

Per daily routine activities of DBA, as we know backups are important to be monitored and to make sure they are corrupt free, i am trying to fetch a report to get such status. Moreover, we have SQL ...
2
votes
2answers
37 views

Sqlserver: Get Meta-Info about TRN file

Is there any way to get the timespan of the data contained in a TRN-File? What I have: A backup of a transaction-log What I need: The timestamp of the first and the last entry inside the log ...
2
votes
0answers
127 views

Sql Server 2012 Enterprise Backup with no file [closed]

We currently have a database which increments 5TB a day. The current backup solution we have uses Avamar, which I believe does a kind of block comparison backup where there is no need for an actual ...
2
votes
0answers
607 views

Get postgres snapshot from Amazon RDS

I can not find a simple way to get a copy of the nightly backup I take of my Amazon RDS postgres instance so I can restore it on my local machine to play with. Right now I'm doing a pg_dump when I ...
2
votes
0answers
103 views

backup history script produces incorrect results

I have a database that is backed up via maintenance plan. The database is scheduled to be backed up at 8:00PM. It usually takes 6 hours to complete. According to this query, SELECT distinct ...
2
votes
1answer
342 views

Backup and restore FileTable files

I'm preparing to use the FileTable feature in SQL Server 2012, but I'm unclear about how backups work with this feature: Does a full database backup include FileTable files? How would I perform the ...
2
votes
0answers
45 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) ...
2
votes
0answers
60 views

Is it possible to have a valid backupset with null position?

In database restore process I need to rely on position column exists in backupset record to restore the latest backupset. Restore the latest backup on the database I noticed sometimes position is ...
2
votes
0answers
78 views

How to display differential backup date in SSMS Object Explorer Details

SQL Server Management Studio exposes the Object Explorer Details (selectable from the View menu option) and its context menu that allows adding fields to the default display. Full and Transaction Log ...
2
votes
1answer
144 views

Availability Strategies in MS SQL Server 2008

I need some assistance in developing a backup strategy for my SQL Server deployments. Currently I have two classes of customer: Hosted customers, whose data is housed in our datacenter, and On ...
1
vote
3answers
2k views

Transaction log for SQL Server is too big

I have a database that has a 33 gb transaction log. It is caused by the fact that the database is in full recovery mode has been used for over 5 years prior to the first backup. I want to truncate ...
1
vote
3answers
2k views

SQL Server backup job last 5 days

We've been having this nightly backup job on SQL Server 2012 but it appends to the .bak file instead of overwriting, so while googling I discovered master.dbo.xp_delete_file I noticed that I can ...
1
vote
3answers
1k views

restore could not start database

Restore failed for Server 'servername'. (Microsoft.SqlServer.SmoExtended) System.Data.SqlClient.SqlError: RESTORE could not start database 'ECP'. (Microsoft.SqlServer.Smo) The database is ...
1
vote
4answers
299 views

Database backups

I have 10gb RDBMS (SQL Server). I would like to back it up as often as possible, but it seems that I will need an awful lot of space to make this happen on the order of several times per day. How ...
1
vote
3answers
6k views

Restoring .bak file SQL Server 2005 in SQL Server 2008

I don't have enough knowledge in SQL Server back and restore. I just want to know is it possible to restore an SQL Server 2005 .bak file in SQL Server 2008? If yes, how can I do it?
1
vote
4answers
5k views

How do I archive and restore selected tables using SQL Server?

How do I archive and restore selected tables using SQL Server?
1
vote
2answers
296 views

T-SQL script to perform a compressed backup with maximum compression level [duplicate]

I have a database with full backup of almost 2GB. When I perform a full backup (without compression) and then compress it with winrar it become 140MB, but when I backup WITH COMPRESSION syntax the ...
1
vote
3answers
750 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. ...
1
vote
2answers
109 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
2answers
330 views

SQL server 2005 SP4 differential backup is failing

We have an SQL server 2005 with SP4, x86. When we attempt to take the differential backup, we are getting the following error message. Cannot perform a differential backup for database "ABCD", ...
1
vote
3answers
168 views

SQL Server 2005 Log Truncate - how long for a 60Gb log; mins, hours or days? [closed]

I have taken over an old website. To cut a long story short the people that host the computer, backup all the database files, but there is no maintenance plan in place for the backup (e.g. they ...
1
vote
2answers
220 views

What are the primary architectural differences between the backup formats of some of the more common RDBMS' and what advantage do they serve?

Of the systems with which I am familiar, I have noticed that SQL Server's native database backup format is binary and proprietary. PostgreSQL and MySQL allow for a simpler approach, dumping the ...
1
vote
4answers
2k views

Daily and Differential Backups [closed]

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 ...
1
vote
2answers
179 views

Backup of database X on SQL Server 2008 on server A - restore to SQL Server 2012 database Y on server B

I want to copy a SQL Server 2008 database to SQL Server 2012 with a different database name. Took a backup of 'production' and copied it to the SQL Server 2012 machine. Created a new SQL Server 2012 ...
1
vote
3answers
154 views

Is bulk-logged recovery model ever a good choice if point-in-time restore is not needed?

Is the Bulk-Logged recovery model in SQL Server ever preferable to Simple if point-in-time restore is never needed? I have read many articles about transaction log models, but cannot find a clear ...
1
vote
1answer
843 views

How to flush SQL Server database from RAM to hard disk?

As part of the nightly maintenance plan, my working MS SQL Server 2012 databases are backup-ed with options of simple recovery and full backup. Transaction log is not backup-ed. Also, at nights the ...
1
vote
1answer
483 views

Restore SQL Server 2000 Database in use

I need to restore a SQL Server 2000 database to a backup of about 2 days ago. I have just backed it up and have tried to restore it, but it says it is in use. What is the best way to find out who is ...
1
vote
4answers
1k 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
vote
1answer
558 views

Two databases of same size, backups sizes are very different

This is not a big problem for me, but still, I would like to understand what is happening here. I have two databases on my SQL Server 2008 (10.00.1600) - they are restored from the same backup (and ...
1
vote
1answer
214 views

Restoring a differential backup in SQL server 2005

I have created a full back up of my database by executing the line below in my application: Dim Query As String = "backup database Ari to disk='G:\Documents and Settings\i\Desktop\BKAR\" & ...
1
vote
2answers
1k views

Differential backups in SQL Server 2008 R2

I created a maintenance plan to backup all user databases (full) and set them to expire after three days. This has proved to be cost inefficient in regards to disk space so I want to switch to ...
1
vote
3answers
171 views

Where can I learn about MySQL master/slave, master/master, or clustering setups?

What are the best resources you've read or watched about setting up master/slave or clustering for database replication? I don't know much about this. I have a database that is getting rather large ...
1
vote
4answers
8k views

Taking a backup of a single table in the SQL Server

I know how to take a backup of a database in SQL Server and restore it. But how can I take a backup of a single table, and then restore it? Is it possible? I have a database with two different names ...
1
vote
2answers
541 views

Oracle Databases - need to export nightly for backup/DR purposes

I know nothing about Oracle databases, so if my question's path seems odd, feel free to tell me the right way to do things. I have 2 ways I see currently that I can backup a server running 3 Oracle ...
1
vote
4answers
212 views

Database growth causing issues sending backup over network

We take a full database backup on our primary SQL Server, and send that file over our network to a remote site where it is recovered on a backup SQL Server. We use this backup database for slow ...
1
vote
2answers
90 views

What Current Continuous SQL Server Backup Solutions Are there?

With Mirroring being deprecated in SQL Server 2012 and up along with AlwaysON Availability Groups costing $7k per core, I am wonder what options are there for constant reliable backups with a somewhat ...
1
vote
2answers
6k views

How to Fix log_reuse_wait_desc=LOG_BACKUP? LOG Backup not possible

I checked sys.databases to find out which databases need LOG backups. It surprised me that I had quite a few where log_reuse_wait_desc=LOG_BACKUP meaning, the JOB I have set up to run LOG backups on ...
1
vote
1answer
117 views

Does the SQL Server Backup Database Command also backup views from a Database?

I have a backup job (SQL Server Agent job) which will iterate through all of our SQL Server databases in SSMS, invoke the BACKUP DATABASE command to create a .bak file on a different server. This ...