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

learn more… | top users | synonyms

0
votes
1answer
813 views

MySQL “max_allowed_packet” error — how do you profile the max packet size?

Keep running into into the "max_allowed_packet" error msg, which to data I've just guessed at what the number should be.... I'd like to stop guessing, and know how to see what the number should be -- ...
0
votes
4answers
1k views

can you restore a Windows 2008 Server backup to an Amazon EC2 instance?

Is it possible to take a backup of a Windows 2008 server, made with the built-in Windows backup, and restore it to an Amazon EC2 instance. If so, could you please outline the steps? The machine that ...
0
votes
1answer
724 views

SQL Server 2008 Error when restoring DB backup: “specified cast is not available”

I was using SSMS to restore a database backup onto another database in a SQL Server 2008 instance, when I received the error message: "specified cast is not available". The backup was made on a SQL ...
21
votes
3answers
31k 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 ...
0
votes
1answer
372 views

How to restore database using old full backup and current log file

What is happened? My client has lost the hard disk. He has to restore database. He has the full backup of database 15 days old. He has ldf (log) file of this database. He has NOT mdf file (it was ...
0
votes
1answer
624 views

How to recover MySQL database from .mysql file?

We had some problems with our MySQL server and somehow all I've got is a database.mysql file for the database I want to restore. I've done a bit of googleing but I didn't find anything about how ...
1
vote
2answers
791 views

how to restore a mysql dump FOLDER

After having a vps crash, I asked my hosting to give me the dumped file of my drupal database. It is a folder filled with of *.frm *.MYD files of the database tables. I used to restore mydb.sql files ...
1
vote
2answers
2k views

Exchange 2007 restore - Backup Exec Unable to Attach to a resource

I have been struggling with this one for months! Grateful for any advice. The setup is a windows 2003 server network, 4xservers on the domain. Two exchange 2007 servers (only one with mailboxes still ...
4
votes
3answers
848 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 ...
1
vote
2answers
1k views

Restore Bacula Files

Q1: Can I restore bacula files to another location? Because whenever I restore my bacula files, it goes directly to the client on which the files was backed up. Q2: Can I restore bacula files if ever ...
0
votes
1answer
132 views

Windows server backup integrity

We are backupping daily the whole server (Windows Server 2008 R2) with the "Bare Metal Recovery" option, is there any way to verify backup integrity without restoring everything on a new machine ...
1
vote
3answers
970 views

Transfer email accounts with all mail from server to server, using IMAP

IMAP allows you to access the folder heirarchy and all emails on a given account. There was a serverfault (pun intended) with our primary email servers and so we have to shift all email accounts to ...
1
vote
1answer
4k views

oracle database move current server to another machine problem

these day i really stress because of oracle server, im quite new to oracle. i have one old windows 2003 server which installed oracle 10.2.0 version. and i want to full backup of this oracle then ...
0
votes
2answers
175 views

SQL Server 2008 import data from SQL Server 2005 backup file

I have a SQL Server 2005 database backup file (.bak), and I want to grab the data of this file and import it to an already existing database. Since the backup file contains database information as ...
0
votes
1answer
395 views

Virtualmin Restore from Backup

I had to re install my VPS due to some fatal problems, it now has a clean version of ubuntu 8.04 and virtualmin. I have 18 domains that i have backed up on my home computer which i spent 3 hours ...
1
vote
2answers
404 views

How does restore to dissimilar hardware work?

System restore to dissimilar hardware, something which high end backup/recovery products can do, is a really useful feature. However, how does it work on a Windows Server restore? Thanks
1
vote
1answer
216 views

Restoring data from Linux RAID running in linear mode

Two years ago I bought a WDC MyBookWorld II NAS which is using Linux software RAID internally. I thought it used RAID1 but it turned out that in my case it used linear mode. I was stupid enough not to ...
1
vote
1answer
289 views

How does one restore dump of block device in Linux

Lets say I create a dump of a block device like so dump -0 -A L0.archive -f L0.dump /dev/sde1 Now in this case sde1 is not mounted, as to not be live. So how can I restore sde1 from the other ...
0
votes
2answers
726 views

SQL Server: Restore database, data copy-redo-undo, clarification?

I have tried to understad how database restore works in SQL Server. I have read from BOL about different phases within the restore operation but did not understand much. Can you please clarify what ...
0
votes
3answers
126 views

How to do a single backup of SQL Server 2005 Data for out of place restore?

My problem: I got a virtual Windows XP machine with a specific database driven software installed using SQL Server 2005. A similar machine is also in use by several customers. One customer reports an ...
2
votes
1answer
6k views

Restore SQL Server database is hanging?

I've made a Backup from a SQL Server 9.0.4053, copied the bak file to a different computer running SQL Server 10.0.2531 and tried to restore using RESTORE DATABASE [MyDatabase] FROM DISK = N'C:\Temp\...
1
vote
1answer
681 views

Restore Virtual Machine from DPM2010 via powershell script

I need to restore a VM covered by DPM 2010 via powershell. I searched with google and it is kind of painfull to find no usefull documentation about DPM and Powershell. Parameters: - VMs are running ...
4
votes
3answers
9k 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 ...
0
votes
1answer
220 views

Rebuilding a MySQL database from 160 retreived files with no name

I had a server crash and it took with it the hard drive. I put the hard drive in a USB enclosure, but the main partition would not mount because the partition was corrupted. I was able to see the USB ...
1
vote
4answers
3k views

Restore linux backup to new hardware

I was looking at following the instructions in this serverfault question for restoring a backup of a server to new hardware. I am a little bit confused by the whole process and have a few specific ...
1
vote
1answer
127 views

Restoring files with 255+ character pathnames + Server 2000

I'm experiencing an issue when trying to restore files that have filename paths over 255 characters (in that they will not restore). The file server is Server 2000 (ancient, I know) and the software ...
1
vote
1answer
3k views

Windows 7 Startup Repair Disjoining System From Domain

We have recently run into the following issue : Startup Repair : The Startup Repair tool can solve many common startup problems automatically. Startup Repair performs an exhaustive analysis to ...
0
votes
1answer
125 views

Out of ideas on how to revive the Gateway E-9525R server

My boss gave me a project: he got a Gateway E-9525R server that does not do anything at startup. He asked if I could revive it somehow. No one is really sure what happened to it, rumor has it the BIOS ...
0
votes
3answers
777 views

SqlServer2005, restore much slower than backup - it that to be expected?

My backup/restore was getting sluggish (different story), but looking at the duration of backup and restore, I see that the backup completes in a few seconds, while restoring completes in MINUTES. ...
1
vote
4answers
5k views

how to: rescue Data from MySQL (only files on HDD left)

After eventually managing to upgrade my debian virtual server from etch to lenny. (Read here for the full story: http://serverfault.com/questions/168808/debian-upgrade-from-etch-to-lenny-fails) I now ...
0
votes
2answers
281 views

SQL 2008 R2: How to determine who restored the database?

Our database was recently restored. It caused some real grief. Is there an audit mechanism to determine who executed the most recent restore? Thanks.
1
vote
1answer
3k views

How to backup a specific SQL Server Schema's table?

In my SQL Server database, I have multiple schemas. I would like to backup only a specific schema's tables to a format that can easily be restored. Example: [dbo].[Trucks] [dbo].[Cars] [unknown].[...
0
votes
2answers
1k views

Exchange 2003 NTBackup always fails

Running Exchange Server 2003, I run an online backup every 2 nights using NTBackup, the job succeeds and I can verify by check db properties in systems manager & logs in D:\Exchsrvr\mdbdata. I ...
2
votes
3answers
381 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 ...
0
votes
1answer
176 views

Backup Exec 11D and MS WSS 3.0 Granlar Restore?

Has anyone use the Backup Exec 11D (7170 SP4) with the Share Point Agent to backup and restore? I have been using the Agent to back a WSS 3.0 SP2 and the backups are reporting successful. I have ...
0
votes
1answer
522 views

Populate a remote databse using MySQL Workbench and remote .sql file

I'm using MySQL Workbench 5.2 CE, and I try to figure out how to populate or restore a mysql_dump.sql file uploaded to the root of my domain (./mysql_dump.sql). Since the file is a little bit ...
1
vote
1answer
216 views

Exchange restore from week old backup

Our exchange 2k3 database got corrupted and we couldn't revive it, so we're going to restore the last backup, which was unfortunately a week ago :-S My question is, what happens to the cached emails ...
2
votes
1answer
96 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 ...
1
vote
1answer
64 views

restore -A usage

I have created a number of dump files using Linux dump(8), using the -A option to get a table of contents on disk (the backups are on tape). Now I'm trying to look into these archive files, using ...
0
votes
2answers
824 views

nic not working after TEST sbs 2003 restore to dissimilar hardware

restored an sbs 2003 backup file to different hardware rebooted, and things took a while, i tidied up the drivers and such, removed ghost nic in device manager etc, re-ran the connection wizard for ...
1
vote
1answer
294 views

Download databasename.bak file

I have downloaded databasename.bak file from my hosting company, when i tried to restore that DB file in SQL server 2008 it is keep on giving me following error. The media family on device 'C:\...
2
votes
2answers
316 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: http://support.microsoft....
0
votes
1answer
70 views

How To Place a Drupal Site on to a server from backup

I Backed up my site then totally re-did my server with a different Control Panel which created a different directory structure /var/www/vhosts/user/site.com/httpdocs I put the files into the httpdocs ...
17
votes
6answers
20k 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 ...
2
votes
2answers
356 views

how to restore grub

During copying files via lan my Ubuntu Server 10.04 hung up and I had to reset the computer. After reboot, I got: Grub error 17, so I tried the rescue alternate CD, but I got a info, that no ...
9
votes
5answers
229 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 ...
1
vote
1answer
87 views

What does SQL Server do if you select more than 1 full backup when doing a restore?

I have a backup file that contains 2 backup sets. Both backup sets are full backups. When I open SQL Server Management Studio and choose "Restore..." and pick the file as my device, it lets me pick ...
1
vote
2answers
1k views

Difficulty restoring a differential backup in SQL Server, 2 media families are expected or no files are ready for rollforward

I have sql backups copied from server A to server B on a nightly basis. We want to move the sql server from server A to server B without much downtime, but the files are very large. I assumed that ...
3
votes
2answers
3k 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 ...
0
votes
1answer
110 views

Automate BESR 8.5 Restore

I have been searching for a way, script, rain dance, to automate the restore of several BESR 8.5 created images (v2i file extension). Does anyone have any experience on how to pull this off? I have ...