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

how to restore sql server database without store procedures?

I made a full database backup. I wanted to restore this database in another distant machine. However, database restoration failed with: Msg 7202, Level 11, State 2, Server MySERVER\SQLEXPRESS, Procedure _SBOF_FOO1, Line 17 Could not find server…
dev4life
  • 10,785
  • 6
  • 60
  • 73
0
votes
2 answers

backup of datastore to local machine

I have some data stored in the Google Datastore. I have two entities in the Google Datastore for this purpose. I was wondering if there is a way to backup these Datastore entries periodically to my local machines ? I searched the internet and…
Rohith D Vallam
  • 11
0
votes
1 answer

"LastBackupTime" importance for SQL Backups

I have been building an application to Backup SQL Databases using VDI using SMO. I have a doubt whether i should be capturing the last backup time of a database along with the LSN or simply, just capture the LSN. More precisely, i wanted to take…
PanDe
  • 831
  • 10
  • 21
0
votes
1 answer

How to backup database to device?

Export and import .db file to my device. Hello! I'm a little bit new on programing and i learned how to create a database on my application. so i created a database table with alot of data and every things working fine. Is it possible to backup the…
Matan
  • 296
  • 5
  • 24
0
votes
0 answers

Move Oracle11gXE 32bit DB to Oracle11gXE 64 bit version

Firstly, I am not a DB Administrator. I had an issue wtih APEX installed in my Oracle11gXE 32 bit version. So, taking this as opportunity, I uninstalled this (took a backup of oraclexe folder) and installed Oracle 11gXE 64 bit version. Now I need to…
Uma Ilango
  • 968
  • 4
  • 16
  • 31
0
votes
2 answers

Do I have to prevent users from writing or reading the database when I try to backup the database

I'm going to use a cron job to backup my database and wonder whether this process would affect the users communicating with my website, like post or read contents from my website. Do I have to prevent the user from reading or writing data to my…
Kesong Xie
  • 1,316
  • 3
  • 15
  • 35
0
votes
2 answers

Sql Server Backup to URL (Azure)

I'm trying to take advantage of the new backup to url function in SQL Server. I have created a valid cert and tried a simple backup, but I get the same error every time no matter what I try. I have also tried creating a new managed backup. With…
Eulalie367
  • 198
  • 4
  • 17
0
votes
1 answer

Is a sqlite3 online backup valid in a running transaction without the journal file

I used the backup API of sqlite3 to create online backups of my sqlite3 databases as described in Example 2. Sqlite3 saves additionally to the database a journal file in case of a transaction to make the rollback possible. It seams as if this leads…
evotion
  • 265
  • 2
  • 13
0
votes
1 answer

java.io.IOException: exception - While restoring DB in Sql Developer 4.1

I am facing a problem while restoring database of size 8.14GB in Sql developer4.1 in Oracle 11g r2. It's giving error of java.io.IOException. like this- java.io.IOException: exception loading F:\PROJECTS\NJ_State_iCare\ICARE_BACKUP.sql at…
Yogi
  • 31
  • 1
  • 3
  • 8
0
votes
0 answers

What data should/should not be backed up for django website using python-social-auth ? Which sets of data are sensitive?

For a django site implementing python-social-auth to enable login, exactly what should be backed up and what should NOT be backed up? Should the entire tables created by social-auth be backed up? or should only certain data be exported and backed…
sky
  • 2,531
  • 4
  • 17
  • 15
0
votes
1 answer

dumping larg database backup or splitting large sql files into smaller parts to dump

I have a backup file from a big database. its about 85Mb in gzip format and 1.5Gb in sql format. Now I want to import it in my local database. but no phpMyadmin and nor Naicat for Mysql can't do it. So i want an application to split it to smaller…
MAli Fahimi
  • 195
  • 11
0
votes
1 answer

Get the actual DB size from the backup file without restore

Is there any way to get the size of the DB without restoring a backup file? For example: I have a backup file of 10 GB, I want to know the size of the DB after the backup file will be restored. Most of the times the DB size is much larger than its…
pritamS
  • 127
  • 1
  • 10
0
votes
1 answer

Turning off local db backup with rubber, while still backing up to S3

I've uncommented the backup_bucket: line in rubber.yml, and now my db gets backed up both locally and to my S3 bucket. I would like to have my db only backing up to S3. Is there a way to disable local backup, while still keeping S3 backup?
Marina
  • 3,222
  • 5
  • 25
  • 35
0
votes
1 answer

Find specific transaction in SQL differential backup

We have a MSSQL server that is backed up daily with a full backup at 0000 and with a compressed differential backup every 15 minutes from 0010. Between Aug 10 and 11 our site was hacked and all data from one table was deleted (table was not…
user1480192
  • 665
  • 8
  • 23
0
votes
1 answer

How can I import an existing database to my db.py model?

I have successfully changed the default sqlite connection to mysql. Now I want to import an exported file (database.sql) which is an existing database. I need help on how I can do this please
Gideon George
  • 1
  • 3
1 2 3
…
99 100