MajorMinor

100

I have changed it to '0' and it printed the command.

Now I am trying to add diff and log files for restore. I will keep you posted if anything.

Thank you...

Thank you for your reply. I was using sql2008 and sql 2012

This is from 2008

Now it says command completed successfully ,but no command printed, I don't see those tables in...

Here is what I got:

BackupNameBackupDescriptionBackupTypeExpirationDateCompressedPositionDeviceTypeUserNameServerNameDatabaseNameDatabaseVersionDatabaseCreationDateBackupSizeFirstLSNLastLSNCheckpointLSNDatabaseBackupLSNBackupStartDateBackupFinishDateSortOrderCodePageUnicodeLocaleIdUnicodeComparisonStyleCompatibilityLevelSoftwareVendorIdSoftwareVersionMajorSoftwareVersionMinorSoftwareVersionBuildMachineNameFlagsBindingIDRecoveryForkIDCollationFamilyGUIDHasBulkLoggedDataIsSnapshotIsReadOnlyIsSingleUserHasBackupChecksumsIsDamagedBeginsLogChainHasIncompleteMetaDataIsForceOfflineIsCopyOnlyFirstRecoveryForkIDForkPointLSNRecoveryModelDifferentialBaseLSNDifferentialBaseGUIDBackupTypeDescriptionBackupSetGUIDCompressedBackupSize

Dummy_backup_2014_04_24_142404_6342177NULL1NULL112NT AUTHORITY\SYSTEMDummyInstanceDummy6552013-12-09 15:22:31.0005596160590000000461000375900000004770000159000000046100037590000000436000372014-04-24 14:24:05.0002014-04-24 14:24:05.000520103319660910046081001600DummyInstance5125DBEB00A-CEC3-4AF6-8752-8D1C5B20C4E16A68F82C-88F7-492A-BEC8-B55ABC7B3C63SQL_Latin1_General_CP1_CI_AS6A68F82C-88F7-492A-BEC8-B55ABC7B3C6300000000006A68F82C-88F7-492A-BEC8-B55ABC7B3C63NULLSIMPLENULLNULLDatabase0E70B246-6128-4CAB-9070-72ED0858EEA52004365

That was great. Very handy for DR. I am trying to restore all user databases with one script after restoring system databases.

I am having this error with that script:

I must...