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
1answer
29 views

AutoMySQLBackup: Create a single file for each database

I'm backupping my databases with automysqlbackup. This works fine - but unfortunately I do not get a single file for each database but a cumulative file called ...
0
votes
0answers
47 views

Backing Up Multiple SQL Databases to Network Share at the Same Time

Junior SysAdmin/accidental DBA here so apologies in advance for the noob question. The previous DBA here had a SQL Backup Maintenance Plan that he would copy across 20+ database servers and have all ...
0
votes
0answers
1k 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 ...
1
vote
2answers
55 views

How to do offsite AWS RDS PostgreSQL backups?

As a measure to mitigate against catastrophes such as a malicious entity gaining full access to our AWS account and deleting everything, I am in the process of setting up offsite backups for our ...
0
votes
1answer
19 views

bacula catalog backup error

I have a Bacula (mysql) server on an Ubuntu-server machine. It backs up and restore without issues except for the catalog. Every time it runs the catalog backup it shows an error. My guess is that ...
1
vote
1answer
121 views

Configured Azure Backup sends me a health check report every 15 minutes

I configured my SQL Server 2014 database to back up to an Azure storage account. I also enabled email notifications via EXEC msdb.smart_admin.sp_set_parameter @parameter_name = ...
0
votes
4answers
32 views

How do I perform an Exchange 2010 database backup using Windows Server Backup with Hyper-V VMs collocated on the same drive?

Yeah... I'm not the one who set it up. I've been tasked with setting up backups for their Exchange data. I've read through the documentation and learned about all the caveats that come with using the ...
0
votes
0answers
22 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
2answers
89 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
311 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
0answers
48 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
9 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
92 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
208 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
189 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
43 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
62 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
53 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
62 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
106 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 ...
2
votes
2answers
178 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
73 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
94 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
756 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
13k 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
37 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
113 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
85 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
764 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
508 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
16 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
224 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
387 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
531 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
345 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
701 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
220 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
434 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
617 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
116 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
155 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
554 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
105 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
1k 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
8k 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 ...