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
Questions tagged [database-backups]
1580 questions
0
votes
1 answer
How to maintain login capabilities to a SQL Server 2008 database after a backup/restore across servers?
I have the need to frequently transfer databases between servers using a backup/restore procedure. I am running into the problem where the login information is not maintained when restoring and would like to prevent this from happening.
Here are the…
RacerNerd
- 1,579
- 1
- 13
- 31
0
votes
3 answers
SQL Import/Export by using MYSQL command line
Currently I am use Wamp server and PHP Platfrom and we want sql dump for my database;
I am used below command for export/dump of MYSQL database.
1.mysql> mysqldump database1 > d:/database2.sql;
2.mysql> mysqldumo database1 > d:\database2.sql;
Both…
v_kovit_v
- 34
- 6
0
votes
1 answer
Drawbacks of marked transactions in TFS 2010 backups
I wanted to see if you guys are utilizing marked transactions in your TFS backup scenario. Are there any drawbacks or gotchas to consider for this?
Steve L.
- 1,098
- 13
- 23
0
votes
0 answers
Neo4j enterprise edition 1.8.3 (embedded) online backup using Java
I am using Neo4j 1.8.3 enterprise edition. I tried to do the online backup using Java like below
val backupPath: File = new File("D:/neo4j-enterprise-1.8.3/data/backup/")
val backup = OnlineBackup.from( "127.0.0.1" )
if(backupPath.list().length >…
yAsH
- 3,367
- 8
- 36
- 67
0
votes
0 answers
MongoLab strategies for restoring a database that has people currently using it
My site runs on MongoDB and I'm using MongoLab as a host for the database. I have 10-15 people using the site at any given time and would rather not 'switch them off' if at all possible.
If I have a MongoDB dump that I'd like to restore, it takes a…
JVG
- 20,198
- 47
- 132
- 210
0
votes
1 answer
transaction log backup file size
After setup transaction log backup on sql server 2012, log file size still growing and when I shinked log file still same size. If I assign max file size to log file what will happen? how can I prevent to grow log file size then 1 gb.
or what is…
0
votes
1 answer
how much time does it take to backup 100gb database with RMAN and expdp?
how much time does it take to backup 100 GB database with RMAN and expdp?
I want to take backup of the system before applying the partitioning activity. In case of error, backup data restore immediately.
Mayur Sawant
- 51
- 1
- 7
0
votes
1 answer
Restore DB in Full recovery model when there is no backup
Suppose I want to restore a database in such circumstances: from one side there is no backup,
from the other side - all the changes are stored in the log file.
Can I restore the database from the log file to a specific date & time?
Geri Reshef
- 397
- 1
- 6
- 17
0
votes
0 answers
DB Restore from directory with pgAdmin
I want to restore/import a postgreSQL DB, that i have stored several months ago.
I stored the DB in directory and not in a *.backup file those days.
The directory has lots of files like xxxx.dat.gz, but i can't choose any option like
"from…
Christian Einstein
- 33
- 1
- 6
0
votes
1 answer
PostreSQL: export column2 to be the contents of a new file, where the filename is column2
I need to pull out some data from a PostgreSQL database - namely some old "lost" functions.
I've got a select statement which pulls up the function name as column1, and the function definition as column2.
Is there any easy (or, for that matter,…
Jon Story
- 2,881
- 2
- 25
- 41
0
votes
2 answers
Restore file group backup of a database on to another existing database in same server
I have taken file group backup of SampleDB database and I want to restore it on to a different existing empty database RestoreDB. I was able to restore a full backup but I am having problem while restoring a file group backup.
Here is what i have…
chaitanya.moguluri
- 240
- 2
- 8
0
votes
1 answer
Exporting partial tables (deep copy) from DB maintaining the relationship in RDBMS
We have RDBMS that stores data in a normalized format .
1) What is the best format for import export from one DB to another assuming it might have binary data too ? Perhaps XML would be good ? XLS has 2 draw backs of each cell restricted to 32K and…
Nishant
- 20,354
- 18
- 69
- 101
0
votes
1 answer
SQL server Full backup job is skipping databases
I have a monthly job running on my SQL server.
It backups all the online databases to a location "\Backupserver\e$\MonthEndBackups\".
Job runs the USP below like this: exec [usp_dba_BackupDatabases] 3
(http://screencast.com/t/l7IS5TZK)
It runs on…
Rainmaker
- 321
- 3
- 15
0
votes
0 answers
SQL server backup job is skipping databases
I am having issues with backup jobs. I have a job that runs and backup all the online databases (around 25 database ranges from 3 TB to 10 MB in size).
When these databases were in different servers, the FULL backups worked fine.
But after we…
Rainmaker
- 321
- 3
- 15
0
votes
1 answer
Copy SQL MDF file
I'm trying to get a copy of an MDF file but coming across the standard "file is in use" message which I believe is the SQL service holding a lock on it. Is it possible to make a copy of the mdf file without having to stop the service or in any way…
KrustyGString
- 903
- 2
- 13
- 32