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

learn more… | top users | synonyms

3
votes
1answer
2k 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 ...
1
vote
2answers
2k views

How do I do a cross-platform backup/restore of a DB2 database?

I need to dump a couple of databases from DB2 for Mac and DB2 for Linux and then import the databases to DB2 for Windows. Unfortunately, when I try the standard backup and restore I get the following ...
0
votes
2answers
89 views

Am I backing up my database correctly? And then load it as INNODB?

mysqldump -hlocalhost -uUSERNAME -pPASSWORD THEDATABASE | gzip > /home/db_backup/abc.sql.gz tar -xzvf ./abc.sql.gz mysql THEDATABASE -uroot -pPASSWORD < abc.sql The important note is that ...
0
votes
3answers
875 views

PostgreSQL, update existing rows with pg_restore

I need to sync two PostgreSQL databases (some tables from development db to production db) sometimes. So I came up with this script: [...] pg_dump -a -F tar -t table1 -t table2 -U user1 dbname1 | \ ...
3
votes
6answers
832 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 ...
25
votes
5answers
23k 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 ...
0
votes
3answers
4k views

How to restore MSDB database

I lost MSDB database in SQL 2005. How do I restore that?
1
vote
3answers
2k views

How to transfer a postgres database to a different server

I'm planning to transfer a ~100GB Postgres database to a new server. Is it save to just copy the data directories to the new server and start up the database there, or do I need to do a dump on the ...
0
votes
1answer
148 views

Good off-site backup solution for database and files

I was searching for a tool that would make remote backups/restores easier for both database and files, but I couldn't find any, so I started thinking about creating my own online service that deals ...
0
votes
1answer
714 views

SQL: Restore a database that was not detached properly [closed]

I had problems with my harddisk on my dev box, yet I was able to save my MDF and LDF files. Needless to say, they were not detached properly. I tried sp_attach_single_file_db which broke down ...
5
votes
2answers
2k 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 ...
0
votes
1answer
302 views

How do I restore the layout on Expression Editor in Powercenter

I am using Powercenter 8 and I am not sure how I did it, but I have messed up the Expression Editor Layout, so now I am unable to see the expression that I am building. Does anyone know how to ...
1
vote
1answer
441 views

How to rescue oracle instance having oradata and admin?

I have copy of oracle folder, installed on windows. There are have oradata and admin folders. It is Oracle 9.2.0.8.0. I had working WibXP operation system, and installed oracle there. Now WinXP, ...
0
votes
2answers
627 views

recreate svn repository from two working copies

This might be a repeated question from here (http://serverfault.com/questions/55511/recreating-svn-repository), but I think I should ask this again. I do not have a most recent back up of the ...
1
vote
1answer
172 views

What tape drive reads Verbatim DC6250?

We've got some old (very) data on Verbatim DC6250 tapes that needs to be read and no hardware to do it with. What drive(s) will read these tapes?
1
vote
1answer
48 views

Windows 2008 imaging on Intel Core 2 Duo

I have a Windows 2008 system with VMware Oracle RAC and Linux CentOS as guest OS plus Visual Studio etc installed. Can anybody tell me how do I go about creating a system image so restores can be a ...
2
votes
2answers
226 views

sharepoint 3.0 site restore/import trouble

We have some old sharepoint data (from a WSS 3.0 SP1 or SP2 install), that I need to restore. Problem is: This is a time management site, and one of the fields automatically pics up the user name of ...
0
votes
1answer
214 views

Restoring /root file system in debian Linux!

How can i restore Linux system if its /root file system is corrupted?
0
votes
1answer
112 views

Restoring Windows Group Policy

After playing with some Group Policy settings and breaking privileges for System accounts, I have learnt the hard lesson to have a proper configuration management policy in place. So that will cover ...
0
votes
2answers
202 views

Problem booting Vista after moving to a larger drive

I am trying to move a 32-bit Vista installation onto a larger hard disk. I tried to do this using my normal method: Boot the system into an Ubuntu Live CD Backup the MBR using: dd if=/dev/sda ...
0
votes
3answers
421 views

Fastest way to recover Exchange

In our ongoing saga.... We lost our domain controller and had to rebuild AD from scratch and reinstall Exchange. I am now trying to mount or Exchange database from backup and the error I receive is: ...
0
votes
2answers
1k views

What to do with Exchange 2007 and crashed/rebuilt Active Directory

Here's our situation: we had one server running Win2003 Server Std that was also the only domain controller. The ntds.dit file (AD database) became corrupted and there was no backup. We scrapped the ...
2
votes
3answers
197 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 ...
14
votes
1answer
11k 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?
2
votes
1answer
83 views

What causes inconsistent SQL 2K backups?

I take weekly full backups of a SQL 2000 database via vanilla Enterprise Manager. The problem happened when I tried to restore the database. I learn that it was not up-to-date as it was pointing ...
4
votes
3answers
7k views

How can i backup a table structure but NOT his data in MySQL

I am using MySQL Administrator for making my database backup. I can perfectly backup the whole database with all its tables. There are some tables whose size is very big so i wonder if i could only ...
0
votes
2answers
347 views

MySQL dump-restore replaces characters with 3Fh

FreeBSD Server with Mysql and make.conf like that .if ${.CURDIR} == ${PORTSDIR}/databases/mysql50-server WITH_CHARSET=cp1251 WITH_COLLATION=cp1251_bin BUILD_OPTIMIZED=yes BUILD_STATIC=yes .endif .if ...
1
vote
3answers
3k views

WSS 3.0 Backup/Restore Root Site Collection to Sub-Site of New Site Collection

Our intranet was originally setup to be at the root of its site collection. We are trying to change this so that our new internet site will live in the root and the intranet will be a sub-site. At ...
0
votes
4answers
3k views

Import old database from the crashed SharePoint server

I have a SharePoint server have its configuration database, this server is down, when I try to access it it is gives me error: "Cannot connect to the configuration database" so I installed ...
0
votes
1answer
394 views

System State restore

I am unclear about the System State restore. Suppose I restore the System State followed by reinstalling my other Programs (Visual Studio, etc.). In such case the registry value is updated with the ...
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. ...
3
votes
4answers
196 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 ...
2
votes
3answers
2k views

Network driver for Hyper-V restore from Windows Home Server

I have backed up Windows Server 2008 running virtualized on Hyper-V to a Windows Home Server 2008 SP1 (I know I should have backed up the VHD instead). Now I need to restore the contents of the VM ...
1
vote
4answers
9k views

How do I extract all the files in a VHD to a hard disk including permissions?

I'd like to know wha thte best way is to make an exact copy of a vhd image and pu tit onto my hard disk. I've tried xcopy but there seems to be a number of issues rlated to permissions when doing ...
8
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 ...