Error: Stripe requires 2 file(s) for restore

The answer is just what the sql litespeed gave you. you need more than one file (2 here) to restore.

INTERVIEW PREPARATION IN 30 MINs – Read Following wires for a quick interview preparation.

  1. SQL Server DBA “Interview Questions And Answers”
  2. SQL Azure Interview Questions and Answers Part – 1
  3. SQL Azure Interview Questions and Answers Part – 2
  4. Powershell Interview Questions and Answers

EXEC master.dbo.xp_RESTORE_VERIFYONLY
@filename = ‘j:\mssql\Databaseone\DB_1of2.LSB’
,@filename = ‘j:\mssql\Databaseone\DB_2of2.LSB’

You just need to search the backup file which is missing. You can use powershell code to find this.

D:> get-childitem -recurse | where-object {$_.name -like “*DB_2of2*”}

Very Important Technical Wires:

  1. SQL Server DBA “Interview Questions And Answers”
  2. MS SQL Corruption: “Msg 2627 – Violation of PRIMARY KEY constraint”
  3. SQL Server 2008 R2 – Foreign Key – DELETE CASCADE and DELETE UDPATE
  4. MSSQL Server – DBCC LOGINFO – Status 2. Log File FULL. Verify log_reuse_wait_desc
  5. SSRS Report – Adding Header and Footer

Regards,
Online PowerShell Classes @ http://tuitionaffordable.webstarts.com

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s