The tag has no wiki summary.

learn more… | top users | synonyms (1)

1
vote
3answers
205 views

Good backup strategy for heterogeneous data consisting of images/databases/office files/svn repositories/

I'm looking for a simple on-site (i.e. not online) backup solution for our small company. Right now we have approximately 4TB of data in total, maybe adding ~500GB per year. The amount of data ...
1
vote
3answers
119 views

website backup: database content reliably matching static content without downtime?

If the server fries and all you have is your last backup, you at least want it to be congruent in itself / of high integrity. Well, I do. What I am worried about is that without downtime, one faces a ...
0
votes
3answers
189 views

mysqldump --single-transaction with dump files separated by table?

Using mysqldump, how can I create a consistent backup of a MySQL (InnoDB) database and have the dump files be separated by table? To create a consistent backup using mysqldump, I know there is ...
3
votes
2answers
262 views

Oracle RAC failover backup procedure

We have Oracle 11gR2 RAC database on two nodes. We also have a RMAN backup script that works fine, using a recovery catalog database which is located in a town 20km from the data center. The script ...
0
votes
2answers
33 views

Complex retention policy

I have daily database backups scp'd to a directory on a local linux machine for multiple databases. The naming format is [dbname].backup; there is no timestamp and currently the latest backup ...
0
votes
2answers
275 views

Keeping two servers in sync - secondary server only to be booted for the backup, or in outage

I've just started a new Software Development job but I've basically been given loads of sysadmin stuff to do because the development team consists of only 2 people + the CTO. I've got pretty much zero ...
0
votes
2answers
311 views

Running sql server 2000 backup file on sql server 2008

I restored sql server 2000 .bak file to sql server 2008 by --RESTORE FILELISTONLY --FROM DISK = 'D:\DBHarshal\full backup august 6.BAK' --ALTER DATABASE EPICSms --SET SINGLE_USER WITH --ROLLBACK ...
2
votes
1answer
115 views

LVM+MongoDB. Dropping in speed of backup creation

Till recent time we have been making mongo backups archiving LVM snapshot on hidden SECONDARY server with RAID10 on SAS disks. Currently operation on making snapshot from volume with 500 Gb of data ...
2
votes
1answer
749 views

How to backup/restore excluding filestream varbinary in SQL Server 2008?

There is an application used in a production site that uses SQL Server 2008 as its DBMS. The database schema uses Filestream Varbinary to save binary data on the filesystem instead of directly into ...
1
vote
1answer
32 views

Backup slowness after changing the SAN switch

We have a netbackup environment Recently we changed the connectivity of two of our sql servers(cluster servers) from one SAN switch(MDS 9509) to another (MDS 9513) followed by which we are ...
1
vote
1answer
41 views

Backing up a mirrored SQL environment

I have 2 SQL servers in Mirror configuration. I want to backup these servers but backing up the SQL databases in Mirror state causes an error. These two mirrors also have a witness set. I would ...
1
vote
1answer
27 views

Error in moving Backup file

I have created a backup file by SQL query like this : BackUp [DBName] to disk=N'Backup path'. now i want to move it to another folder.but i recieve this error: Cannot copy 'Backup file ...
1
vote
1answer
225 views

How do I backup my customer's data?

If you run a SaaS app, or work on one, I would love to hear from you. Where the safety and security of your customer's data is paramount, how do you secure it and back it up? I would love to know your ...
0
votes
1answer
219 views

Using rsync to make daily backups every 24hrs

I would like to backup /home/* /root/* and mysql databases to a set of RAIDed drives. Performance wise I want to do incremental backups. Would this be the idea? rsync -al /home ...
0
votes
1answer
55 views

Windows based Mogo database running on EC2 backups

Currently we have a windows 2008 server running a Mongo database hosted on Amazon EC2. Without looking at database replication to another database what can we do to make sure the database is getting ...
0
votes
1answer
169 views

SQL Server 2005: Row in backup, missing in database

I've got a MS-SQL 2005 backup file. When I open with a text editor, despite being binary, I can see some information I want back. Nevertheless, when I restore the backup using MS-SQL studio, the row ...
0
votes
1answer
70 views

Server restarted when I take database backup in SQL Server 2008?

I have 10 databases in my SQL Server 2008. If I take a database backup, 8 databases are working just fine. When I take database backup for the remaining two, at 50% of backup of process, the server ...
0
votes
1answer
156 views

backup berkeley db (java edition)

At the moment I am backing up my Berkley DB databases by taking hard copies of the log/db files periodically. The problem with this approach is that I run out of disk space quite quickly. Is there a ...
0
votes
1answer
339 views

Oracle 10g Failover Database - How to fail back?

I want to know how the failover database concept works after recovery. We have defined our application to connect to a backup database in case the production database fails. If this happens, then all ...
0
votes
1answer
291 views

Maintenance Plan Reporting - Append To File - Clean Up?

Background: (SQL Server 2005, Standard Ed.) I have a maintenance plan running backups, taking a full backup 1/day, and t-log every 15 minutes. I have it set to create a text file report of each run, ...
0
votes
1answer
134 views

How to do a database backup in DB2 in Vista?

How to do a database backup in DB2 in Vista? Whenever I issued this command (login in Vista as Administrator): restore database myDB from D: taken at 20081013134446 the command line processor ...
1
vote
0answers
41 views

Backup RHEL 5 Web Server Disk and DB Data to USB Drive, Best Way to do this?

We are using a dedicated web server with Redhat Enterprise Linux 5 installed, we are using this to host a couple of our websites. We asked our host to attach an external USB hard drive to our server ...
1
vote
0answers
88 views

Effective backup and archive strategy for database and linked files

I am using Postgres to store a variety of application data for a webapp. Part of the application involves storing and retrieving user uploaded files. I am storing the files in the filesystem with ...
1
vote
0answers
922 views

How do deal with SQL Server transaction log corruption

We had a failure with our SQL Server log shipping job. sp_readerrorlog reported: Backup detected log corruption in database X. Context is Bad Middle Sector. LogFile: 2 'D:\Database\X_log.MDF' VLF ...
0
votes
0answers
13 views

MySQL-ZRM: net_write_timeout

I have a backup system using MySQL-ZRM. Since I have some growing tables on a few databases and I write everything to a NFS, backups are now failing. I suspect the problem here is net_write_timeout, ...
0
votes
0answers
26 views

SQL Server database backup to Windows Azure Recovery Service

I have some VMs on Windows Azure and IIS and SQL Server 2012 is installed on them. I also created a Backup Vault on Windows Azure and installed the Windows Azure Backup Agent on the VMs. It works ...
0
votes
0answers
15 views

Exchange 2010 logs

Exchange 2010 sometimes doesn't delete its logs after full backup completion! Usually, we we just delete these logs (and we didn't face any problem because of that) However; is there another way to ...
0
votes
0answers
25 views

Database and Source Code auto back up

We have more have more than ten server(windows 2003 ) system . Each server have more than three web sites. I had create the sql job to auto back up process. Then copy the back up files into external ...
0
votes
0answers
17 views

Access Denied to Database Information_Schema

I have an SQL dump that is around 70GB in size with over a thousand databases inside of it. I am attempting to import it via command line, however I receive the error message... Access Denied for ...
0
votes
0answers
60 views

SQL Azure automated export fails silently

I have a database in SQL Azure that's configured for a daily automated export but the export never occurs. I've tried turning off automated exports and re-enabling it, changing the time of day and the ...
0
votes
0answers
37 views

SQL Server 2012 backup Maintence plan per dataabse

I am using Ola's maintenance solution. New Senior DBA wants me to use native maintenance plans for user database backups. One maintenance plan per database. So on one server it would be 20 backup ...