August 8, 2009 at 3:00 am
i m trying to restore DB but im getting foll error
query is
restore database Matrix09 from disk ='D:\Marix09.bak' with
move 'ClientProfitability' to 'E:\temp\Marix09_data.mdf',
move 'ClientProfitability_log' to 'E:\temp\Marix09_Log.ldf',
stats=1
error:-
Msg 3132, Level 16, State 1, Line 2
The media set has 2 media families but only 1 are provided. All members must be provided.
Msg 3013, Level 16, State 1, Line 2
RESTORE DATABASE is terminating abnormally.
i tried foll. but couldn't get any info.
restore filelistonly from disk='D:\Marix09.bak'
O\P
LogicalNamePhysicalNameTypeFileGroupNameSizeMaxSizeFileIdCreateLSNDropLSNUniqueIdReadOnlyLSNReadWriteLSNBackupSizeInBytesSourceBlockSizeFileGroupIdLogGroupGUIDDifferentialBaseLSNDifferentialBaseGUIDIsReadOnlyIsPresent
ClientProfitabilityF:\ALLSQLDB\Matrix09\Matrix09.mdfDPRIMARY47785574403.51844E+13100546B3F41-9C44-48D3-A502-E0D5232AA97B0047779676165121NULL1.6227E+1964A34F4B-16D7-4837-9483-5D998DAC276D01
ClientProfitability_logF:\ALLSQLDB\Matrix09\Matrix09_log.ldfLNULL87900162.19902E+1220030062C44-1D3B-4942-AA30-35F05264CBC10005120NULL000000000-0000-0000-0000-00000000000001
then i tried,
restore headeronly from disk='D:\Marix09.bak'
O\P
BackupNameBackupDescriptionBackupTypeExpirationDateCompressedPositionDeviceTypeUserNameServerNameDatabaseNameDatabaseVersionDatabaseCreationDateBackupSizeFirstLSNLastLSNCheckpointLSNDatabaseBackupLSNBackupStartDateBackupFinishDateSortOrderCodePageUnicodeLocaleIdUnicodeComparisonStyleCompatibilityLevelSoftwareVendorIdSoftwareVersionMajorSoftwareVersionMinorSoftwareVersionBuildMachineNameFlagsBindingIDRecoveryForkIDCollationFamilyGUIDHasBulkLoggedDataIsSnapshotIsReadOnlyIsSingleUserHasBackupChecksumsIsDamagedBeginsLogChainHasIncompleteMetaDataIsForceOfflineIsCopyOnlyFirstRecoveryForkIDForkPointLSNRecoveryModelDifferentialBaseLSNDifferentialBaseGUIDBackupTypeDescriptionBackupSetGUID
Matrix09-Full Database BackupNULL1NULL012clientprofitabilityuatEDEMUMCHMUAT001Matrix0961104:40.047794954242.3501E+192.3501E+192.3501E+191.6227E+1918:16.023:12.05201033196609904608904035EDEMUMCHMUAT0015127B92357E-520A-40FE-B42A-367EFECF9DF3F271992C-B53B-4688-88CD-971774877AE0SQL_Latin1_General_CP1_CI_ASBCE7B640-43A8-42B6-923C-E639EED8FD950000000000F271992C-B53B-4688-88CD-971774877AE0NULLFULLNULLNULLDatabase3831BEB4-8DD0-4577-854F-7FEB2A523372
Sanket Ahir
Don't run behind the success, Try to be eligible & success will run behind u......
August 8, 2009 at 4:23 am
This backup of your database has been created using multiple backup files !
You need all files of that backup(set) to restore the database.
http://msdn.microsoft.com/en-us/library/ms186858.aspx
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply