Dear MS project manager,

If you Bing with this error , you will find many hits .people are complaining a lot .As an EX-MSian i thought its my duty to show you whats happening here and why .

First just go through this link :http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/abf50e00-c9b0-4809-9e61-43ed8a53e968

Now , you will see the people are complaining that they are not taking any stripped backup but still by default SQL is taking a stripped backup if more than one device is existing .This is happening by default .

Why this is a Bug : A repro

USE master
GO
EXEC master.dbo.sp_addumpdevice
    @devtype = N'disk',
    @logicalname = N'Anoop_issue',
    @physicalname = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\Anoop_issue.bak'
GO

EXEC master.dbo.sp_addumpdevice
    @devtype = N'disk',
    @logicalname = N'Anoop_issue1',
    @physicalname = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\Anoop_issue1.bak'
GO

-> right click adventure works database > Tasks > backup
-> Under Destination remove anything if its mentioned by default.
-> Click on Add > a new box will pop up > select backup device
-> you will get anoop_issue > click on OK.
-> Again click on Add >a new box will pop up > select another backup device .
-> You will see that both the backup devices are unselected now (",).

if now you click ok it will take the backup .Ideally it should give the error that "please select the device".

It should not take the stripped backups by default if more than one devices exist .

Or we should document it .Ideally i feel that it should prompt us to select any device .

Regards
Abhay


Msg 3132, Level 16, State 1, Line 1
The media set has 2 media families but only 1 are provided. All members must be provided.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.