Questions tagged [backup-restoration]

344 questions
1
vote
1 answer

Restoring database to a point in time not working

I have a database that is backed up nightly via a maintenance plan I created using the wizard in management studio. The recovery model is set to full. On the 26th something happened and SQL Agent was shut down (or maybe the computer was reset and…
BVernon
  • 391
  • 6
  • 18
1
vote
0 answers

Time Estimate for Backup Recovery with IBM System x3650 M3

I've been doing a little business continuity planning research for myself and I have come to the question of: What is the estimated time for the recovery of about 4 TB worth of data with the use of Windows Server Backup? The system that is to be…
1
vote
2 answers

how to backup a cloud site on rackspace cloud with code and database

i have my website hosted on rackspace cloud server . i need to make backup of code + database of my cloud site. Please give me link of any documentation which suggests steps to perform this or link to alternative method so i can achieve this
Dashrath
  • 115
  • 4
1
vote
3 answers

Automated nightly backup of 1TB drive on Ubuntu Server

How you would set up an automated nightly backup for the whole disk (boot and data partition) running Ubuntu Server? I have a 1TB drive (current usage 200GB) and I want to have daily clone of this drive on another drive (the same capacity and…
takeshin
  • 1,431
  • 3
  • 19
  • 28
1
vote
2 answers

Windows Server 2008R2 Backup Cannot Be Found (Unable to Restore)

I've got a bit of an issue and need some professional advice. One of our servers ended up crashing and I have a backup of the said server (Windows Server 2008 R2). The backup routinely backed up the OS onto an external HDD that sat on a separate…
1
vote
2 answers

MySQL transfer from backups

I had a server die and I have been trying to restore the data onto a new server. I had a mysql database. I have all the files stored in /var/lib/mysql. Each database had a database privileges associated with itself and one other database. This way,…
Sean
  • 115
  • 4
1
vote
5 answers

How to permanently change where MSSQL stores database information?

Using SQL Server Management console for SQL Server 2005 we go to Server Properties --> Database Settings --> change database default location from c:\blah\blah to E:\MSSQL\DATA We restart the server and it should store all new databases in that…
Geo
  • 3,061
  • 11
  • 41
  • 52
1
vote
2 answers

Percona-Cluster: backup and restore procedure

I'm trying to restore a full backup taken from one node of a three-node percona cluster (percona cluster 5.5, galera 2.1, wsrep sst method is rsync, innodb tables only). Backup was taken like this: rm -rf /tmp/backup/mysqldb innobackupex…
Hank
  • 379
  • 3
  • 15
1
vote
0 answers

Duplicity: is it possible to restore files from a backup that has not been updated in six months?

I need files from an old server that ran a daily duplicity backup and was deactivated six months ago. The backup files are store in an Amazon S3 bucket and the last backup was made about six months ago. When I try to restore it using duplicity, It…
cfragni
  • 11
  • 3
1
vote
1 answer

rsnapshot - not correctly archiving mysql databases

My rsnapshot configuration: snapshot_root /.snapshots/ backup /home/user localhost/ backup_script /usr/local/backup_mysql.sh localhost/mysql/ Using this file: NOW=$(date +"%m-%d-%Y") # mm-dd-yyyy format FILE="" #…
Tiffany Walker
  • 6,541
  • 13
  • 53
  • 77
1
vote
1 answer

File server failed. DFS with and without replication in use. Questions on getting back to normal operation

I have an oldish (physical) Windows Server 2003 R2 box, which is a file/print server. I suspect the RAID card has gone bye-bye, after a reboot Windows is checking the data volume, its been 1.5 hours or so. I'm starting to prep for the worst and I…
1
vote
0 answers

Backup RAID1 and RAID10 before upgrade

I have two machines, one with mdadm RAID 1 on root partition and one with mdadm RAID 10 on root partition with 4 drives. Ubuntu machines, now I need to upgrade these. If something goes wrong I need a surefire way to restore original content. What is…
EdgarPE
  • 121
  • 3
1
vote
2 answers

Restore Exchange 2003 database to disk on a server not running Exchange

I need to restore an Exchange 2003 database to disk on a server that is not running Microsoft Exchange, would that be possible? or would Backup Exec only restore to a server running Exchange? If it is not possible, how can i restore the database to…
Zero Subnet
  • 699
  • 2
  • 10
  • 29
1
vote
4 answers

Sql Server Backup Compatibility - 2008 with 2005

I'm hoping to restore a backup from SQL Server 2008 into a Sql Server 2005 instance. Is there a way to have Sql 2008 back up in a format that 2005 will understand?
1
vote
2 answers

MySQL Unite Two Tables

Situation: after crash (or hack, I'm not still sure) some in table vB_users disappeared. I have march backup of that table, but since that time there were new records. Is there a fast way to add all the rows from crashed table to the backup table…
ABTOMAT
  • 181
  • 1
  • 1
  • 10