The tag has no wiki summary.

learn more… | top users | synonyms (1)

12
votes
6answers
1k views

Downtimeless MySQL backups on a budget

My current MySQL backup scenario is to replicate our db to a second server and run mysqldump on that server to remove any downtime from table or row locking. This is working well but costs $150 per ...
1
vote
3answers
3k views

Backup SQL Server DB to a remote drive

I am trying to backup a SQL Server database to another drive letter located on another network on another domain. The location has already been mapped to Z:\ and corresponds to \\10.98.76.6\Backups\. ...
0
votes
1answer
206 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
79 views

automatic backup [duplicate]

Possible Duplicate: how to get database backup automatically i want to have automatic backup in my program.it means that for example every 30 minutes a table that contains backup schedules ...
3
votes
2answers
346 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
1answer
210 views

A utility to backup single tables on MSSQL?

Are there any Windows utilities that allow you back up single MSSQL tables? Having a lot or trouble finding any. I hear sqlbackupandftp is good, but as far as I can see, it doesn't back up single ...
1
vote
1answer
32 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
3answers
171 views

What database backup utility should I use?

Can anyone recommend a database backup utility, free or paid? Ideally it will backup MSSQL & MySQL, but MSSQL only will suffice allow backup of single tables encrypt backups Many thanks
2
votes
1answer
266 views

Full, Differential and Log backups of databases, MSSQL an MYSQL

Best I give a back story so you get the full picture. I am in the process of setting up a new business, which hopefully will start in April 2012, and as such I am preparing every aspect of it. One ...
0
votes
1answer
1k views

Error in backup query of SQL Server

I have a database in SQL Server and I want to create backup from it to a shared folder. just one of the network users has permissions to access to this folder. I have written a code to log on this ...
1
vote
2answers
95 views

MySQL Backup Software

What are the best software packages for automated backups for MySQL? Even more important than how easy the backup process is would be the restore process. If I ever get in a bind with data ...
0
votes
2answers
331 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
4answers
413 views

Mysql Backup Solution

I would like to backup my mysql server remotely. I have three problems, and one requirement. I do not have enough space in my server. I can only keep one copy of backup in the local server I do ...
3
votes
3answers
906 views

SQL Server transaction log BACKUPS are very large

In SQL Server 2008 R2 I have a database that has full backups nightly and transaction log backups every ten minutes. The database is in full recovery model. The problem is that the backup files for ...
1
vote
1answer
323 views

will mysqldump lockout select or read only based queries

i have a large database to backup nightly and we currently do mysqldump on the master server which locks all inserts when dumping we use a master slave mysql setup with magento configured to send all ...
1
vote
1answer
71 views

Back-up Appliances and how easy they really are

So currently I am looking at a few options to improve my company's back-up solution and I stumbled across a few ideas and quotes regarding the following: HP x1000 G2 Network Storage System Dell ...
11
votes
3answers
1k views

Is this a valid backup strategy for MongoDB?

I've got a single dedicated server with a MongoDB database of around 10GB. I need to do daily backups, but I can't have downtime with the database. Is it possible to use a replica set on a single disk ...
0
votes
1answer
88 views

MySQL database backups to a local server

We have a backup system at the moment, but after a recent scare, we’d like another backup of just the MySQL databases, nightly, to a local server in our office. The databases are pretty big as it ...
1
vote
0answers
96 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 ...
0
votes
1answer
76 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 ...
1
vote
0answers
1k 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 ...
4
votes
2answers
569 views

Rackspace cloudserver backup options

I recently signed up with Rackspace to host some database servers. I've got two MySQL servers set up, and have a method to create backups (using the Percona Xtrabackup and innobackupex tools). I've ...
6
votes
3answers
1k views

Creating a *Consistent* *Online* MySQL Backup with InnoDB AND MyISAM tables

I just spent hours building a new database server to replace 2 failed servers from a mysqldump file created a month ago, then used my server's bin-logs to bring that mysqldump up to date. Now that I ...
0
votes
3answers
2k views

Is it possible to make a backup of a MS SQL database from a linux command line?

Is it possible to create a local backup file of a remote Microsoft SQL Server database, from a linux command line? I know I can use SQLCMD from a Windows command line, but is the same possible from a ...
0
votes
1answer
252 views

How Gmail and other Mailservice providers must be taking there DB Backups? [closed]

Being Anxious, I thought of asking this question in SO, which will certainly help in getting an idea for how the big DB carriers take their backups. How Gmail and other Mailservice providers must be ...
2
votes
4answers
455 views

Transferring PostgreSQL Database Between Servers

Is it possible to directly transfer a PostgreSQL database between two PostgreSQL servers? I've currently been setting up a "development" version of my production database by using pg_dump to ...
0
votes
1answer
184 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
403 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 ...
1
vote
2answers
138 views

Frequency of SQL Server full backups vs. diffs

I have a SQL Server located in a colo center. Currently, our database is about 100Gb. Log files average about 500Mb/day, and differential backups grow by a bit less than that. My current disaster ...
2
votes
1answer
308 views

SQL Server on EC2: What way do i set up the EBS

Good morning. We have a service with a SQL box on Amazon EC2 and, as suggested on this question, we are using EBS to store the data... the problem is, What is the best way to setup the storage? At ...
2
votes
1answer
206 views

Creating a small .bak file without indexes or excessive log

I recently was asked to ship a .bak file of our database to a client, and through reindexing all tables with a 100% fill factor (to make sure there were no empty slots), and resizing the transaction ...
1
vote
3answers
2k views

PostgreSQL automatic backup

I have been trying to set up a backup script on a windows server. I have used pgAgent (scheduling for pgAdmin), to run the backup script. No problems with the backup script. However, my jobs are not ...
2
votes
3answers
7k views

Incremental/Differential MySQL Backup using mysqldump

Are there any techniques to use mysqldump (or similar command) to make incremental or differential backups for MySQL?
1
vote
2answers
639 views

Using LVM Snapshot To Backup Database Servers

Could we use LVM snapshots to backup database servers? Or we can only use it for file system backups?
0
votes
1answer
53 views

Does SQL Agent need to be running in order to take manual SQL backups?

If we have a situation where SQL Agent fails to start, will we still be able to take a full manual SQL backup? I don't mean scheduled backups and maintenance plans, just plain Right Click > Tasks > ...
0
votes
2answers
34 views

SQL Server backup

I have Full-Backup-A Transaction-Log-Backup-A Transaction-Log-Backup-B (*) - I have to restore this point Full-Backup-B How to do it? It seems that the only way is Full-Backup-A ...
8
votes
2answers
9k views

How do I create a read only MySQL user for backup purposes with mysqldump?

I'm using the automysqlbackup script to dump my mysql databases, but I want to have a read-only user to do this with so that I'm not storing my root database password in a plaintext file. I've ...
1
vote
1answer
149 views

SQL Server 2005 SP3 Express Backups Incredibly Slow

I'm attempting to troubleshoot an issue with one of our customers who's using SQL Server 2005 SP3 Express to house their application data. The automatic backups that we perform when upgrading our ...
4
votes
2answers
2k views

pg_restore taking much longer than pg_dump

I am regularly saving and later restoring a smallish PostgreSQL database, which is used for testing. Its data is updated regularly as a result of tests, then a new dump must be made, and the dumps are ...
2
votes
1answer
916 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
733 views

Best open source Server backup utility with GUI?

I am looking for an open source/free server backup app with GUI (web based front end). Which app do you recommend? I search a little and came up with this list: 21 of the Best Free Linux Backup ...
3
votes
1answer
3k views

Is a MySQL stored procedure able to insert/update to a remote backup MySQL server?

Is it possible to create a MySQL stored procedure that can execute a given insert or update and then also have it connect to a 2nd server and run the same commands? I want to basically call one server ...
2
votes
2answers
2k views

Restoring a slave MySQL database from raw backups of master gives InnoDB tablespace errors

I have a master/slave replication setup where I use InnoDB and MyISAM tables in over 7000 databases that I want to copy from my master to the slave to restore replication. Both servers were running ...
-1
votes
2answers
157 views

Downloading Database dump from server

I have a mysql database on a server that is around 4 gb in size and I couldn't get it downloaded to my local machine. I tried getting a dump on the server, but the dump is not getting created probably ...
1
vote
1answer
133 views

Database backup using sql management studio 2008

I want to retrieve a script for a database that will include operations of creating database, creating tables, and insert all data. How can I achieve this using management studio 2008 please. I have ...
3
votes
1answer
77 views

Looking for automatic backup methods for sites

I need a suitable backup automation script that will run in PHP on my apache server. Some of my sites run Drupal. Which is the most suitable method to automatically backup both the code and the ...
1
vote
2answers
344 views

how to choose backup strategy?

I am DBA of a big online retail company. I am responsible for the availability of the company’s database. The size of this database is 28GB, and it handles an average of 120 transactions every minute. ...
1
vote
1answer
230 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 ...
1
vote
3answers
197 views

basics of SQL Server 2008 backups

We don't have a DBA and I have to do backups. We have only one database that is 3gb (the others are less than 100mb). The 3gb database is write-heavy, and has very important data. I set up daily ...
0
votes
2answers
173 views

SQL Server 2008 import data from SQL Server 2005 backup file

I have a SQL Server 2005 database backup file (.bak), and I want to grab the data of this file and import it to an already existing database. Since the backup file contains database information as ...