ok sorry for my misunderstanding but I thought that is why you do Log backups to commit the data to the DB and clear the transaction data from the Log...

Ok a strange thing regarding the log.

1. This backup has been about 30GB for quite sometime and we do full daily log backups and hourly append log backups from a...

I ran DBCC UPDATEUSAGE (DCCS_Berea_Prod)

The Messages say:

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

DB size when still going into properties shows 33033.63 MB with space available...

I don't see anything obvious. Does anyone else see anything that can shine some light?

RESTORE HEADERONLY

FROM DISK = N'H:\Backup\PROD\File.bak'

Ok here is the run against a DB that was normal back from 5/10 (23GB).

BackupNameBackupDescriptionBackupTypeExpirationDateCompressedPositionDeviceTypeUserNameServerNameDatabaseNameDatabaseVersionDatabaseCreationDateBackupSizeFirstLSNLastLSNCheckpointLSNDatabaseBackupLSNBackupStartDateBackupFinishDateSortOrderCodePageUnicodeLocaleIdUnicodeComparisonStyleCompatibilityLevelSoftwareVendorIdSoftwareVersionMajorSoftwareVersionMinorSoftwareVersionBuildMachineNameFlagsBindingIDRecoveryForkIDCollationFamilyGUIDHasBulkLoggedDataIsSnapshotIsReadOnlyIsSingleUserHasBackupChecksumsIsDamagedBeginsLogChainHasIncompleteMetaDataIsForceOfflineIsCopyOnlyFirstRecoveryForkIDForkPointLSNRecoveryModelDifferentialBaseLSNDifferentialBaseGUIDBackupTypeDescriptionBackupSetGUIDCompressedBackupSize

DCCS_Berea_Prod_backup_2014_05_10_120543_8628395NULL1NULL012NT AUTHORITY\SYSTEMSTM5SQL201DCCS_Berea_Prod6612013-03-07 14:12:04.000235295825929780000067134000011414000006225600001141400000619070023414130000220105002772014-05-10 12:05:43.0002014-05-10 12:08:22.0005201033196609100460810504000STM5SQL201512C741A600-E7A4-465E-94DB-6AA2D0D1DDCC480D4267-C73C-412E-8666-3158C7D089E3SQL_Latin1_General_CP1_CI_AS5BBDC064-4247-4123-818D-1FAEE6A366430000000000480D4267-C73C-412E-8666-3158C7D089E3NULLFULLNULLNULLDatabase3D1279EB-D33C-4854-A413-C3C7183770A923529582592

Here is the result from the...

Server properties for backup and restore

show compress backup unchecked

It is set to use the Server Default setting and has always been set this way. How can I check what the system default is as I have never...

It is 27MB of free space.

To be exact:

from the general page:

Size: 33033.63MB

Space Available: 31.95MB

searching I finally found an answer.

GilaMonster

I find it strange when you double them it puts in the single quote. Thanks for the...

Lynn this looks pretty good I have to review it a bit more but so far it looks like this is exactly what I'm looking for.

Thanks, sorry for being a...

I'm looking to only see this data:

('111','PC1')

which I'm not getting from the query as it seems like what it is doing is including all results where java is not found...

ok doing my best here to duplicate what you are asking:

CREATE TABLE dbo.vComputer(

Guid VARCHAR(128),

Name VARCHAR(128)

);

GO

INSERT INTO dbo.vcomputer(Guid, name)

VALUES ('333','PC1'),

...

This is returning every system in the dB including the ones which my query locates.

I think this needs to basically bring up all systems distinct and remove what is found...

We don't use the snaps as a backup method. It is strictly for rollback purposes if an update messes up.

I have yet to ever have to roll a snapshot...

So do you suggest I only move on to the backup and everything else...