Returning data from a backup to its original location or to its successor.

learn more… | top users | synonyms

26
votes
5answers
25k views

Linux: how to restore config file using apt-get/aptitude?

I've occasionally lost my config file "/etc/mysql/my.cnf", and want to restore it. The file belongs to package mysql-common which is needed for some vital functionality so I can't just purge ...
15
votes
1answer
12k views

How can I do a dump of only the table structure in PostgreSQL?

In a similar vein to this question, how would I do a schema-only dump in PostgreSQL?
13
votes
5answers
9k views

How can I speed up a MySQL restore from a dump file?

I am restoring a 30GB database from a mysqldump file to an empty database on a new server. When running the SQL from the dump file, the restore starts very quickly and then starts to get slower and ...
10
votes
2answers
6k views

Simple Backup Strategy for Amazon EC2 instances / volumes?

You have entered Introductory Backups for Amazon EC2 EBS-backed Windows Images 010... I have been browsing my brains out to find a simple backup strategy for our single windows 2008 server running ...
9
votes
8answers
29k views

SQL Server restore a backup results in an error

I have a database in dev (SQL Server 2005 on Windows Server 2008) that I need to move to prod (SQL Server 2000 on Windows Server 2003). My process is as follows: Login to dev, open SQL Server ...
9
votes
5answers
221 views

How can I decrease the time spent reformatting / restoring user's workstations?

I started working for a medium sized company (approx. 150 users). When user's workstations need to be reformatted for any variety of reasons, we reformat, reinstall windows from an oem disk, install ...
7
votes
2answers
2k views

Active Directory disaster recovery with DPM

I have a sort of catch-22 question here. Suppose I'm using Microsoft System Center Data Protection Manager (2010 or 2012, it works the same way) to backup, amongst various other things, my Active ...
7
votes
3answers
908 views

SCCM user state migration - is this user's data gone?

Long story short(ish), we're on the tail-end of our XP to Windows 7 migration project, and finally got some VIP's machine in to be migrated. Since the machine is almost as old as the OS on it, this ...
6
votes
3answers
9k views

Unable to restore from Shadow Copy due to long filename

We have shadow copy enabled on our Windows SBS 2008 server. Attempting to restore a file from shadow copy gave the following error- The source file name(s) are larger than is supported by the file ...
6
votes
6answers
12k views

T-SQL Script to copy a database

I would like to find a T-SQL script-based way to copy my "PROD" database (which is read-only and consists of several filegroups) to a read/writable "EDIT" database, which I can use and edit data in. ...
5
votes
2answers
16k views

Export and import a PostgreSQL database with a different name?

Is there a way to export a PostgreSQL database and later import it with another name? I'm using PostgreSQL with Rails and I often export the data from production, where the database is called ...
5
votes
2answers
3k views

Extract registry key from NTBackup System State backup

A Windows Server 2003 machine died recently but I need some information that was contained in the now-defunct server's registry. I have a "System State" backup file created by the Windows Server 2003 ...
5
votes
1answer
12k views

Server 2008 stuck in reboot loop “Configuring Updates: Stage 3 of 3”

Our server performed some updates last night and this morning we came in to find it stuck in a boot -> "Applying System Configurations" -> "Configuring Updates: Stage 3 of 3. 0%" -> reboot loop. Safe ...
4
votes
4answers
5k views

Is the master database backup crucial for restoring MS SQL server in the event where you have to restore from backup and build database server from scratch?

I have been advise by Commvault partner support to turn off the backup of the master database as the backup failed due to the log file being lock. The following is the advise given: "The message is ...
4
votes
3answers
8k views

How can I back up a table structure but NOT its data in MySQL

I am using MySQL Administrator for making my database backup. I can perfectly back up the whole database with all its tables. There are some tables whose size is very big so I wonder if I could only ...
4
votes
3answers
623 views

backing up SVN repository on Ubuntu linux to a Windows share

We have a Ubuntu(head-less) system that runs our SVN repository(ies). Would like to regularly back it up to a Windows share automatically. What should we do ? Any links/articles ? Any gotchas ? How ...
4
votes
3answers
691 views

how to get a linux image and restore it on another computer

I am trying to use dd command to accomplish complete restore of a linux image on a new computer. I have two partitions sda1(main) and sda2(extended), I took a backup of mbr image using: dd ...
4
votes
2answers
1k views

Amazon EC2: Restoring Windows EBS snapshots into AMIs or Instances?

As my Windows EC2 instance lives, starting and stopping many times a week, it evolves. These changes get saved to it's EBS volume, so state is persistent across reboots. Now, periodically I backup ...
4
votes
1answer
2k views

How to backup and restore configurations on lots of Cisco routers and switches from Linux? [closed]

I'm looking for a way to backup, save, version and restore configurations of Cisco network equipments. I need to be able to automatically GET and PUSH configuration files on lots of routers and ...
4
votes
2answers
512 views

backup and restoration of a freeipa infrastructure

I'm finding the documentation on ipa server backup and restoration sadly lacking, and being so centrally critical it's not something i'm really happy about shooting in the dark with - could some kind ...
4
votes
0answers
145 views

Server hacked - want to run an rsync backup in reverse. Will this work? [duplicate]

Possible Duplicate: My server's been hacked EMERGENCY My user account on a shared hosting server got hacked and overwrote every PHP with this at the bottom.... ...
3
votes
4answers
198 views

Protecting Windows Machines From Users

What are some good methods to protect staff machines from the staff who use them? I am looking for something that is totally seamless, that the user would not notice...something that would not hinder ...
3
votes
1answer
2k views

What are the risks in backing up private keys on services like Dropbox?

I have a couple of private keys that I use to administer Amazon EC2 instances. I recently lost these keys when I did a re-install of my computer and I found out that the CD-RW I'd backed them up to ...
3
votes
2answers
604 views

How do I recover a dropped table from SQL Server Express 2005?

Something disastrous happened to me. I accidentally dropped my important table from SQL Server 2005 Express DB. Is there any way to recover that table with all records? Can DB Log file help? I have a ...
3
votes
1answer
3k views

Restore DB2 database

Is there anyway to restore a db2 database whose backup was made in Windows XP , to a linux machine ? I am using the same version of db2 on both the OSes -> DB2 Express-C 9.7 Source OS : Windows XP SP2 ...
3
votes
2answers
1k views

Restoring Windows Server 2008 to different hardware - OEM License [duplicate]

Possible Duplicate: Can you help me with my software licensing question? For disaster recovery purposes, i am considering the possibility of using a VM to restore a backup of our Windows ...
3
votes
1answer
279 views

Restoring deleted AD object

I have a Windows 2003 domain and Windows 2003 domain controller. I accidentally deleted the whole container. The container contains some child container objects group object and some ...
3
votes
6answers
898 views

How do I restore to a SQL backup I made two days ago?

Database disasters only happen to other people, right? RIGHT?!? I'm sure this has never happened to anyone since the beginning of computer history, but, believe it or not, I'm having a problem with a ...
3
votes
1answer
78 views

I just deleted /etc/rc?.d/ dirs, how can I restore/recreate them?

sysv-rc was installed to get a hold of systems autostart, but in the end it wasn't needed (as update-rc.d came in handy). So I dumbly do apt-get purge sysv-rc and type Yes, do as I say! to the apt ...
3
votes
1answer
1k views

windows 2003 server missing dllcache folder, how to restore?

Recently our Windows 2003 server has started giving a "Could not start the security center service error". I looked into this and realized a windows dll was missing called WSCSVC.dll I then realized a ...
3
votes
2answers
2k views

Restoring openldap configuration from ldif file?

I am trying to restore my OpenLDAP server from an ldif file I made before it went horribly wrong. All of the websites I found talk about using slapadd but when I run slapadd -v -l ...
3
votes
2answers
2k views

Command line scripts to restore the 4 system databases of MS SQL Server 2008

can someone give me some advice on how to restore the 4 system databases (master, msdb, model, tempdb) of a sql server 2008 please? I've already done some testing myself (on restoring the master ...
3
votes
1answer
158 views

FreeBSD restore of /rescue

I'm running a restore from a previous backup of my FreeBSD system, and run into trouble when restoring / (excluding mount-points). The problem is that /rescue fills the / partition (to the extent that ...
3
votes
1answer
970 views

MySQL: How to backup and restore using different schema name using xtrabackup

I very often need to create a backup of a database and import it using a different schema name. These schema's are pretty large (3-5GB) and mysqldump is a pain. xtrabackup seems promising but I cannot ...
3
votes
1answer
543 views

Most efficient/quick SQL database update/restore method

I'm working on a very large database (250+ gigs) with well over 225 million records. The database is hard to work with simply from its sheer size. This database will only be used as read-only. We're ...
2
votes
3answers
199 views

RAID5 Resize with additional disk

I currently have a 3 disk RAID5, all are 400GB WD SATA drives, on an Areca RAID controller. One of the drives has recently gone bad, leaving the array in a degraded state. If I replace the bad drive ...
2
votes
2answers
207 views

Storage server 2003 shadow copy backups deleted

We have a 1TB storage server I've just gone to transfer a 100Gb file across to it. And it has deleted the shadow copy. From Googling I understand that this probably occurred: ...
2
votes
6answers
425 views

How to set up a linux box for easy restoration?

At my work, we use a linux box to store our source code and host our revision control software (svn). We also have some other products on there like "trac" for project management, fisheye and ...
2
votes
5answers
2k views

Restore Hyper-V image to bare metal

We run Hyper-V on our Win2008R2 server with a DC and Terminal Server as virtualised machines. We're finding that our current usage necessitates a new server to give our terminal server more ...
2
votes
3answers
359 views

Debian/Linux backup files changed by user

I would like to backup my server that is hosting a few websites in such a way that I can restore everything to the way it was from a fresh format. I know that I should backup all the home folders and ...
2
votes
1answer
961 views

Windows Server 2008 R2 - Restore Previous Versions - Restored File Filled with Nulls

The Restore Previous versions feature on my file server stopped working some time in the recent past. If I look at the Previous Version for a file or folder the items are listed and they show a valid ...
2
votes
3answers
5k views

How to restore a SQL Server database and shrink its files at the same time?

Let's say I have a SQL Server database whose data files have been created with an initial size of 100 GB, but it only contains 10 GB of data. A database backup will then be only 10 GB in size. I want ...
2
votes
2answers
230 views

Restore old /etc onto newer system (CentOS)

In order to save space, I don't backup /usr (except /usr/local), /bin, /sbin and /lib. Instead I do a rpm -qa --qf '%{NAME}\n' to get a list of packages I need to install to restore the content of ...
2
votes
1answer
3k views

Centos 6 - Backup and Restore/Recover

I'm trying to test and document a backup and restore procedure for Centos 6. Here's where I'm up to, but there are a few areas where I need a bit of clarity. CentOS backup/restore documentation on the ...
2
votes
1answer
138 views

Restore sql server 2000 database to 2008

I am not a DBA. I will be doing this for the first time. So I am not sure what all I am supposed to do? I will be restoring sql server 2000 database to sql server 2008. Are there anywhere step by ...
2
votes
2answers
949 views

How can I get ntbackup to show items in the Backup\LTO Ultrium media pool so they can be restored

I am attempting to restore data from an LTO Ultrium 4 backup tape. The backup was originally done via NTBackup. When I attempt to restore the data that was backed up, I am unable to view or select the ...
2
votes
3answers
5k views

Recover MySQL tables from frm files

I'm desperate, and hoping some kind soul can rescue me! I'm dealing with restoring a completely crashed server. Everything is back up except for there's an issue with one domain which uses MySQL (no ...
2
votes
1answer
1k views

Restore SQL Server 2008 db without affecting users

When I restore a db in Sql Server 2008 R2 from data on another server, it makes a mess of the users. I have a Windows User and MsSql Login named Web_SqlA on both machines. Before the Restore, Web_SqlA ...
2
votes
1answer
751 views

Sharepoint - restore single document from database level backup

Have a single Sharepoint webserver backed by a SQL 2005 server. The sharepoint server has a messed up document in a document library and I have a SQL database backup from the day before. What are my ...
2
votes
1answer
84 views

How can I get the bak file and most recent diff file for every database on my SQL Server?

I need to restore about 1000 backups with the latest diff (for about 1000 databases). Some data was deleted last night in one column of a table. So I need to run a script on each restored vs current ...