Stack Overflow
Stack Overflow

Questions tagged [database-backups]

database-backups are intended to preserve data by serializing database tables to a text format or exporting them to a binary format

database-backups are useful for archiving, upgrading, replicating, and migrating data

References

1580 questions
0
votes
0 answers

Copy .bak file to another Windows server

I have .bak files that created by a job on SQL Server every night. I want the .bak file to be copied to another server. I created a job running the command EXEC xp_cmdshell 'copy "G:\Source\folder\file.bak" "\\destination\Work\folder\"' but the…
Zeze
  • 11
  • 1
  • 5
0
votes
1 answer

How to test transaction log shipping

We are a small division of a larger company and we are required to keep a server at the corporate office as a disaster recovery server. I want to use SQL's (2005) transaction log shipping feature to keep the offsite server up-to-date. The problem…
VinPepe
  • 561
  • 1
  • 4
  • 9
0
votes
1 answer

hsqldb no change after backup restore until restart

I'm running hsqldb in server mode and connecting to it through Java. After I try to restore a from a backup via org.hsqldb.lib.tar.DbBackup --extract the DB files are replaced properly, but the connection seems to only be able to access the…
z3po
  • 119
  • 1
  • 6
0
votes
1 answer

Taking selective backup in mysql

I have a mysql database with a table that has a data for over 6 months which goes to 1.5 GB of data . I want to take a backup of only 4 days .And then put that in some other database in the same system. Please suggest me how can i take a selective…
user1896796
  • 731
  • 3
  • 9
  • 25
0
votes
1 answer

sql server 2012 mirroring setup after multiple backups

during the setup of the mirroring database in sql server 2012, i accidentally made 2 backup of the original database. after restoring the database on the mirror server, the databases were not synchronized. to solve the issue, i changed the recovery…
user2542655
  • 3
  • 1
0
votes
1 answer

What do the "drop table" and "create table" options in this backup script do?

I need a script to back up a MYSQL database that I don't have cpanel, shell, or phpmyadmin access to. I'm just concerned about the DROP TABLE part of this script and why it would be needed. I do not want to modify the database at all, I just want a…
ryanwinchester
  • 11,737
  • 5
  • 27
  • 45
0
votes
1 answer

Mongo Import on a Production DB

I have a production system which is running with thousands of user profiles. These profiles were added by us at the time of launch after which users have added/updated more data into it. Now, we are planning to add around 20K more profiles into the…
user996048
  • 123
  • 2
  • 13
0
votes
1 answer

Aerospike clrestore2 fails

I have created backup with clbackup2, backup created successfully. But when I try to restore it with clrestore2, it fails with segfault: # /opt/citrusleaf/bin/clrestore2 -d spike -t 1 -u -v restoring: host 127.0.0.1 port 3000 from directory…
maxvgi
  • 31
  • 1
  • 8
0
votes
1 answer

How to create a MySql Job to create a database backup and a maintenace plan?

How can I create a MySql Job that runs daily to generate a database backup and stores in on the server? Also How can I create a second Job that does a maintenance on the database to keep it running without problem? Thanks
Mike
  • 2,735
  • 11
  • 44
  • 68
0
votes
1 answer

mysqldump --delete-master-logs safe for replication?

I have the following backup scheme on my server: Every day I run "mysqladmin flush-logs". Weekly I run "mysqldump --single-transaction --flush-logs --master-data=2 --delete-master-logs > ..." Since recent, I've added a slave server with normal…
Dmitri Pisarev
  • 1,114
  • 12
  • 31
0
votes
1 answer

Make sure .bak-file is ready after MS database backup

I tried to copy a .bak-file to the local machine directly after the backup on the server finished. I never had any problems with that while testing and debugging, but after deployment I got a lot of FileNotFoundExceptions.
Drasive
  • 321
  • 1
  • 20
0
votes
1 answer

Batch export of multiple mysql databases

I am trying to make backups of my 15 MySQL databases on my web server. This list of databases will continue to grow with my (hopefully!) increasing client base. Obviously, I can do a mysql dump with this command: mysqldump --add-drop-table -h host…
ryvantage
  • 13,064
  • 15
  • 63
  • 112
0
votes
1 answer

SSIS Back Up Database Task Failed in Winform Only

I have this weird problem with my SSIS package, it works fine in BIDS, works fine as a SQL Agent Job, but as soon as I run in within my winform using Package.LoadPackage, the Back Up DataBase Task magically failed. I put a data flow task before and…
Mike Zhang
  • 62
  • 8
0
votes
1 answer

Script error: SQLCMD: Incorrect syntax near the keyword 'with'

When it came to getting tasked with ensuring the backups are in place, I was a little worried because we are using SQL Express and found out that there really isn't a way to manage that without a bit of scripting involved. I am ok with scripting in…
Randall.Cummins
  • 426
  • 1
  • 8
  • 20
0
votes
1 answer

"Restore-SQLdatabase" Login failed for NT AUTHORITY\ANONYMOUS LOGON

I have a powershell script for DB backup/restore. For some reason I am executing the script remotely using new-pssession and invoke-command. I am 1.connecting to remote server 2.the local server is in a domain 3.the remote server is in same…
Rahul
  • 76,197
  • 13
  • 71
  • 125
1 2 3
…
99 100