Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [database-backup]

251 questions
0
votes
2 answers

SQL Server 2000 Transaction Log DelBkUps 3DAYS not working

We have a maintenance plan to do a full backup every night at midnight and a transaction backup every hour. Both have "Delete backups older than 3 days" checked in the wizard Here's the SQL from the Job: EXECUTE master.dbo.xp_sqlmaint N'-PlanID…
Rob Stevenson-Leggett
  • 613
  • 2
  • 7
  • 20
0
votes
0 answers

How to backup/restore a large MongoDB database?

How can I backup and restore a large mongodb database (500GB) from a server running an older version (v2.6) than the target one (v3.6)?. The downtime is critical. We've tried by making a straight copy of the data files as well as filesystem…
Miguel Santos
  • 1
  • 1
0
votes
1 answer

Backing up OpenLDAP in Windows environment

I need to find a concept how to backup OpenLDAP data (the data directory) in a windows environment. I googled around a bit and found: https://github.com/elmar/ldap-git-backup. But this framework is for Debian environments. Does anybody know a…
Billie
  • 3
  • 2
0
votes
1 answer

How to take backup of 500GB SQL database data?

We tried to copy 500GB data to local drive using copy option in SQL management studio but it getting failed after 2 or 3 hours...is there any size limitation to copy? How much size script file should be if we take for 500 GB database? Please let me…
bhuva nesh
  • 1
  • 1
0
votes
1 answer

Is it possible to restore postgres database with a non-DBO user?

I'm struggling with finding an appropriate backup / restore method for my postgres databases. My requirements are these: DB owner is a non-superuser account. it only has "can login" and "inherit parent role rights" privileges. backup should be…
velis
  • 233
  • 2
  • 10
-1
votes
1 answer

Does anyone backup SQL Databases >= 4Tb instead of replication?

So the question is in subject. Backing up SQL database is very time consuming procedure. How anyone make backups for such huge SQL databases? I'm not about specific instruments but "architecture" of such thing.
GarfieldCat
  • 101
  • 3
-1
votes
4 answers

How to mysqldump last 10 rows for EVERY TABLE in a database?

I have seen a lot of articles about "how to mysqldump last 'n' rows from a table in a database". For example: mysqldump --user=superman --password=batman --host=gothamcity.rds.com --where="1=1 ORDER BY id DESC LIMIT 10" DB_NAME TABLE_NAME…
Rakib
  • 121
  • 1
  • 9
-1
votes
1 answer

Backup and Restore MySQL database

need backup MySQL 5.1 databse. Database is install on Windows Server 2003. I google it and I found many tools but I am little confuse what choose. My requirments are: Tool for backup must have a GUI It would be good if support only backup, without…
TOM
  • 11
-1
votes
1 answer

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

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 taking there DB Backups?
OM The Eternity
  • 111
  • 1
  • 8
-1
votes
2 answers

Downloading Database dump from server

I have a mysql database on a server that is around 4 gb in size and I couldn't get it downloaded to my local machine. I tried getting a dump on the server, but the dump is not getting created probably because of the big size. Is there any way, I…
Ctroy
  • 101
  • 1
-6
votes
1 answer

Database Backup using DOS commands or any other useful commands

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 backup should be held every day at 1 : 00 AM…
user228757
  • 3
  • 2
1 2 3
…
16
17