Given a **SQL Server 2008** `.bak` file, is there a way to restore the **data file only** from the `.bak` file, **without the transaction log**? 

The reason I&#39;m asking is that the transaction log file size of this database is huge - exceeding the disc space I have readily available.

I have no interest in the transaction log, and no interest in any uncompleted transactions. Normally I would simply shrink the log to zero, once I&#39;ve restored the database. But that doesn&#39;t help when I have insufficient disc space to create the log in the first place.

What I need is a way to tell SQL Server to restore only the data from the `.bak` file, not the transaction log. Is there any way to do that?

Note that I have no control over the generation of the `.bak` file - it&#39;s from an external source. Shrinking the transaction log before generating the `.bak` file is **not** an option.

Restore SQL Server DB without transaction log

This is somewhat of a mundane question but it seems to me there is no in-built method for it in WPF. There only seems to be the `WindowState` property which being an enum does not help since i cannot tell whether the Window was in the `Normal` or `Maximized` state before being minimized.

When clicking the taskbar icon the window is being restored just as expected, assuming its prior state, but i cannot seem to find any defined method which does that.

So i have been wondering if i am just missing something or if i need to use some custom interaction logic.

(*I&#39;ll post my current solution as answer*)

How to restore a minimized Window in code-behind?

Are there any documented techniques for speeding up mySQL dumps and imports?

This would include my.cnf settings, using ramdisks, etc. 

Looking only for documented techniques, preferably with benchmarks showing potential speed-up.

Speeding up mysql dumps and imports

I have been reading a LOT of google posts and StackOverflow questions about how to restore a database in SQL Server from a .bak file.

But none of them states how to just READ the tables in the database-backup.
(None that I could find anyway?)

I just want to check out some old information which now has been deleted, without actually restoring the full database.
Is this possible?

.

**EDIT:**

I just wanted to post my T-SQL solution to the problem, so others may use it and I can go back and look it up ;)

First I created a new database called `backup_lookup` and took it offline.
After this I could restore my old database `mydb` to the new one, without ever touching my original.

    USE master
    GO
    RESTORE DATABASE backup_lookup
     FROM DISK = &#39;D:\backup\mydb.bak&#39;
    WITH REPLACE,
     MOVE &#39;mydb&#39; TO &#39;C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\backup_lookup.mdf&#39;,
     MOVE &#39;mydb_log&#39; TO &#39;C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\backup_lookup_log.ldf&#39;
    GO

I hope this helps :)

Opening a SQL Server .bak file (Not restoring!)

I have a backup of **Database1** from a week ago. The backup is done weekly in the scheduler and I get a ``.bak`` file. Now I want to fiddle with some data so I need to restore it to a different database - **Database2**.

I have seen this question: https://stackoverflow.com/questions/5228597/restore-sql-server-database-in-same-pc-with-different-name and the recommended step is to rename the original db, but I am out of that option as I am in the production server and I cant really do it.

Is there any other way of restoring it to ``Database2``, or atleast, how do I browse through the data of that .bak file?

thanks.

ps: the second answer from the above link looked promising but it keeps terminating with error:   
&gt;Restore Filelist is terminating abnormally

How to restore to a different database in SQL Server?

I have a mysqldump backup of my mysql database consisting of all of our tables which is about 440 megs. I want to restore the contents of just one of the tables from the mysqldump. Is this possible? Theoretically, I could just cut out the section that rebuilds the table I want but I don&#39;t even know how to effectively edit a text document that size.

Can I restore a single table from a full mysql mysqldump file?

I created a database on my local machine and then did a backup called `tables.bak` of table `DataLabTables`. 

I moved that backup to a remote machine without that table and tried to do a restore but get the following error:

&gt; System.Data.SqlClient.SqlError: The operating system returned the
&gt; error &#39;5(Access is denied.)&#39; while attempting
&gt; &#39;RestoreContainer::ValidateTargetForCreation&#39; on &#39;c:\Program
&gt; Files\Microsoft SQL Server\MSSQL.1\MSSQL\DataLabTables.mdf&#39;.

How do I fix my rights, if that is the problem?

SQL Server Restore Error - Access is Denied

My SQL Server 2005 doesn&#39;t restore a backup because of active connections. How can I force it?

When restoring a backup, how do I disconnect all active connections?

I have a SQL Server 2012 database with filestream enabled. However, when I backup it and try to restore it on another SQL Server 2012 instance (on another machine), I simply get this message that:

&gt;No backupset selected to be restored.

Not even a single line of more explanation. What&#39;s wrong here?

Every other database without filestream is OK and can be restored successfully. Is it something related to filestream? Should I install a hotfix or something like that.

&quot;No backupset selected to be restored&quot; SQL Server 2012

When I want to unstage a staged file, all of my Git tutorials show something like:

```
$ git add *
$ git status
On branch master
Changes to be committed:
  (use &quot;git reset HEAD &lt;file&gt;...&quot; to unstage)

    renamed:    README.md -&gt; README
    modified:   CONTRIBUTING.md
```

This hint tells us to use `git reset` for unstaging a staged file.

But instead, in my terminal, I see:

```
git status
On branch master
Changes to be committed:
  (use &quot;git restore --staged &lt;file&gt;...&quot; to unstage)
	renamed:    cat.js -&gt; catcat.js
	renamed:    tolendo.gogo -&gt; tolendo.txt

Untracked files:
  (use &quot;git add &lt;file&gt;...&quot; to include in what will be committed)
	readme (copy).md
	tolendo (copy).txt
	zing (copy).html
```

My terminal tells me to use `git restore --staged` but the tutorials, as well as [Git’s website](https://git-scm.com/book/en/v2/Git-Basics-Undoing-Things#_unstaging), tell me to use `git reset HEAD`.

I have no idea about the new `restore` command. I tried Google to find the difference between `git reset` and `git restore` but nothing seemed to fit my question.

What is the `git restore` command and what is the difference between `git restore` and `git reset`?

Is it possible to restore a MySQL database from the physical database files. I have a directory that has the following file types:

client.frm  
client.MYD  
client.MYI  

but for about 20 more tables.

I usually use mysqldump or a similar tool to get everything in 1 SQL file so what is the way to deal with these types of files?

Restoring MySQL database from physical files

I backed up a database:

    BACKUP DATABASE MyDatabase
    TO DISK = &#39;MyDatabase.bak&#39;
    WITH INIT --overwrite existing

And then tried to restore it:

    RESTORE DATABASE MyDatabase
       FROM DISK = &#39;MyDatabase.bak&#39;
       WITH REPLACE --force restore over specified database

And now the database is stuck in the restoring state.

Some people have theorized that it&#39;s because there was no log file in the backup, and it needed to be rolled forward using:

    RESTORE DATABASE MyDatabase
    WITH RECOVERY 

Except that, of course, fails:

    Msg 4333, Level 16, State 1, Line 1
    The database cannot be recovered because the log was not restored.
    Msg 3013, Level 16, State 1, Line 1
    RESTORE DATABASE is terminating abnormally.


And exactly what you want in a catastrophic situation is a restore that won&#39;t work.


----------

The backup contains both a data and log file:

    RESTORE FILELISTONLY 
    FROM DISK = &#39;MyDatabase.bak&#39;

    Logical Name    PhysicalName
    =============   ===============
    MyDatabase	  C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\MyDatabase.mdf
    MyDatabase_log  C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\MyDatabase_log.LDF

SQL Server: Database stuck in &quot;Restoring&quot; state

I deleted a file from a repo and now want to put it back. The best I can figure out is to:

- update to the revision before the delete
- copy the files elsewhere
- update to head
- copy the files back
- add them
- commit

That just smells bad and it looses all history to boot. There has got to be a better way to do this. I have already looked in [The SVN Book][1] but didn&#39;t find anything and am now looking down the SVN tag list.


  [1]: http://svnbook.red-bean.com/

What is the correct way to restore a deleted file from SVN?

The following figure (from [the official doc][1]) describes the well-known __lifecycle__ of an Android activity:

![enter image description here][2]

On the other hand, when the activity is destroyed by the system (for example because memory needs to be reclaimed), the state of the activity is sometimes automatically __saved and restored__ by means of the methods `onSaveInstanceState()` and `onRestoreInstanceState()`, as illustrated by the following figure (also from [the official doc][3]):

![enter image description here][4]

I&#39;m aware that `onSaveInstanceState()` is [not always called][5] when an activity is about to be destroyed. For example, if it is destroyed because the user has pressed the &quot;back&quot; button, the activity state is not preserved. But in the cases when the state _is_ saved and restored, and `onSaveInstanceState()` / `onRestoreInstanceState()` get called, __when exactly are they called__?

For example, according to the above figures, `onRestoreInstanceState()` might be called before `onStart()`,  or after `onStart()` but before `onResume()`, or after `onResume()`. Similarly, several possibilities exist for `onSaveInstanceState()`. So when are they called exactly?

Ideally, what I would like is to see a __combined diagram showing the activity lifecycle states and the save/restore methods__, if that exists.


  [1]: http://developer.android.com/training/basics/activity-lifecycle/starting.html
  [2]: http://i.stack.imgur.com/kChdb.png
  [3]: http://developer.android.com/training/basics/activity-lifecycle/recreating.html
  [4]: http://i.stack.imgur.com/RcBiQ.png
  [5]: http://developer.android.com/training/basics/activity-lifecycle/recreating.html

When exactly are onSaveInstanceState() and onRestoreInstanceState() called?

When I backup or restore a database using MS SQL Server Management Studio, I get a visual indication of how far the process has progressed, and thus how much longer I still need to wait for it to finish. If I kick off the backup or restore with a script, is there a way to monitor the progress, or do I just sit back and wait for it to finish (hoping that nothing has gone wrong?)

**Edited:** My need is specifically to be able to monitor the backup or restore progress completely separate from the session where the backup or restore was initiated.

SQL-Server: Is there a SQL script that I can use to determine the progress of a SQL Server backup or restore process?

By default, `mysqldump` takes the backup of an entire database. I need to backup a single table in MySQL. Is it possible? How do I restore it?

How to take backup of a single table in a MySQL database?

I am surprised, I couldn&#39;t find the answer to this on SO.

&gt;Can we recover/restore deleted commits in git?

For example, this is what I did:

    # Remove the last commit from my local branch
    $ git reset --hard HEAD~1
    
    # Force push the delete
    $ git push --force

Now, is there a way to get back the commit which was deleted? Does git record(log) the delete internally?


Git - Can we recover deleted commits?

When I began, I used &lt;code&gt;pg_dump&lt;/code&gt; with the default plain format.  I was unenlightened.

Research revealed to me time and file size improvements with &lt;code&gt;pg_dump -Fc | gzip -9 -c &gt; dumpfile.gz&lt;/code&gt;.  I was enlightened.

When it came time to create the database anew,

    # create tablespace dbname location &#39;/SAN/dbname&#39;;
    # create database dbname tablespace dbname;
    # alter database dbname set temp_tablespaces = dbname;

    % gunzip dumpfile.gz              # to evaluate restore time without a piped uncompression
    % pg_restore -d dbname dumpfile   # into a new, empty database defined above

I felt unenlightened:  the restore took 12 hours to create the database that&#39;s only a fraction of what it will become:

    # select pg_size_pretty(pg_database_size(&#39;dbname&#39;));
    47 GB

Because there are predictions this database will be a few terabytes, I need to look at improving performance now.

Please, enlighten me.

PostgreSQL: improving pg_dump, pg_restore performance

I need to migrate from one Mac to another, and want Sublime Text 2 on a new computer to have all the same configuration/plugins I have installed on the old one.

Is there some folder(s) I could just copy and restore on another one to replicate everything?

How to save/restore Sublime Text 2 configs/plugins to migrate to another computer?

I have implemented a `BackupAgentHelper` using the provided `FileBackupHelper` to backup and restore the native database I have. This is the database you typically use along with `ContentProviders` and which resides in `/data/data/yourpackage/databases/`.

One would think this is a common case. However the docs aren&#39;t clear on what to do: http://developer.android.com/guide/topics/data/backup.html. **There is no `BackupHelper` specifically for these typical databases. Hence I used the `FileBackupHelper`**, pointed it to my .db file in &quot;`/databases/`&quot;, introduced locks around any db operation (such as `db.insert`) in my `ContentProviders`, and even tried creating the &quot;`/databases/`&quot; directory before `onRestore()` because it does not exist after install.

I have implemented a similar solution for the `SharedPreferences` successfully in a different app in the past. However when I test my new implementation in the emulator-2.2, I see a backup being performed to `LocalTransport` from the logs, as well as a restore being performed (and `onRestore()` called). **Yet, the db file itself is never created.**

Note that this is all after an install, and before first launch of the app, after the restore has been performed. Apart from that my test strategy was based on http://developer.android.com/guide/topics/data/backup.html#Testing.

Please also note I&#39;m not talking about some sqlite database I manage myself, nor about backing up to SDcard, own server or elsewhere. 

I did see a mention in the docs about databases advising to use a custom `BackupAgent` but it does not seem related:

&gt; However, you might want to extend
&gt; BackupAgent directly if you need to:
&gt;     * Back up data in a database. If you have an SQLite database that you
&gt; want to restore when the user
&gt; re-installs your application, you need
&gt; to build a custom BackupAgent that
&gt; reads the appropriate data during a
&gt; backup operation, then create your
&gt; table and insert the data during a
&gt; restore operation.

**Some clarity please.**

If I really need to do it myself up to the SQL level, then I&#39;m worried about the following topics:

 - Open databases and transactions. I have no idea how to close them from such a singleton class outside of my app&#39;s workflow.

 - How to notify the user that a backup is in progress and the database is locked. It might take a long time, so I might need to show a progress bar.

 - How to do the same on restore. As I understand, the restore might happen just when the user has already started using the app (and inputting data into the database). So you can&#39;t presume to just restore the backupped data in place (deleting the empty or old data). You&#39;ll have to somehow join it in, which for any non-trivial database is impossible due to the id&#39;s.

 - How to refresh the app after the restore is done without getting the user stuck at some - now - unreachable point.

 - Can I be sure the database has already been upgraded on backup or restore? Otherwise the expected schema might not match.

Android backup/restore: how to backup an internal database?

I&#39;m new to postgresql, and locally, I use pgadmin3.  On the remote server, however, I have no such luxury.

 I&#39;ve already created the backup of the database and copied it over, but, is there a way to restore a backup from the command line?  I only see things related to GUI or to pg_dumps, so, if someone can tell me how to go about this, that&#39;d be terrific!

Restore a postgres backup file using the command line?

Trying to replicate a database from one system to another. The versions involved are 9.5.0 (source) and 9.5.2 (target). 

Source db name is `foodb` with owner `pgdba` and target db name will be named `foodb_dev` with owner `pgdev`.

All commands are run on the target system that will host the replica.

The `pg_dump` command is:

        pg_dump -f schema_backup.dump --no-owner -Fc -U pgdba -h $PROD_DB_HOSTNAME -p $PROD_DB_PORT -d foodb -s --clean;

This runs without errors.

The corresponding `pg_restore` is:

        pg_restore --no-owner --if-exists -1 -c -U pgdev -d foodb_dev schema_backup.dump

which throws error:

    pg_restore: [archiver (db)] Error while PROCESSING TOC:
    pg_restore: [archiver (db)] Error from TOC entry 3969; 0 0 ACL public pgdba
    pg_restore: [archiver (db)] could not execute query: ERROR:  role &quot;pgdba&quot; does not exist
    Command was: REVOKE ALL ON SCHEMA public FROM PUBLIC;
    REVOKE ALL ON SCHEMA public FROM pgdba;
    GRANT ALL ON SCHEMA public TO pgdba;
    GRANT ...

If I generate the dump file in plain text format (`-Fp`) I see it includes several entries like:
    
    REVOKE ALL ON TABLE dump_thread FROM PUBLIC;
    REVOKE ALL ON TABLE dump_thread FROM pgdba;
    GRANT ALL ON TABLE dump_thread TO pgdba;
    GRANT SELECT ON TABLE dump_thread TO readonly;

that try to set privileges for user `pgdba` who of course doesn&#39;t even exist as a user on the target system which only has user `pgdev`, and thus the errors from `pg_restore`.

On the source db the privileges for example of the `dump_thread` table:
    
    # \dp+ dump_thread
    Access privileges
    -[ RECORD 1 ]-----+--------------------
    Schema            | public
    Name              | dump_thread
    Type              | table
    Access privileges | pgdba=arwdDxt/pgdba+
                      | readonly=r/pgdba
    Column privileges |
    Policies          |


A quick solution would be to simply add a user `pgdba` on the target cluster and be done with it. 

But shouldn&#39;t the `--no-owner` take care of not including owner specific commands in the dump in the first place?

pg_restore error: role XXX does not exist

I have a server that hosts my Subversion code base. That server is currently a [Windows Server 2003][1] box, and my IT administrator wants to update it to [Windows Server 2008][2].

This means that I&#39;m going to need to move my Subversion repository while the server gets built up and was wondering what the best practices are for moving the repository to a new server.

It seems like, looking online, the recommended way is to use:

    svnadmin dump /path/to/repository &gt; repository-name.dmp

And then use:

    svnadmin create repository-name
    svnadmin load repository-name&lt; repository-name.dmp

To import the repository.

Does the method above seem like the best approach?

  [1]: http://en.wikipedia.org/wiki/Windows_Server_2003
  [2]: http://en.wikipedia.org/wiki/Windows_Server_2008




All Restore Solutions on Gang of Coders

Total of 23 Restore Solutions