Viewing 15 posts - 286 through 300 (of 391 total)
Ran these after backing up BCC_DB.... just in case
Results:
BackupNameBackupDescriptionBackupTypeExpirationDateCompressedPositionDeviceTypeUserNameServerNameDatabaseNameDatabaseVersionDatabaseCreationDateBackupSizeFirstLSNLastLSNCheckpointLSNDatabaseBackupLSNBackupStartDateBackupFinishDateSortOrderCodePageUnicodeLocaleIdUnicodeComparisonStyleCompatibilityLevelSoftwareVendorIdSoftwareVersionMajorSoftwareVersionMinorSoftwareVersionBuildMachineNameFlagsBindingIDRecoveryForkIDCollationFamilyGUIDHasBulkLoggedDataIsSnapshotIsReadOnlyIsSingleUserHasBackupChecksumsIsDamagedBeginsLogChainHasIncompleteMetaDataIsForceOfflineIsCopyOnlyFirstRecoveryForkIDForkPointLSNRecoveryModelDifferentialBaseLSNDifferentialBaseGUIDBackupTypeDescriptionBackupSetGUID
BCC_DB_backup_20150502001758NULL1NULL012NBCC-US\sqlAgentProxyBADLANDSBCC_DB6112011-06-21 16:21:42.000149130241820000006038002001820000006119000011820000006038002001820000005788002112015-05-02 00:18:01.0002015-05-02 00:18:01.0005201033196609904608904035BADLANDS512AF0B1488-EC09-4A5B-8B76-8684265F1ED84AEB5E8D-063E-47B4-AD55-B2277D2E8E0DSQL_Latin1_General_CP1_CI_AS4AEB5E8D-063E-47B4-AD55-B2277D2E8E0D00000000004AEB5E8D-063E-47B4-AD55-B2277D2E8E0DNULLFULLNULLNULLDatabase97CA0278-5202-4DD4-A29C-B901D707134E
LogicalNamePhysicalNameTypeFileGroupNameSizeMaxSizeFileIdCreateLSNDropLSNUniqueIdReadOnlyLSNReadWriteLSNBackupSizeInBytesSourceBlockSizeFileGroupIdLogGroupGUIDDifferentialBaseLSNDifferentialBaseGUIDIsReadOnlyIsPresent
BCCD:\Databases\Data\BCC.mdfDPRIMARY15728640351843720806401007174C4FC-9F7D-4140-B3FE-E330A0B77D0500141557765121NULL1820000005788002113DFC4FD7-AAF5-445F-980B-6EB90138AF3F01
BCC_logD:\Databases\Data\BCC_log.ldfLNULL1855324162199023255552200E4224B52-1752-461D-ACB3-806DBF9C96E10005120NULL000000000-0000-0000-0000-00000000000001
May 18, 2015 at 2:19 pm
RESTORE DATABASE BCCrestore
FROM DISK = 'C:\BCC_DB_backup_201505020017.bak'
WITH MOVE 'BBC' TO 'D:\Databases\Data\BCCrestore.mdf',
MOVE 'BBC_log' TO 'D:\Databases\Data\BCCrestore_log.ldf',
REPLACE,
STATS = 10;
GO
Msg...
May 18, 2015 at 2:15 pm
RESTORE DATABASE BCCrestore
FROM DISK = 'D:\BCC_DB_backup_201505020017.bak'
WITH MOVE 'BCC' TO 'D:\Databases\Data\BCCrestore.mdf',
MOVE 'BCC_log' TO 'D:\Databases\Data\BCCrestore_log.ldf'
WITH REPLACE;
GO
Msg 319, Level 15, State 1, Line 5
Incorrect syntax near the keyword 'with'. If this statement...
May 18, 2015 at 2:09 pm
I want to restore to BCCrestore, not my production database. Are these safe to run?:
restore headeronly from DISK = 'D:\BCC_DB_backup_201505020017.bak'
restore filelistonly from DISK = 'D:\BCC_DB_backup_201505020017.bak'
May 18, 2015 at 2:07 pm
This is not something I will be doing on a regular basis as I am just filling in for a DBA on sick-leave. I just need to get irate users...
May 18, 2015 at 2:04 pm
RESTORE DATABASE BCCrestore
FROM DISK = 'D:\BCC_DB_backup_201505020017.bak'
WITH MOVE 'BCC' TO 'D:\Databases\Data\BCCrestore.mdf',
MOVE 'BCC_log' TO 'D:\Databases\Data\BCCrestore_log.ldf';
GO
Msg 3154, Level 16, State 4, Line 1
The backup set holds a backup...
May 18, 2015 at 1:44 pm
My system administrator, whom I've just spoken with this morning, does not understand the questions raised on these posts. He suggested mapping the \\Belmont\ server locally to my Z:\ drive.
May 18, 2015 at 1:42 pm
I verified that those objects existed in the paths I used below and still got an error:
RESTORE DATABASE BCCrestore
FROM DISK = 'Z:\BCC_DB_backup_201505020017.bak'
WITH MOVE 'BCC' TO 'Z:\Databases\Data\BCCrestore.mdf',
...
May 18, 2015 at 1:23 pm
I ran xp_fixeddrives and saw:
drive | MB free
C | 45177
D | 314619
but...
May 18, 2015 at 11:55 am
My system admin says \\Belmont has no drives mapped within itself.
May 18, 2015 at 9:50 am
How do I discover the drives on this \\belmont server?
May 18, 2015 at 9:29 am
I'm not sure what you mean by a 'drive' on the server... all I can get to is \\belmont\c$ and the \\belmont\Databases\Data which is where I see BCCrestore.mdf and BCCrestore_log.ldf
May 15, 2015 at 2:42 pm
running this gives errors too:
RESTORE DATABASE BCCrestore
FROM DISK = '\\belmont\c$\BCC_DB_backup_201505030017.bak'
WITH MOVE 'BCC' TO '\\belmont\Databases\Data\BCCrestore.mdf',
MOVE 'BCC_log' TO '\\belmont\Databases\Data\BCCrestore_log.ldf',
REPLACE,
...
May 15, 2015 at 2:24 pm
With the first block of code I get this:
Msg 3201, Level 16, State 2, Line 1
Cannot open backup device '\\belmont\c$\BCC_DB_backup_201505030017'. Operating system error 2(The system cannot find the file specified.).
plus...
May 15, 2015 at 2:05 pm
Viewing 15 posts - 286 through 300 (of 391 total)