Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [database-backup]

251 questions
0
votes
1 answer

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 there must be some kind of permission issues…
blade
  • 113
  • 4
0
votes
4 answers

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 cheapo built-in backup solution, including that…
Bigbio2002
  • 2,823
  • 12
  • 35
  • 54
0
votes
0 answers

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 that I can attach to Task Scheduler to take backup…
Yash Saraiya
  • 103
  • 6
0
votes
2 answers

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 running seven sequential commands on the…
BMM
  • 191
  • 5
  • 10
0
votes
1 answer

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 command from mysql doc mysql> FLUSH TABLES WITH READ…
rajkumarts
  • 103
  • 2
0
votes
2 answers

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 connect trough one ip (my ip, obviously). How i do…
Santiago Mendoza Ramirez
  • 131
  • 8
0
votes
2 answers

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 MySQL server with a few databases & tables. I need…
Imre Szalai
  • 1
0
votes
0 answers

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 Postgres's Streaming Replication. It does all that I need…
eje211
  • 117
  • 6
0
votes
1 answer

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 working reasonably well, I am having difficulty…
egmackenzie
  • 101
  • 4
0
votes
1 answer

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 command ldapadd -x -D "dc=admin,dc=domain,dc=lcl…
Neel
  • 111
  • 2
  • 5
0
votes
2 answers

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

Basically, what I did is: mysqldump -uroot -pxxx --result-file Backup.sql --databases mysql customappdb Is it sane to later do mysql -uroot -pxxx < Backup.sql Or do I need to take special precautions? I'm running 5.1.73-community.
JCCyC
  • 680
  • 3
  • 13
  • 24
0
votes
2 answers

SQL Server - remove a primary logfile without downtime

I have a MDF and LDF on the same drive, and the drive is almost out of space. I have a second drive in the same server, and I'd like to move the LDF file to that drive. I know that I can detach and re-attach, but that involves downtime, and I'd like…
SqlRyan
  • 906
  • 5
  • 14
  • 22
0
votes
1 answer

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 backup to a folder on the local computer (the same…
Peter Lange
  • 107
  • 10
0
votes
1 answer

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 all the database files (files in dbpath) to our…
Pablo Torrecilla
  • 77
  • 1
  • 11
0
votes
1 answer

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 well to backup the websites but not the…
Cloudlucky
  • 31
  • 4
1 2 3
…
16 17