?? ?? ???? ??????? ?? ??????? ?? ????? ???? ?? ??? VSS ?? ????? SQL ????? ??? ????? ???????? backupset ?????? ?????? ??? ??????

???? ?????? ???? ??????
???? ID: 951288 - ?? ???????? ?? ?????? ??? ?? ?? ???? ???? ???? ??.
??? ?? ??????? ???? | ??? ?? ??????? ????

?? ????? ??

?????

?? ???????? ?? ????? ????? ?? Microsoft SQL Server ???? ??????? ?? ??????? ????? ?? ??????? ?? ??????? ?? ????? ???? ?? ??? ???? ??????? ???? ????? ???? (VSS) ????????? ?? ????? ????? ?? ???????? ???, SQL ????? ??? ????? ???????? backupset ?????? ?????? ??? ??????? ???? ??? ??? ???? ??????? ??????? ' % ws ' ?? SQL ????? ?????? ??? ???? ??? ???? ???? ?? ?? ?? ?????? ???? ???

??? NTBackup.exe ?????? ?? ??? ????????? VSS.

????

?? ?????? ????? ???? ?? ??????? VSS ??? SQLWriter ???? ?? Microsoft SQL Server ???????? ????? (MSDE) ?????

??????

Microsoft ?? ?? ?? ???????? Microsoft ???????? ??? ?? ?????? ?? ?????? ?? ?? "?? ?? ????" ??? ??? ???

???? ???????

MSDE ???? ?? SQLWriter ???? ?? ?????

MSDE ???? ??? VSS ????? Windows XP ??? ????? ??, ?? Windows ????? 2003? VSS ????? ?? ??? MSDE ???? ?? ????? ???? ?? SQL Server 2000 ???????? SQLWriter ???? ?? ?? ??????? SQL Server 2005 ??????? ??? ????? ??? ???? ???? ?? ??? VSS SQLWriter ???? ?? ????? ???? ?? SQL ????? 2005 ??????? ?? SQL Server 2000 ????????

???? VSS ????? ???????? ???? ??

VSS ???? ??????? ?? ??? ????? ???????? ???? ??, ?? VSS ??? ??? ????? ??????? ?? ???? ??? ?? ????? ?? ????????? ???? ?? ????? ??? ?? VSS ???? SQLWriter ?? MSDE ????, ??? SQLWriter ???? ?? MSDE ???? ??????? backupset ??? ???????? ???? ?? ?????? ??????? ?? ??? ????? ???????? ???? ??? ?? ??????? ?????? ?? ???? ??? ???????, SQLWriter ????, ?? MSDE ???? ????????? ???? ?? ???? VSS ????? ??????? ???? ???. ??????? ??????? ????

??? ?? ???? ????????????? ?? ??? backupset ?????? ?????? ??? ???????????? ????? ??? ???? ?? ??? ??????????

Backupset ?????? ?????? ??? ???????????? ?? ??? ???? ?? ????? ???? ????? ???, ?? ?????????????, ?? ???????????? ???????? ??????? ????? ??????? ??? ???????? ???? ????? ???????

?? ?? ????????? ?? ???????? ??????? ????? ???????? ?? ???????????? ???? ??, ?? ???????? ???? ?? ??? ????

??? ???? ?? ???, ????? ??? ?????:
USE msdb
GO

SELECT server_name, database_name, backup_start_date, is_snapshot, database_backup_lsn
FROM backupset
Database_backup_lsn ????? ?????? ???, ????? ?? is_snapshot ?????? ???? ???????? ??????? ????? ?? ???????????? ???? ?? ?? ????????? ???????? ????? ????????? ??:
  • Database_backup_lsn ????? ?? ??? ???? ?? 0?
  • Is_snapshot ????? ?? ??? 0 ???

???????? ???? ?? ????? ??? ??? ??? ????????? ???

??? ???? ?? ???, ????? ??? ?????:

WITH backupInfo AS( SELECT database_name AS [DatabaseName], 
name AS [BackupName], is_damaged AS [BackupStatus],
backup_start_date AS [backupDate],
ROW_NUMBER() OVER(PARTITION BY database_name 
ORDER BY backup_start_date DESC) AS BackupIDForDB 
FROM msdb..backupset) SELECT DatabaseName 
FROM backupinfo WHERE BackupIDForDB = 1 and BackupStatus=1 

??? ?? ?????? ???? ?? ?????? ???? ??, ???? ??????? ??????? ????? ??????? ?? ?? ?????? ?? ??? ???? ?? ?? ?? ???? ??? ?? ?????? ??????? ???? ?? ??? ??
?? ????? ??????? ????? ?? ??????? ????? ???? ?? ???????? ???? ?? ????? ???? ??????? ????? ???

Is_damaged ???
Msdb ??????? ??? backupset ?????? ???????? ????? ??? ?? ??? ?? ?????? ????? ???? Is_damaged ??? backupset ?????? ??? ????? ???? ?? ?? ??????????? ??????? ?? ??? ????? ????? ??? ??, ?? ???? ???? ?????, ????? ????-restorable ?? ??????????? ?? ???? ???

?? ?????? ?? ??????? ?????? ?????? ?? ??????? ????
???? ?????????????? ?????????? ?? ??????????? ??????? ????? ??????? ???? ?????????? ??
?????? ?????? ???????SQL Server ??????? Backupset Damaged ?? ??? ??? ??????? ???? ??? ???? SQL ????? ??? ???????? ?? ?? ?????? ??????? ?? ??? ?????, ?? ???? backupset "MSDB ??????? ??? ???????????" ??????? ???? ??? ???? ???? ?? ?? ?? ????? ????? ??????????? ??, ?? ??????? essentially ?????? ?? ?? ??????? ??? ?? ???-restorable ?????? ??????? ??????? ?????? ?? ??????? ???? ?? ????????? ???? ?? ?? ????? ????? ????? ?? ???????????? ??????? ?? ??? ?????? ??? ???? ????? ?? ??? KB ???? ??????SQL Server 2008
SQL Server 2008 R2
SQL Server 2012


??????

?? SQL ???? ???? ?? ???? ??? ???? ??????? ?? ???, ?? ???? ????? Microsoft ?????? ??????? (MSDN) ??? ????:
http://msdn2.microsoft.com/en-us/library/ms175536.aspx
?? ??? backupset ?????? ??????, ?? ???? ??? ???? ??????? ????? MSDN ?? ???? ??? ????:
http://msdn2.microsoft.com/en-us/library/ms186299.aspx

???

???? ID: 951288 - ????? ???????: 28 ????? 2013 - ??????: 1.0
???? ???? ???? ??:
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Workgroup Edition
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2000 Standard Edition
  • Microsoft SQL Server 2000 Workgroup Edition
  • Microsoft SQL Server 2000 Developer Edition
  • Microsoft SQL Server 2000 Enterprise Edition
??????: 
kbexpertiseadvanced kbtshoot kbprb kbmt KB951288 KbMthi
???? ?????? ????????
??????????: ?? ???? ?? ???? ??????? ?? ????? ?? Microsoft ????-?????? ?????????? ?????? ?????? ???? ??? ??. Microsoft ???? ??? ????-???????? ?? ????-???????? ????? ?????? ?? ???? ???????? ???? ?? ???? ????? ????? ??? ?? ??? ?????? ?? ???? ???? ???? ??? ????? ??. ???????, ????-???????? ???? ????? ???? ???? ???? ???. ?????, ????????, ?????-???? ?? ??????? ?? ???????? ?? ???? ???, ???? ?? ??? ?????? ???? ???? ??? ????? ??? ?? ???? ??. Microsoft ??????? ??? ???? ?? ?????? ?? ??????????, ????????? ?? ??? ?????? ?? ???? ????? ?? ???? ???????? ?? ??? ???? ????? ?? ??? ????????? ???? ??. Microsoft ????-?????? ?????????? ?? ????? ?????? ?? ?? ??? ??.
?????????? ?? ??????? ????????? ??????? ??:951288

??????????? ???

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com