Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [restore]

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

328 questions
43
votes
3 answers

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 blah_production and import it on development or staging…
Pablo Fernandez
  • 7,438
  • 25
  • 71
  • 83
39
votes
2 answers

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?
warren
  • 18,369
  • 23
  • 84
  • 135
38
votes
7 answers

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 && install it: the dependencies would be also uninstalled…
kolypto
  • 11,058
  • 12
  • 54
  • 66
37
votes
7 answers

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 slower. Individual inserts are now taking 15+…
Dave Forgac
  • 3,546
  • 7
  • 37
  • 48
25
votes
3 answers

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 back up the tables' structure (only their…
user16629
19
votes
3 answers

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 system. Try moving to a location which has a…
Spongeboy
  • 953
  • 1
  • 7
  • 11
15
votes
7 answers

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 Management Studio Right click on the database | Tasks |…
Mario
  • 321
  • 1
  • 5
  • 12
13
votes
3 answers

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 to restore this backup to a different server (or…
Massimo
  • 70,200
  • 57
  • 200
  • 323
12
votes
3 answers

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 SharePoint Services. This is an EBS-backed image…
John Miner
  • 300
  • 3
  • 9
10
votes
4 answers

Does restoring a SQL database from backup rebuild its indexes?

Does restoring a SQL database from backup rebuild its tables and indexes from scratch? Or does it keep it in the same internal physical order it was in at the time of backup? We're using SQL 2000 with Quest Lightspeed compressed backup, if that…
BradC
  • 2,220
  • 4
  • 27
  • 36
9
votes
1 answer

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 Mode does not work, it still tries to configure…
tehDorf
  • 281
  • 2
  • 3
  • 10
9
votes
5 answers

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 drivers, install shop desired software, and…
CT.
  • 741
  • 2
  • 8
  • 20
8
votes
4 answers

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 particular user was "blessed" with new hardware, in…
HopelessN00b
  • 53,795
  • 33
  • 135
  • 209
8
votes
3 answers

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 Directory environment (as in "the System State of my…
Massimo
  • 70,200
  • 57
  • 200
  • 323
7
votes
2 answers

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 built-in backup program (NTBackup.exe). Is there…
phoenix8
  • 213
  • 2
  • 9
1
2 3
…
21 22