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

How to take backup of sql server 2012 database from network computer

I'm using sql server 2012 and windows server 2008 R2 on my server machine. And windows-7 and sql server 2012 on network computers. I were made a user for sql server 2012 (server machine). From that user i am able to connect with the database server…
Ashish Rathore
  • 2,546
  • 9
  • 55
  • 91
0
votes
2 answers

How to copy tables from a database into another database in SQL Azure?

We made two backups from a database that needed changes in many tables, one is an exact copy of that database and the other is a BACPAC file. The new model for the database is ready but I was wondering, how can I copy the contents of the tables we…
Uriel Arvizu
  • 1,876
  • 6
  • 37
  • 97
0
votes
1 answer

Backing up large datastore kind (1TB+) to google cloud storage

Has anyone been successful in backing up large datastore kinds to cloud storage? This is an experimental feature so support is pretty sketchy on the google end. The kind in question we want to backup to cloud storage (ultimately with the goal of…
Jesse
  • 8,223
  • 6
  • 49
  • 81
0
votes
1 answer

PostgreSQL: How do I backup database with name A and load it to database with name B?

I have two databases on the same server. One named A and one named B. Booth databases have the same structure. I want to empty database B and load it with data from database A. Which is the best way to do this? I have tried to take backup of…
David Berg
  • 1,958
  • 1
  • 21
  • 37
0
votes
1 answer

Smbclient put can't find my local drive?

I'm trying to make a backup of my database to another hard drive using PHP/Samba. But it doesn't work and I'm stuck. $dbBackup = 'backup_location.gz.des3'; if (!file_exists($dbBackup)) { throw new Exception("Today's backup does not exist!" .…
Robert Broersma
  • 790
  • 1
  • 7
  • 24
0
votes
1 answer

GAE data upload (seed and backup/restore)

Due to the frequent changes in GAE platform, I read different articles and bit confused what is the best way to export/upload data in year 2013. Bulk Upload tool is not really meant for High Replication Store as per the doc. This document applies…
bsr
  • 57,282
  • 86
  • 216
  • 316
0
votes
1 answer

Backup ACCESS Database using PHP script

Is it possible to back up an access database? I have done research on how to backup access database through php but I wasnt able to get a good answer. Most of the result that came out is about backing up MySQL database. Can anyone help me :) thanks
lexter
  • 225
  • 1
  • 4
  • 14
0
votes
2 answers

sqlserver backup using c# getting issue

I want to create backup of particular database using C# code, and for that I am using following code. Code Console.WriteLine("Backup manager"); Backup bkpDBFull = new Backup(); bkpDBFull.Action = BackupActionType.Database; …
Sagar Upadhyay
  • 819
  • 2
  • 11
  • 31
0
votes
1 answer

MongoDB. Keep information about sharded collections when restoring

I am using mongodump and mongorestore in a replicated shard cluster in MongoDB 2.2. to get a backup and restore it. First, I use mongodump for creating the dump of all the system, then I drop a concrete collection and restore it using mongorestore…
Lucia Pasarin
  • 2,268
  • 1
  • 21
  • 37
0
votes
2 answers

Export SQL database (all tables) from remote server

I'm current using a 3rd party product, which uses an SQL Server database. I've been asked to take a copy of the database for our own backup/security purposes, but I'm having trouble. To access the database I'm currently logging into one of my…
QMKevin
  • 1,101
  • 3
  • 13
  • 26
0
votes
1 answer

SQL Server 2000 backup recovering on SQL Server 2005

I've got a SQL Server database backup (file extension .bak) from an project of 12 y/a which I tried to restore on SQL Server 2005. But this gave me an error that it was not the right version.. So I'm trying to find a SQL Server 2000 version to see…
Ziras
  • 27
  • 1
  • 7
0
votes
2 answers

Recover database with no backups

I want to know if there is a way to revover the state of a database at a certain date. Unfortunately I don't have a backup.
Simone Spagna
  • 39
  • 1
  • 4
0
votes
1 answer

How to restore a .bak file on a remote Win7 system, which I have limited permissions at?

We have an old project which is planned for an upgrade, and now as a seed, we took the backup of the whole database which is in a remote location. I saved it in my remote desktop, which I have limited permissions. I tried to use SQL Server…
dileep
  • 11
  • 2
0
votes
1 answer

Check number of files in directory and if equal or more than 5 - remove the oldest one

I'm trying to create a cron job to create mysql backups. I would like to be able to first check how many files are there in the directory and if there are 5 or more remove one (the oldest) and create a new mysqldump. I know how to create the…
Spencer Mark
  • 5,263
  • 9
  • 29
  • 58
0
votes
0 answers

SQL Server Agent Job - backup certain tables

I am trying to create a SQL Server Agent Job which performs the following functionality. Creates a '.bak' file containing a backup of a set tables from within a database. Zips this backup with a filename of something like "Database_20130111"…
swade1987
  • 1,663
  • 5
  • 21
  • 28
1 2 3
…
99 100