The tag has no usage guidance.

learn more… | top users | synonyms

2
votes
1answer
1k 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 ...
0
votes
0answers
13 views

SQL Server Management Studio 2012 DB Backup script

I have SQL Server Management Studio 2012 installed on a VM. We have an active DB (attached to an ASP.Net application whose target Framework is 4.0). What I was looking for is a script to backup a DB ...
1
vote
3answers
62 views

What is the risk of a SQL Server backup strategy that is only weekly full backups and daily transaction log backups?

I'm trying to convince a client that their SQL Server backup strategy is insufficient. Long story short is that their current backup "strategy" is a weekly full backup followed by daily transaction ...
0
votes
2answers
196 views

How to use fsyncLock() safely in backing up a single mongod

I read in MongoDB's official documentation: important: db.fsyncLock() may block reads, including those necessary to verify authentication warning: When calling db.fsyncLock(), ensure that the ...
0
votes
1answer
23 views

SQL Server - Database Transaction Log Backup. Appended or seperate files?

we have 30 productions databases in our SQL server. top big DBs are 60GB, 40GB, 8GB, 5GB and the rest are 1GB or less. we have incremental transaction-log backup set-up currently every-hour by ...
0
votes
0answers
7 views

sqlserver is always mapped to nobody on samba when doing backup to UNC path

I have an issue in the configuration, I guess. Due to the fact that the user is always mapped to nobody, I have to set the chmod for the backup folder to 0666 which is the number of the beast and ...
2
votes
1answer
57 views

Best practices to backup mysql databases

This question concerns best practices for mysql backup with replication and large number of databases. I'm looking for your point of view and suggestions :) I - Current situation I have two ...
-1
votes
4answers
124 views

How to mysqldump last 10 rows for EVERY TABLE in a database?

I have seen a lot of articles about "how to mysqldump last 'n' rows from a table in a database". For example: mysqldump --user=superman --password=batman --host=gothamcity.rds.com --where="1=1 ...
0
votes
2answers
75 views

Backup remote database using mysqldump

I am trying to achieve a quick way to do a backup and download a remote mysql database to my local machine, using just the terminal. The remote server uses ssh keys for authentication. I can do it by ...
0
votes
1answer
17 views

Lock a specific mysql database in shared mysql database

I am trying to migrate a database from one cluster to another cluster. In order to avoid any data loss during the migration, I am trying to lock my database with the WRITE operations. But the lock ...
0
votes
2answers
52 views

Connect by mysqldump to a mysql server only allowing one ip

I have a cloud server with MySQL in it. In this moment, i can't connect from my pc to the server using any of the users. What it want is allow to use mysqldump with an specific user and only allow ...
3
votes
4answers
2k views

Ola Hallengren's SQL Backup to Network Location not working

I have set up Ola Hallengren's SQL Server Maintenance Solution on several SQL Express servers (2008 to 2012 R2) in the past few years. I recently have started having issues with the network backup ...
0
votes
2answers
50 views

Start an uninstalled MySQL server

Our server just crashed after a 140 day uptime reboot (not booting). It was running Plesk and since it's hosted by Online.net, I'm able to run a recovery system and access my data. It was running a ...
2
votes
2answers
40 views

pg_dump compression; Server or Client side

When you are specifying compression on pg_dump, is the compression happening on the server side so that the transfer is quicker or is the pg_dump doing the compression? Thank you
2
votes
1answer
59 views

How to secure the db dump taken from daily run script

In one of my mysql slave servers I have written a daily run script, which 1) stops slave, 2) takes a db dump, 3) starts slave again, 4) encrypts it, 5) copies it to my s3-bucket. I am using aws-cli ...
1
vote
4answers
72 views

reliably write database dump directly to remote filesystem (Linux)

I need to move a very large database (~320 GB) from server1 to server2 (Linux). Because of different extension versions, the database can only be restored on server2 from a dump file as described ...
0
votes
0answers
838 views

Error during Veeam SQL log backup: “Failed to flush file buffers”

My company uses Veeam Backup & Replication to make backups of our VMWare-hosted virtual machines. We use Veeam's SQL log backup feature for our MS SQL 2008 R2 server. Our backup repository resides ...
2
votes
2answers
175 views

Database backup encryption

I've been trying to work out an effective database backup encryption scheme lately. I have a Postgres 9.4 server, I have most of the backup scheme fleshed out I think. Backups will be stored in a ...
1
vote
0answers
58 views

MongoDB fsyncUnlock won't unlock occasionally on Windows

We have a MongoDB replica set installed on Windows servers, with a scheduled backup job. MongoDB is configured to use journaling. The job runs db.fsyncLock() via script on MongoDB (primary server), ...
1
vote
0answers
71 views

What are the limitations of using a scheduled Windows Server Backup instead of SQL Server backups?

We've taken over development and server admin for an e-commerce site, and the client has opted for a well-specced dedicated server, including a second drive for daily Windows Server Backups. However ...
1
vote
2answers
416 views

Automate pg_dump in a bash script

I am re-learning bash after years of not using it very much and need to figure out a way to automate pg_dump of a single database to a directory. Currently I manually ssh into the box, su to postgres ...
2
votes
4answers
12k 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?
0
votes
0answers
33 views

Fallback to backup server upon failure of main server without third machine

I will soon need to setup a database server on a budget. We are planning to use Postgres on Ubuntu (most likely) and we'd like to have a backup server. For replication, I think I'll just use ...
1
vote
0answers
79 views

MongoDB Backup & purge

I'm exploring solutions for a basic dbadmin need : periodically backing up and purging data in MongoDB. Basically, I need a logrotate for mongodb. I have a backend program filling a collection. I ...
0
votes
1answer
71 views

MySQL Cluster ndb_restore fails without error

I have been working to migrate our current single instance database to a new clustered database running MySQL cluster. It is a large database (several billion records) and, while it seems to be ...
-1
votes
2answers
491 views

How to Dump all databases from MySql server with mysqldump without passwords

Is it possible to dump all databases without supplying the username and password for each databe ? The server has 10 databases with different usernames and passwords. I will be logged in as root ...
0
votes
1answer
400 views

ldap_add: Constraint violation (19) additional info: some attributes not unique

Well I have already gone through ldap_add: Constraint violation (19) but couldn't solve my problem! Problem I'm facing is that, when I'm trying to add users from bckup.ldif file by issuing following ...
1
vote
0answers
15 views

Should I back up full-text catalogs?

I am developing a small app for SQL Server database backup (version > 2005). I intend to use VSS snapshots (component based) to back it up and supported modes are Full & differential. Is it ...
0
votes
1answer
192 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 ...
1
vote
4answers
5k 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\. ...
2
votes
2answers
357 views

Will a Veeam 8 Snapshot Backup be be unable to restore my non-quiescable file-based databases if someone is logged in to them at the time?

We have some very old file-based databases (multi-user, but not Server-based) that are running on some VMs on an VMWare ESXi. Setup HyperVisor The ESXi is running ESXi version 5.1.0 Virtual ...
0
votes
2answers
453 views

restore mongoDB databases from manual backup (not used mongodump): strange permission problems

Is it possible to restore databases which were manually copied from /var/lib/mongodb to eg. /home/foo/mongobackup ? I am not sure if the backup was made after stopping the mongod service. Either way, ...
1
vote
0answers
277 views

autopostgresqlbackup postgres authentication error

I am trying to use autopostgresqlbackup on ubuntu on an ec2 instance. I can log in with psql on the command line and it is picking up my .pgpass file and everything looks fine. When I run 'sudo ...
0
votes
2answers
556 views

Can I restore the “mysql” system database along with another from a mysqldump backup?

Basically, what I did is: mysqldump -uroot -pxxx <some_options> --result-file Backup.sql --databases mysql customappdb Is it sane to later do mysql -uroot -pxxx < Backup.sql Or do I ...
1
vote
1answer
197 views

Redhat wal-e installation

I am trying to get https://github.com/wal-e/wal-e installed on a Redhat system. I have been using the pip method to do the installations. I believe I installed all required dependencies and it's still ...
1
vote
1answer
348 views

s3cmd: on-the-fly backup

To do backups I created a script that makes an archive of all the folders I need to backup, sends it to S3 (through s3cmd) and then deletes it after upload has been completed. I'm looking for a way ...
5
votes
1answer
593 views

MS SQL Server DB version without restoring?

Is there a way of telling which version of Microsoft SQL Server a database backup is from without restoring it?
-6
votes
1answer
104 views

Database Backup using DOS commands or any other useful commands [closed]

I am planning to backup my database files from network drive to one other. Here is my requirement: All database should be backed up excluding certain file names starting with msdb, model etc. this ...
1
vote
1answer
119 views

Postgresql: missing data after crash

I've just rebooted my server after a crash/reboot (which I haven't determined the cause of yet). Server: centos, Postgresql: 9.2.8 It looks like all my postgresql databases were reverted to the state ...
0
votes
1answer
513 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
1answer
85 views

SQL Server Backup to Azure Tool

I downloaded and tried the Microsoft SQL Server Backup to Azure tool for SQL Server 2008. My goal was to get access to the backup compression functionality built into it. I have it configured to ...
2
votes
2answers
2k views

Encrypting Amazon EBS Snapshots

Would love it if someone could help me out with this: The setup is a distributed LAMP architecture hosted on Amazon EC2 instances. MySQL Percona. We use Amazon's EBS snapshots for backups. We have ...
2
votes
2answers
963 views

simple script to backup PostgreSQL database

Hello I write simple batch script to backup postgeSQL databases, but I find one strange problem whether the pg_dump command can specify a password? There is batch script: REM script to backup ...
8
votes
1answer
7k views

Why can NT AUTHORITY\SYSTEM create SQL Server database backups?

I have a scheduled task (in Windows Task Scheduler) that connects to SQL Server using SMO (Windows Authentication) and creates a database backup. So far, this task was running under the Administrator ...
0
votes
1answer
473 views

Backup MongoDB database copying files in `dbpath`?

I need a daily backup of all MongoDB databases in our single-instance server (without stopping the MongoDB service). Our server is in Rackspace so I'm wondering if a valid strategy could be just add ...
0
votes
2answers
158 views

MySQL Backup - incremental

I know that you can use mysqldump. I am currently dumping the following way: ${MYSQLDUMP} --single-transaction -u ${MUSER} -h ${MHOST} -p${MPASS} $db | ${GZIP} -9 > $FILE From my understanding ...
0
votes
0answers
33 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
1answer
1k views

postgresql - Approach for 'live'/hot file backup?

Forgive me for the ignorant question, but I see postgres has their WAL logs, and there are talks about using filesystem snapshots, and the WAL with the snapshots may or may not be sufficient ...
1
vote
2answers
857 views

Any issues with filesystem-only backups on PostgreSQL?

I am running my DB server in amazon cloud, and I have the database files on a separate EBS volume. When it comes to backup/restore operations, I found it infinitely simpler to just do a ...
3
votes
1answer
8k views

pg_dump: [archiver (db)] connection to database failed: FATAL: Peer authentication failed for user “postgres”

I'm trying to backup my Postgres DB to another server but I keep getting denied access. my pg_hba.conf file looks like this: # DO NOT DISABLE! # If you change this first entry you will need to make ...