Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [database-backup]

251 questions
1
vote
1 answer

SQL Server 2005 SP3 Express Backups Incredibly Slow

I'm attempting to troubleshoot an issue with one of our customers who's using SQL Server 2005 SP3 Express to house their application data. The automatic backups that we perform when upgrading our application are timing out after 30 minutes, and I've…
Adam Robinson
  • 370
  • 3
  • 6
  • 19
1
vote
1 answer

Best open source Server backup utility with GUI?

I am looking for an open source/free server backup app with GUI (web based front end). Which app do you recommend? I search a little and came up with this list: 21 of the Best Free Linux Backup Software Which ones do you suggest. My requirement is…
zengr
  • 337
  • 1
  • 3
  • 15
1
vote
1 answer

Database backup using sql management studio 2008

I want to retrieve a script for a database that will include operations of creating database, creating tables, and insert all data. How can I achieve this using management studio 2008 please. I have tried the generate script option , but that seems…
Rana
  • 161
  • 1
  • 2
  • 7
1
vote
2 answers

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. my main concern is to minimize the time required…
dani
1
vote
1 answer

How do I backup my customer's data?

If you run a SaaS app, or work on one, I would love to hear from you. Where the safety and security of your customer's data is paramount, how do you secure it and back it up? I would love to know your main host (e.g. Heroku, Engine Yard, Rackspace,…
marc.gayle
  • 205
  • 2
  • 3
  • 9
1
vote
3 answers

basics of SQL Server 2008 backups

We don't have a DBA and I have to do backups. We have only one database that is 3gb (the others are less than 100mb). The 3gb database is write-heavy, and has very important data. I set up daily backups for all the databases but i think that might…
Alex Gordon
  • 455
  • 3
  • 14
  • 31
1
vote
1 answer

How to schedule backups in SQL Server 2008 Web Edition?

I have a SQL Server 2008 Web Edition and I used the Management > Management Plans > Wizrd to schedule the backup of all my databases. I executred the task to test it and I get this error: Executed as user: WIN-343434\SYSTEM. Microsoft (R) SQL…
aron
  • 129
  • 4
  • 13
1
vote
3 answers

website backup: database content reliably matching static content without downtime?

If the server fries and all you have is your last backup, you at least want it to be congruent in itself / of high integrity. Well, I do. What I am worried about is that without downtime, one faces a race between the database dump und the copying of…
Geradeausanwalt
  • 141
  • 5
1
vote
4 answers

How do I restore a database on a remote SQL server 2005 from a local backup?

I have been given access to (parts of) a remote SQL Server 2005 with SQL Server authentication in order to be able to make changes to a database without involving other people who is not working on the project. The database have been created on my…
MatsT
  • 113
  • 1
  • 3
1
vote
2 answers

How should databases be configured for different environments to not lose data

How to configure databases for development, staging and production environments so that there will be no any data loss. Many Applications such as Wordpress, Django, etc... use some database to store data. Now, if I am about to implement such a…
zakadmin
  • 11
  • 1
1
vote
2 answers

Mariabackup error restoring incremental (`This incremental backup seems not to be proper for the target`)

I use mariabackup for creating incremental backups on a previously created full backup directory. The full backup is created using the following command: mariabackup --backup --target-dir=/var/mariadb/backup/ And the subsequent incremental backups…
manifestor
  • 6,079
  • 7
  • 27
  • 39
1
vote
0 answers

Database backup best practices

For my current project, I'm using Aurora RDS and I'm looking for some advice on best practices in terms of backing up the database. My thought is to use AWS Backup to backup the database to 3 separate locations (one in the West Coast, US, one in…
Eric
  • 111
  • 1
1
vote
1 answer

Azure SQL bacpac Restore Over Existing Database

I want to restore a bacpac file over an existing Azure SQL database using PowerShell. Past with experience with restoring bacpac files in Azure requires creating a new database altogether when restoring the bacpac file. I'm looking to avoid that and…
jrd1989
  • 698
  • 15
  • 48
1
vote
1 answer

Backup mysql without causing spike in disk I/O

How would I backup mysql databases without causing spike in disk I/O, so other services using the same disk are not affected by the backup. Backing up to other disk might help, but i was thinking maybe there are ways to slowdown the process so IO…
Alex
  • 21
  • 2
0
votes
1 answer

cassandra backup - errors during compression

My cassandra backup often returns with errors because users move/change it during the compression (we just tar it). Users are logged to the server 24/7 so we can't just change backup hours. I need some ideas/solutions how to avoid those errors or a…
Galmachar
  • 1
1 2 3
…
16 17