This happens if, when you made the backup, you had multiple files listed in the backup destination textbox.  Go back to your source server and create the backup again; this time, make sure there&#39;s only one destination file listed.

If you had more than one file listed as the backup destination, the backup is striped across them; you&#39;ll need all the files to perform the restore.

You can verify this by performing a RESTORE LABELONLY against the single file you copied to your destination server.

[Sandra Walter&#39;s Answer][1] provides an accurate description of what has happened, but I found the answer a bit lacking.

To make a backup which isn&#39;t striped (which is what has occurred in this situation), go back to the window where you setup the backup of your database. At the bottom is a list of paths where the different stripes will go to.

Go to each of the listed paths and delete the stripe of the backup.

Then remove all but one of the paths from the list in the window. And click the &quot;OK&quot; button. Your unstriped backup will be created at that one path.

Hope that helps.

  [1]: https://stackoverflow.com/a/15892786/901641

My backup was scheduled on two different locations. once I selected both options during restoration its worked for me. 

I have some docs in mongo that looks something like this: 

    {
      _id : ObjectId(&quot;...&quot;),
      &quot;make&quot; : &quot;Nissan&quot;,
      ..
    },
    {
      _id : ObjectId(&quot;...&quot;),
      &quot;make&quot; : &quot;Nissan&quot;,
      &quot;saleDate&quot; :  ISODate(&quot;2013-04-10T12:39:50.676Z&quot;),
      ..
    }

Ideally, I&#39;d like to be able to count, by make, the number of vehicles sold per day.  I&#39;d then like to view either today, or a window such as today through the last seven days.

I was able to accomplish the daily view with some ugly code

    db.inventory.aggregate(
      { $match : { &quot;saleDate&quot; : { $gte: ISODate(&quot;2013-04-10T00:00:00.000Z&quot;), $lt: ISODate(&quot;2013-04-11T00:00:00.000Z&quot;)  } } } ,
      { $group : { _id : { make : &quot;$make&quot;, saleDayOfMonth : { $dayOfMonth : &quot;$saleDate&quot; } }, cnt : { $sum : 1 } } }
    )

Which then yields the results

    {
      &quot;result&quot; : [
        {
          &quot;_id&quot; : {
            &quot;make&quot; : &quot;Nissan&quot;,
            &quot;saleDayOfMonth&quot; : 10
          },
          &quot;cnt&quot; : 2
        },
        {
          &quot;_id&quot; : {
            &quot;make&quot; : &quot;Toyota&quot;,
            &quot;saleDayOfMonth&quot; : 10
          },
          &quot;cnt&quot; : 4
        },
      ],
      &quot;ok&quot; : 1
    }

So that is ok, but I would much prefer to not have to change the two datetime values in the query.  Then, as I mentioned above, I&#39;d like to be able to run this query (again, without having to modify it each time) and see the same results binned by day over the last week.

Oh and here is the sample data I&#39;ve been using for the query

    db.inventory.save({&quot;make&quot; : &quot;Nissan&quot;,&quot;saleDate&quot; :  ISODate(&quot;2013-04-10T12:39:50.676Z&quot;)});
    db.inventory.save({&quot;make&quot; : &quot;Nissan&quot;});
    db.inventory.save({&quot;make&quot; : &quot;Nissan&quot;,&quot;saleDate&quot; :  ISODate(&quot;2013-04-10T11:39:50.676Z&quot;)});
    db.inventory.save({&quot;make&quot; : &quot;Toyota&quot;,&quot;saleDate&quot; :  ISODate(&quot;2013-04-09T11:39:50.676Z&quot;)});
    db.inventory.save({&quot;make&quot; : &quot;Toyota&quot;,&quot;saleDate&quot; :  ISODate(&quot;2013-04-10T11:38:50.676Z&quot;)});
    db.inventory.save({&quot;make&quot; : &quot;Toyota&quot;,&quot;saleDate&quot; :  ISODate(&quot;2013-04-10T11:37:50.676Z&quot;)});
    db.inventory.save({&quot;make&quot; : &quot;Toyota&quot;,&quot;saleDate&quot; :  ISODate(&quot;2013-04-10T11:36:50.676Z&quot;)});
    db.inventory.save({&quot;make&quot; : &quot;Toyota&quot;,&quot;saleDate&quot; :  ISODate(&quot;2013-04-10T11:35:50.676Z&quot;)});

Thanks in advance,
Kevin


MongoDB aggregate within daily grouping

I know i can do something like 

    ## brew info FORMULA_NAME
    brew info wgetpaste
    
## Output

    wgetpaste: stable 2.20
    http://wgetpaste.zlin.dk/
    Not installed
    https://github.com/mxcl/homebrew/commits/master/Library/Formula/wgetpaste.rb

Then i can follow the url to get some info about the formula before installing. Do we have any way to get this info in command line using brew?

How can i get more info about a brew formula before installing?

I have backed up a database I had created on an other machine running SQL server 2012 express edition and I wanted to restore it on my machine, which is running the same. I have ticked the checkbox overwriting existing one, and got this error:


    Backup mediaset is not complete. Files: D:\question.bak. Family count:2. Missing family sequence number:1	




sql server restoring back up error

I have backed up a database I had created on an other machine running SQL server 2012 express edition and I wanted to restore it on my machine, which is running the same. I have ticked the checkbox overwriting existing one, and got this error:
<pre><code class="hljs language-csharp">Backup mediaset is not complete. Files: D:\question.bak. Family count:2. Missing family sequence number:1	
</code></pre>

I&#39;m in the process of moving my files onto another computer, and one thing I would like to do is to transfer the data in my MySQL database. I want to dump the databases into .sql files, but also have the create database db_name including in the file, that way I just have to import the file to mysql without having to manually create the databases. Is there a way to do that?

mysqldump with create database line

How can I make a backup of my meteor mongo database?

If I run:

    meteor mongo

the mongodump command does not work inside the meteor mongoshell

meteor: how can I backup my mongo database

I am in the process of writing a PowerShell script for backing up a Windows computer using rsync. To this end, I am attempting to use WMI from said script to create a non-persistent Shadow copy with writer participation (as is apparently recommended for backups).

I found out from another question ([Accessing Volume Shadow Copy (VSS) Snapshots from powershell][1]) a way to create a shadow copy in general, but the example given there uses &quot;ClientAccessible&quot; as the context parameter, which results in the creation of a persistent Shadow Copy, without writer participation.

While searching for a solution, I have found that I could use the following command to obtain a list of contexts, which I assume are understood by WMI:

    Get-WmiObject win32_shadowcontext | Out-GridView

It does the list have a context named &quot;Backup&quot;, which is conveniently what I want. I proceeded to attempt creating a non-persistent shadow copy using that context:

    $shadow = (Get-WmiObject -list win32_shadowcopy).Create(&quot;C:\&quot;, &quot;Backup&quot;)

However, this seems to fail and the content of the **$shadow** variable is set to

    ReturnValue      : 5
    ShadowID         : {00000000-0000-0000-0000-000000000000}

According to the relevant documentation ([Create method of the Win32_ShadowCopy class][2]), the return value means &quot;Unsupported shadow copy context.&quot;

I couldn&#39;t find any relevant documentation as to why this context is unsupported or whether it is possible to use it at all. I have also tried the &quot;FileShareBackup&quot; and &quot;AppRollback&quot; contexts without success.

I assume I am either missing something obvious, or that for some reason, WMI really doesn&#39;t support anything else than &quot;clientAccessible&quot; when creating shadow copies, or that this is OS-dependent (I am testing this on Windows 7, 64-bit)

How can I get this to work?

  [1]: https://stackoverflow.com/questions/14207788/accessing-volume-shadow-copy-vss-snapshots-from-powershell
  [2]: http://msdn.microsoft.com/en-us/library/windows/desktop/aa389391(v=vs.85).aspx

Creating a shadow copy using the &quot;Backup&quot; context in a PowerShell

I&#39;m looking for some advice or best practice to back up S3 bucket.  
The purpose of backing up data from S3 is to prevent data loss because of the following:  

 1. S3 issue
 2. issue where I accidentally delete this data from S3

After some investigation I see the following options:

 1. Use versioning http://docs.aws.amazon.com/AmazonS3/latest/dev/Versioning.html  
 2. Copy from one S3 bucket to another using AWS SDK
 3. Backup to Amazon Glacier http://aws.amazon.com/en/glacier/
 4. Backup to production server, which is itself backed up

What option should I choose and how safe would it be to store data only on S3? Want to hear your opinions.  
Some useful links:

 - [Data Protection Documentation][1]
 - [Data Protection FAQ][2]

  [1]: http://docs.aws.amazon.com/AmazonS3/latest/dev/DataDurability.html
  [2]: http://aws.amazon.com/s3/faqs/#How_durable_is_Amazon_S3

Backup strategies for AWS S3 bucket

I am running an android 4.0.3 device, and I want to extract the back up file created by :
    
    adb backup -f ~/data.ab -noapk app.package.name

The above line works inside the CMD (windows) and I am able to get the data.ab file inside the &#39;~&#39; directory. 

What I can&#39;t do is extact that file using CMD . I tried the below two methods.

    dd if=data.ab bs=1 skip=24 | openssl zlib -d | tar -xvf -

    dd if=data.ab bs=1 skip=24 | python -c &quot;import zlib,sys;sys.stdout.write(zlib.decompress(sys.stdin.read()))&quot; | tar -xvf -

I get the below error

![error][1]

I tried extracting it via CYGWIN, however, I failed too.

![error][2]

Where should I do the extraction ? In which directory should my command prompt be ? Any insights ?


  [1]: http://i.stack.imgur.com/q2VrC.png
  [2]: http://i.stack.imgur.com/5lBLz.png

How to extract or unpack an .ab file (Android Backup file)

I have a query in `SQL`, I have to get a date in a format of `dd/mm/yy` 

Example: `25/jun/2013`. 

How can I `convert` it for `SQL server`?

Convert Date format into DD/MMM/YYYY format in SQL Server

I am using Sql server 2012(Denali). I wonder why all identity column values start from 1001 and so on. At the beginning `Identity` column starts from 1,2 and so on and adding identity smoothly, but suddenly it jumps to 1001,1002 and onwards for all the table in the database containing identity column. What could be the reason? Please assist.

Identity column value suddenly jumps to 1001 in sql server

I have moved one of our databases (DB1) from SQL Server 2008 to 2012 and when I run the stored procedures I get the following error

&gt; Cannot resolve the collation conflict between &quot;SQL_Latin1_General_CP1_CI_AS&quot; and &quot;Latin1_General_CI_AS&quot; in the equal to operation

I changed the collation on the database using 

    ALTER DATABASE [optimiser] SET SINGLE_USER WITH ROLLBACK IMMEDIATE
    ALTER DATABASE [optimiser] COLLATE SQL_Latin1_General_CP1_CI_AS
    ALTER DATABASE [optimiser] SET MULTI_USER

But I still get the error whenever the stored procedures run. I believe because the SP is using a join to another database (GE&#39;s ihistorian) and it has a collation mismatch. IS there anyway to resolve this.

On the old server DB1 was set as `Latin1_General_CI_AS` and this works fine. The new location for the DB has a default of `SQL_Latin1_General_CP1_CI_AS`. Is it worth changing the collation n DB1 on the new server back to `Latin1_General_CI_AS`??

Cannot Resolve Collation Conflict

I have a 123MB sql file which I need to execute in my local PC. But I am getting 

    Cannot execute script: Insufficient memory to continue the execution of the program

![enter image description here][1]

How to solve this issue?


  [1]: http://i.stack.imgur.com/hV4C6.png

Cannot execute script: Insufficient memory to continue the execution of the program

I am using C# and WPF - Operating System is windows 7 Professional and Visual Studio 2012, SQL Server 2012.

I used Devexpress Grid in wpf. I want to bind it to database using ADO.Net Server mode. I selected &quot;Items Source Wizard&quot; Option to do this binding but it generated following Exception:

&gt; InvalidOperationException: Cannot load Counter Name data because an invalid index &#39;&#39; was read from the registry.

**What does this exception mean?**

Can you please help me to resolve this issue.

Thanks,
Annie.

Cannot load Counter Name data because an invalid index -Exception

I have created a `.pgpass` file in my home directory which looks like this

`localhost:5432:somedb:someuser:somepass`

I am using a shell script which creates a directory and puts a pg_dump of `somedb` there :

    mkdir directory
    pg_dump somedb &gt; directory/somefile.dump

It still prompts for the password.
 
Where is the mistake here ?

postgresql: .pgpass not working

How to take database backup using MySQL Workbench? Can we take backup in the following ways-

 1. Backup file(.sql) contains both Create Table statements and Insert into Table Statements
 2. Backup file(.sql) contains only Create Table Statements, not Insert into Table statements for all tables
 3. Backup file(.sql) contains only Insert into Table Statements, not Create Table statements for all tables



How to take MySQL database backup using MySQL Workbench?

I have a `.bak` file, and I want to use this file to recreate the database in a fresh install of SQL Server 2008 Management Studio.

Can someone point me in the right direction on how this can be done?

I have tried:

1. right click on the Databases container within object explorer

2. from context menu select Restore database

3. Specify To Database as either a new or existing database

4. Specify Source for restore as from device

5. Select Backup media as File

6. Click the Add button and browse to the location of the BAK file

but I am getting error that 

&gt; Restore failed for Server &#39;MyServer-PC&#39;.  (Microsoft.SqlServer.SmoExtended)
&gt;
&gt; ADDITIONAL INFORMATION:
&gt;
&gt; System.Data.SqlClient.SqlError: The backup set holds a backup of a database other than the existing &#39;invent&#39; database. (Microsoft.SqlServer.Smo)


How to import a bak file into SQL Server Express

I have a Django application that uses a Postgres database.  I need to be able to backup and restore the db, both to ensure no data is lost and to be able to copy data from the production server to the development server during testing.

There seem to be a few different ways to do this:

1. Just interact with the db directly.  So, for Postgres I might write a script using `pg_dumpall` and `psql`.

2. Use the `sqlclear`/`sqlall` commands that come with Django.

3. Use the `dumpdata`/`loaddata` commands that come with Django.  So create new fixtures from the db you want to backup and then load them into the db you want to restore.

4. Use a Django plugin like [django-dbbackup](https://pypi.python.org/pypi/django-dbbackup).

I really don&#39;t understand the pros/cons of these different techniques.  

Just off the top of my head: Option 1 is database-specific and option 3 seems more suited to setting up initial data.  But I&#39;m still not sure what advantages option 4 has over option 2.


how to backup a django db

I did backup on database on different server and that has different role than I need, with this command:

    pg_dump -Fc db_name -f db_name.dump

Then I copied backup to another server where I need to restore the database, but there is no such owner that was used for that database. Let say database has owner `owner1`, but on different server I only have `owner2` and I need to restore that database and change owner.

What I did on another server when restoring:

    createdb -p 5433 -T template0 db_name 
    pg_restore -p 5433 --role=owner2 -d db_name db_name.dump

But when restore is run I get these errors:

    pg_restore: [archiver (db)] could not execute query: ERROR:  role &quot;owner1&quot; does not exist

How can I specify it so it would change owner? Or is it impossible?


Content Type	Original Author	Original Content on Stackoverflow
Question	danarj	View Question on Stackoverflow
Solution 1 - Backup	SWalters	View Answer on Stackoverflow
Solution 2 - Backup	ArtOfWarfare	View Answer on Stackoverflow
Solution 3 - Backup	Hamid	View Answer on Stackoverflow

sql server restoring back up error

Backup Problem Overview

Backup Solutions

Solution 1 - Backup

Solution 2 - Backup

Solution 3 - Backup

How can i get more info about a brew formula before installing?

MongoDB aggregate within daily grouping

Attributions