Questions tagged [database-backup]
251 questions
1
vote
1 answer
Individual Customer Backup from Multi Customer DB
We have a multi customer database, that's about 95gb in size. One of the customers is requesting a monthly backup of their data. We have a script that strips out all records from all tables that are not related to the specified ID.
So we restore…
HarleyP
- 13
- 2
1
vote
1 answer
Auto backup mysql database in phpmyadmin
Can i backup the mysql database automatically every week like scheduled job in local Phpmyadmin.
if possible i would like to take the each database separate file.Is this possible !
Thanks
Gowri
- 113
- 1
- 5
1
vote
3 answers
What's the most efficient way to reclaim disk space after deleting lots of data from a database on Sybase ASE 15?
As I understand it, based on some research but zero real-world experience with Sybase ASE, the only way to reclaim disk space once it's been allocated to a database is to export that database, create a new DB with the same schema, and reload all the…
Ernie Longmire
- 11
- 2
1
vote
2 answers
Is it possible to export a database without its Users?
Is it possible to export a SQL Server database (data, structures) without its users ?
If yes, is it possible using SSMS ?
Spilarix
- 125
- 5
1
vote
4 answers
Backup SQL Server DB to a remote drive
I am trying to backup a SQL Server database to another drive letter located on another network on another domain. The location has already been mapped to Z:\ and corresponds to \\10.98.76.6\Backups\. This is the code I have so far in an SQL…
Jean-François Beaulieu
- 465
- 4
- 9
- 18
1
vote
1 answer
Error in moving Backup file
I have created a backup file by SQL query like this :
BackUp [DBName] to disk=N'Backup path'.
now i want to move it to another folder.but i recieve this error:
Cannot copy 'Backup file name':Access is denied. Make sure the disk is not full or…
M_Mogharrabi
- 21
- 1
- 4
1
vote
3 answers
What database backup utility should I use?
Can anyone recommend a database backup utility, free or paid? Ideally it will
backup MSSQL & MySQL, but MSSQL only will suffice
allow backup of single tables
encrypt backups
Many thanks
Mr. Flibble
- 723
- 3
- 13
- 23
1
vote
2 answers
MySQL Backup Software
What are the best software packages for automated backups for MySQL? Even more important than how easy the backup process is would be the restore process. If I ever get in a bind with data corruption or a failed device, I want to be able to…
dingalingchickenwiing
- 333
- 1
- 2
- 9
1
vote
4 answers
Mysql Backup Solution
I would like to backup my mysql server remotely. I have three problems, and one requirement.
I do not have enough space in my server. I can only keep one copy of backup in the local server
I do not have good connection. I can only upload 1MB per…
myton
- 11
- 1
1
vote
1 answer
will mysqldump lockout select or read only based queries
i have a large database to backup nightly and we currently do mysqldump on the master server which locks all inserts when dumping
we use a master slave mysql setup with magento configured to send all writes to the master and all reads to the slave.…
anthonysomerset
- 4,233
- 2
- 21
- 24
1
vote
1 answer
Back-up Appliances and how easy they really are
So currently I am looking at a few options to improve my company's back-up solution and I stumbled across a few ideas and quotes regarding the following:
HP x1000 G2 Network Storage System
Dell PowerVault DL2200
Now, these both seem great, and…
Tablemaker
- 1,149
- 1
- 11
- 23
1
vote
0 answers
How do deal with SQL Server transaction log corruption
We had a failure with our SQL Server log shipping job. sp_readerrorlog reported:
Backup detected log corruption in database X. Context is Bad Middle Sector. LogFile: 2 'D:\Database\X_log.MDF' VLF SeqNo: x3f116 VLFBase: x1ede0000 LogBlockOffset:…
Daniel Bowen
- 41
- 1
- 6
1
vote
3 answers
Is it possible to make a backup of a MS SQL database from a linux command line?
Is it possible to create a local backup file of a remote Microsoft SQL Server database, from a linux command line?
I know I can use SQLCMD from a Windows command line, but is the same possible from a linux box?
Andrew
- 185
- 2
- 3
- 10
1
vote
2 answers
Frequency of SQL Server full backups vs. diffs
I have a SQL Server located in a colo center. Currently, our database is about 100Gb. Log files average about 500Mb/day, and differential backups grow by a bit less than that.
My current disaster recovery plan is: have a full backup elsewhere,…
Eric H.
- 133
- 3
1
vote
2 answers
Using LVM Snapshot To Backup Database Servers
Could we use LVM snapshots to backup database servers?
Or we can only use it for file system backups?
Majid Azimi
- 547
- 1
- 13
- 29