SQL ServerÊý¾Ý¿âÊÂÎñÈÕÖ¾ÐòÁкÅ(LSN)½éÉÜ
ÈÕÖ¾ÐòÁбàºÅ(LSN)ÊÇÊÂÎñÈÕÖ¾ÀïÃæÿÌõ¼Ç¼µÄ±àºÅ¡£
µ±ÄãÖ´ÐÐÒ»´Î±¸·Ýʱ£¬Ò»Ð©LSNÖµ¾Í±»Í¬Ê±´æ´¢ÔÚÎļþ±¾Éí¼°msdb..backupset±íÖС£Äã¿ÉÒÔʹÓÃRESTORE HEADERONLYÓï·¨À´´Ó±¸·ÝÎļþÖлñÈ¡LSNÖµ¡£
×¢Ò⣺ÔÚSQL Server 2000ÖУ¬ÓÐÒ»ÁнÐ×öDifferentialBaseLSN¡£µ«ÔÚSQL Server 2005ÖУ¬ÏàͬµÄÁÐÃû³Æ±ä³ÉÁËDatabaseBackupLSN¡£Õý½âµÄÁÐÃûÓ¦¸ÃÊÇDatabaseBackupLSN£¬Õâ¸öÃû³Æ²ÅÄܱí´ï³öËüµÄÒâÒ壬Äã¿ÉÒÔ´ÓSQL Server 2000µÄÁª»ú´ÔÊéÖÐÕÒµ½Ïà¹Ø˵Ã÷¡£
FirstFSNÖµÊDZ¸·ÝÉ豸ÖеÚÒ»¸öÊÂÎñµÄÈÕÖ¾ÐòÁкţ¬LastLSNÖµÊÇ×îºóÒ»¸ö¡£CheckpointLSNÖµÊÇ×î½üÒ»´ÎcheckpointÈÕÖ¾µÄÐòÁкš£DatabaseBackupLSNÊÇ×î½üÒ»´ÎÊý¾Ý¿âÍêÕû±¸·ÝµÄÈÕÖ¾ÐòÁкš£
ÄÇôLSNÖµ¶ÔÎÒÃÇÀ´Ëµ£¬ÓÐʲô¼ÛÖµÄØ£¿¶ÔÓÚ²îÒ챸·ÝÉ豸À´Ëµ£¬DatabaseBackupLSNÖµ¿ÉÒÔ¸æËßÎÒÃÇÊý¾Ý¿âÍêÕû±¸·Ý¶¼ÐèÒªÄÄЩ²îÒ챸·Ý¡£ÄãÐèÒªÕÒ³öËùÓÐCheckpointLSNÖµÏàͬµÄÍêÕû±¸·ÝºÍ²îÒ챸·Ý¡£
¶ÔÓÚÒ»¸öÊÂÎñÈÕÖ¾±¸·ÝÀ´Ëµ£¬ÔÚÊý¾Ý¿â»¹Ô¹ý³ÌÖУ¬FirstLSNºÍLastLSNÖµ¿ÉÒÔ°ïÖúÎÒÃǶÔÊÂÎñÈÕÖ¾Îļþ°´ÐòºÅ½øÐÐÅÅÐò¡£
¼ÙÈçÊý¾Ý¿âÕý´¦ÓÚ»¹Ô״̬£¬¶øÇÒÕýÔڵȴýÁíÍâµÄ»¹ÔÊÂÎñÈÕÖ¾£¬ÄÇÄãÔõôÄÜ·Ö±æ³öËüµ±Ç°µÄLastLSNÖµ£¬ÒÔ±ãÄã×Ô¼ºÇå³þÏÂÒ»²½Ó¦¸ÃÓ¦ÓÃÄĸöÈÕÖ¾ÄØ£¿Ã»¹Øϵ£¬msdb..restorehistory±í´æ´¢ÁËÿһ¸öÊý¾Ý¿â»¹ÔÐÅÏ¢¡£Äã¿ÉÒÔÒýÓÃmsdb..backupset±í£¬Äã¿ÉÒÔÕÒÏÖ´æ´¢ÊÂÎñÈÕÖ¾µÄ×îºóÒ»¸öÊÂÎñÈÕÖ¾±¸·Ý£¬ËüµÄLastLSN²éѯÓï¾äÈçÏ£º
SELECT TOP 1 b.type, b.first_lsn, b.last_lsn, b.checkpoint_lsn, b.database_backup_lsn
from msdb..restorehistory a
INNER JOIN msdb..backupset b ON a.backup_set_id = b.backup_set_id
WHERE a.destination_database_name = 'AdventureWorks'
ORDER BY restore_date DESC
±¾ÎÄ·Òë×Ôsqlbackuprestore£¬¸ü¶à¾«²ÊÄÚÈÝÇëä¯ÀÀhttp://www.sqlbackuprestore.com
Ïà¹ØÎĵµ£º
Ò»¡¢³£ÓÃÊý¾ÝÀàÐÍ£º
Number£ºÊý×ÖÀàÐÍ
Int£ºÕûÊýÐÍ
Pls_integer£ºÕûÊýÐÍ£¬²úÉúÒç³öµÄ´íÎó
Binary_integer£ºÕûÊýÐÍ
Char£º¶¨³¤×Ö·û£¬×255¸ö×Ö·û
Varchar2£º±ä³¤×Ö·û£¬×2000¸ö×Ö·û
Long£º±ä³¤×Ö·û£¬×2GB
Date£ºÈÕÆÚÐÍ
Boolean£º²¼¶ûÐÍ
¶þ¡¢¶¨Òå³£Á¿
¸ñʽ£º³£Á¿Ãû constant &nbs ......
×òÌìŪÁËÒ»¸ö±È½Ï¼¬ÊÖµÄÎÊÌâ¡£´ÓÍøÉÏÏÂÔØÁËÒ»¸öÈí¼þ£¬ËûµÄÊý¾Ý¿âÊÇaccessµÄ£¬´ò¿ª¿´ÁËһϣ¬¸Ð¾õ²»´í£¬ÊʺÏÎÒÏÖÔÚÏîÄ¿µÄÐèÇ󣬴󲿷ÖÄܹ»Âú×ãÎÒµÄÏîÄ¿ÐèÒª£¬¾ÍÏëÄÃÀ´Ö÷Òå¡£¿ÉÊÇÎÒÃÇÏîÄ¿µÄÊý¾Ý¿âÒ»Ö±¶¼ÊÇÓõÄsqlserver£¬ÓÚÊÇ£¬¾ÍÔÚÍøÉÏ·è¿ñµÄ£¬ÕÒ¹ØÓÚaccessת»»ÎªsqlserverµÄ×ÊÁÏÔÚÕâÀïÎÒÏë˵һÏÂÓйصÄ×¢ÒâÊÂÏ
Êý¾Ý¿âÉý ......
--×Ô¼ººÜÓÞ´ÀµÄ×ö·¨£¬ÒÔΪֱ½Óɾ³ýÊý¾Ý¿âÓû§Ãû£¬ÔÙ´Óд´½¨Óû§µÇ¼ÃûºÍÊý¾Ý¿âÓû§Ãû¡£
--×Ô¼ºÒÔΪ¿ÉÒÔÖ±½Ó´´½¨ÓëÖ®ÔÏÈÒ»ÑùµÄÊý¾Ý¿âµÇ¼Ãû¾Í¿ÉÒÔ
--µ«ÕâЩ²Ù×÷ÊDz»Æð×÷ÓõÄ
--ÔÒò
--µ±Ó³Éä¹ÂÁ¢Óû§Ê±£¬Ö÷´ÓÊý¾Ý¿âÖеÄSID½«·ÖÅä¸ø¹ÂÁ¢Óû§£¬ËùÒÔÿ´ÎÒ»¸öÊý¾Ý¿â±¸¸½¼Ó»òÕß»¹Ôʱ£¬--SIDÔÚSQL Server µÇ¼ÃûºÍÊý¾Ý¿âÓû ......
select *
from
(select [id]=row_number() over (order by getdate()),
date=convert(varchar(8),dateadd(dd,number,'2010-01-01'),112)
from
(select number from master..spt ......
if exists(select * from sysobjects where name='atzk')--ÅжÏÊÇ·ñ´æÔڴ˱í
drop table atzk
go
create table atzk
(
nid int identity(1,1) primary key,--nid×Ô¶¯±àºÅ£¬²¢ÉèΪÖ÷¼ü¡£
mytitle varchar(50) not null,--֪ͨµÄ±êÌâ¡£
mycontents varchar(200)--·¢²¼Í¨ÖªµÄÄÚÈÝ¡£
) ......