-6
votes
1answer
46 views

Database Backup using DOS commands or any other useful commands [closed]

I am planning to backup my database files from network drive to one other. Here is my requirement: All database should be backed up excluding certain file names starting with msdb, model etc. this ...
-1
votes
2answers
442 views

Postgresql pgdump script on RHEL5: “failed: fe_sendauth: no password supplieddatabase ”

What I'm trying to accomplish is having a pg_dump script run as a cron job. Right now I'm just trying to get the script to run by invoking it myself at the command line. I've searched the postgresql ...
0
votes
1answer
201 views

Is it possible to dump a postgresql db and restore it in mysql?

I'm trying to get migrate data from a postgre db into mysql (mariaDB) and was wondering if it is possible to restore a db in mysql from a pgsql dump?
1
vote
1answer
217 views

Database backup with T-SQL script - Issue with Declare and Set Variables

Can someone tell me why I can't backup my database with the script below? I can run the script but it didn't create the backup. I"m using SQL Server 2008 DECLARE @pathName NVARCHAR(512) SET @pathName ...
1
vote
1answer
843 views

How to export database from Oracle 10g

I'd like to export database with all the triggers, indexes, grants and user accounts from Oracle 10g database. Problem is I only have SYSDBA access to the server, so I can't access the servers files ...
0
votes
3answers
76 views

How to warehouse data that is not needed from MS SQL server

I have been asked to truncate a large table in MS SQL Server 2008. The data is not needed but might be needed once every two years. It will NEVER have to be changed, only viewed. The question is, ...
10
votes
4answers
3k views

Should I backup and restore the `mysql` database?

In the process of creating an automated solution for backing up and restoring an entire MySQL server, I've come across the mysql database which seems to contain user accounts, permissions, metadata, ...
1
vote
0answers
94 views

Effective backup and archive strategy for database and linked files

I am using Postgres to store a variety of application data for a webapp. Part of the application involves storing and retrieving user uploaded files. I am storing the files in the filesystem with ...
0
votes
1answer
236 views

How Gmail and other Mailservice providers must be taking there DB Backups? [closed]

Being Anxious, I thought of asking this question in SO, which will certainly help in getting an idea for how the big DB carriers take their backups. How Gmail and other Mailservice providers must be ...
2
votes
4answers
444 views

Transferring PostgreSQL Database Between Servers

Is it possible to directly transfer a PostgreSQL database between two PostgreSQL servers? I've currently been setting up a "development" version of my production database by using pg_dump to ...
1
vote
2answers
343 views

how to choose backup strategy?

I am DBA of a big online retail company. I am responsible for the availability of the company’s database. The size of this database is 28GB, and it handles an average of 120 transactions every minute. ...
0
votes
4answers
820 views

How to create empty database from existing one (Mysql)

I have a mysql db with many tables. I'm starting a new farm which should contain empty versions of the same database tables. How can I efficiently create empty database based on existing one?
0
votes
4answers
131 views

Inexpensive Hardware for Database Backups?

What hardware would you recommend for saving database backups with the following setup: 5 separate physical hosts, each with one Sql Server 2008 database. Each instance is larger than 200Gb. Each ...