SQL ServerÊý¾Ý¿âÊÂÎñÈÕÖ¾´æ´¢ÐòÁÐ
Èç¹ûÄãµÄÊý¾Ý¿âÔËÐÐÔÚÍêÕû»òÊÇÅúÁ¿ÈÕÖ¾»Ö¸´Ä£Ê½Ï£¬ÄÇôÄã¾ÍÐèҪʹÓÃ×÷Òµ(job)À´¶¨ÆÚ±¸·ÝÊÂÎñÈÕÖ¾£¬±£³ÖÄãµÄÊÂÎñÎļþ´óС´¦ÔÚÒ»¸ö¿É¹ÜÀíµÄ·¶Î§¡£µ±ÄãÐèÒª»¹ÔÊÂÎñÈÕ־ʱ£¬Äã¾ÍÐèÒª°´ÕÕ´´½¨ÊÂÎñÈÕÖ¾µÄ˳ÐòÀ´»Ö¸´ËüÃÇ¡£Äã¿ÉÒԲο¼´æÔÚmsdb..backupset±íÖеÄÐÅÏ¢À´È·¶¨»¹ÔÎļþµÄ˳Ðò£¬Ê¹ÓÃFirstLSNºÍLastLSNÁеÄÖµ×÷²Î¿¼¡£µ±Ä㱸·Ýʱ£¬ÕâЩ±¸·ÝÐÅÏ¢¾Í»á´æÔÚbackupset±íÖÐ
Ö»ÒªÐòÁд¦ÓÚά»¤×´Ì¬Ï£¬Äã¾Í¿ÉÒÔʹÓöÔÓ¦µÄÈÕÖ¾°ÑÊý¾Ý»Ö¸´µ½ÈÎÒâ»Ö¸´µãÉÏ¡£²»ÐÒµÄÊÇ£¬ÓÐЩʵÀýµÄÐòÁÐÒѾ±»Ëð»µÁË¡£ÏÂÃæÁ½ÖÖÇé¿öÆÕͨÊÇÒýÆðË𻵵ÄÔÒò£º
Êý¾Ý¿âµÄ»Ö¸´Ä£Ðͱ»Çл»µ½Á˼òµ¥(SIMPLE)ºó£¬Ôٴα»Çл»»ØÍêÕû»òÊÇÅúÁ¿ÈÕÖ¾¡£
Backup logÃüÁîÔËÐÐʱ£¬¸½´øÁËTRUNCATE_ONLY/NO_LOGÑ¡Ïî¡£
µ±ÉÏÃæÁ½ÖÖÇé¿ö·¢Éúʱ£¬ÄãÐèÒª¼´¿É×öÒ»¸öÊý¾Ý¿âµÄÍêÕû±¸·Ý£¬×÷ΪÊÂÎñÈÕÖ¾»Ö¸´µÄеĻָ´µã¡£ÄÇôÄãÈçºÎÅжÏÐòÁÐÒѾ±»ÆÆ»µÁËÄØ£¿
ÔÚSQL Server 2000ÖУ¬ÕâȷʵÓеãÂé·³¡£¼ÙÈçÊý¾Ý¿â»Ö¸´Ä£ÐÍÒѾ±»¸ü¸ÄÁË£¬»òÊDZ¸·ÝʱÈÕÖ¾ÒѾ±»½Ø¶ÏÁË£¬ÄÇôµ±¸ü¸Äºó£¬ÄãµÚÒ»´Î±¸·ÝÊÂÎñÈÕ־ʱ£¬SQL Server 2000»áÏÔʾÈçÏÂÊä³ö£º
There is no current database backup. This log backup cannot be used to roll forward a preceding database backup.
Processed 1 pages for database 'logtest', file 'logtest_log' on file 1.
BACKUP LOG successfully processed 1 pages in 0.078 seconds (0.019 MB/sec).
×¢ÒâÕâ½ö½öÊǸöÏûÏ¢¡£ËäÈ»±¸·ÝÒÀÈ»»á³É¹¦Íê³É£¬µ«È´²»¿ÉÓá£ÒòΪÕâÊǸö¼Æ»®×÷Òµ£¬ËùÒÔÄãʲô¶¼¿´²»µ½£¬²»¹ýµ±ÊÂÎñÈÕÖ¾±»½Ø¶Ïʱ£¬ÔÚWindowsʼþÈÕÖ¾ÖÐÊÇÏà¹Ø¾¯¸æÈÕÖ¾µÄ¡£¡£
×¢Ò⣺Èç¹ûÄãÕýÔÚʹÓÃSQL Server 2000£¬ÄÇôÈÕÖ¾ÊÂÎñ¶ÔÓÚÊý¾Ý¿âÊǷdz£ÖØÒªµÄ£¬ËùÒÔÒªÔÚWindowsʼþÈÕÖ¾Öв»¼ä¶ÏµÄ¼à¿ØÈÕÖ¾ÊÂÎñʼþ¡£
¼ÙÈçÄã¼ÈûÓйØ×¢¾¯¸æÏûÏ¢£¬Ò²Ã»Óмà¿ØWindowsʼþÈÕÖ¾£¬ÄÇô»ù±¾ÉÏÄã¾ÍÊÇÓÐÒ»Åú²»¿É»Ö¸´µÄÊÂÎñÈÕÖ¾±¸·Ý¡£SQL Server²»Ó¦¸Ã¾¯¸æÎÒÃÇÂ𣿲»Ó¦¸ÃÍ£Ö¹ÎÞЧµÄ±¸·ÝÂ𣿼ÙÈçÄãÕýÔÚʹÓÃSQL Server 2005£¬ÄÇô´ð°¸¿Ï¶¨ÊÇÓ¦¸ÃµÄ£¬¶øÇÒËüÒ²ÊÇÕâô×öµÄ¡£ÏÂÃæ¾ÍÊǵ±ÈÕÖ¾±¸·ÝÐòÁб»»Ù»µÊ±ÏÔʾµÄÏûÏ¢:
Server: Msg 4214, Level 16, State 1, Line 1
BACKUP LOG cannot be performed because there is no current database backup.
Server: Msg 3013, Level 16, State 1, Line 1
BACKUP LOG is terminating abnormally.
ÊDz»ÊǺöàÁË¡£×ÜÖ®£¬Èç¹ûÄãÕýÔÚʹÓÃSQL Server 2000£¬ÄãÐèÒª¹Ø×
Ïà¹ØÎĵµ£º
¶¯Ì¬Óï¾ä
1 :ÆÕͨSQLÓï¾ä¿ÉÒÔÓÃexecÖ´ÐÐ
Select * from tableName
exec('select * from tableName')
exec sp_executesql N'select * from tableName' -- Çë×¢Òâ×Ö·û´®Ç°Ò»¶¨Òª¼ÓN
2:×Ö¶ÎÃû£¬±íÃû£¬Êý¾Ý¿âÃûÖ®Àà×÷Ϊ±äÁ¿Ê±£¬±ØÐëÓö¯Ì¬SQL
declare @fname varchar(20)
set @fname = 'FiledName'
Select @fnam ......
Ò»¡¢³£ÓÃÊý¾ÝÀàÐÍ£º
Number£ºÊý×ÖÀàÐÍ
Int£ºÕûÊýÐÍ
Pls_integer£ºÕûÊýÐÍ£¬²úÉúÒç³öµÄ´íÎó
Binary_integer£ºÕûÊýÐÍ
Char£º¶¨³¤×Ö·û£¬×255¸ö×Ö·û
Varchar2£º±ä³¤×Ö·û£¬×2000¸ö×Ö·û
Long£º±ä³¤×Ö·û£¬×2GB
Date£ºÈÕÆÚÐÍ
Boolean£º²¼¶ûÐÍ
¶þ¡¢¶¨Òå³£Á¿
¸ñʽ£º³£Á¿Ãû constant &nbs ......
Ëù²âÊÔ»·¾³Îª£ºMs sqlserver 2008£¬visual studio 2008
²âÊÔÊý¾ÝΪ10ÍòÌõ
Linq·½Ê½ ´úÂ룺
/// <summary>
/// Linq ·½Ê½
/// </summary>
public static void Linq_insert()
{
DataClassesDataContext dataContext = new DataClassesDataContext();
......
´¦ÀíSQL ServerÊý¾Ý¿âÖеĹÂÁ¢Óû§(ͼ)
°ÑÊý¾Ý¿â´ÓÒ»¸ö·þÎñÆ÷ʵÀý¸½¼ÓºÍ»Ö¸´µ½ÁíÒ»¸öʵÀýÖÐÊÇÊý¾Ý¿â¹ÜÀíÔ±Ö´Ðеij£¼ûµÄÈÎÎñ¡£¸½¼Ó»òÕ߻ָ´Ò»¸öÊý¾Ý¿âÖ®ºó£¬Ö®Ç°ÔÚÊý¾Ý¿âÖд´½¨ºÍÅäÖõĵǼÃûÒѾ²»ÄÜ·ÃÎÊÁË¡£Õâ¸öÎÊÌâ×î³£¼ûµÄÖ¢×´ÊÇÓ¦ÓóÌÐò»áÓöµ½µÇ¼ʧ°ÜµÄ´íÎ󣬻òÕßÊǵ±ÄãÊÔ×ŰѵǼÃûÌí¼Óµ½Êý¾Ý¿âÖÐʱ£¬Äã¿ÉÄÜ»áµÃµ½Ò» ......
--×Ô¼ººÜÓÞ´ÀµÄ×ö·¨£¬ÒÔΪֱ½Óɾ³ýÊý¾Ý¿âÓû§Ãû£¬ÔÙ´Óд´½¨Óû§µÇ¼ÃûºÍÊý¾Ý¿âÓû§Ãû¡£
--×Ô¼ºÒÔΪ¿ÉÒÔÖ±½Ó´´½¨ÓëÖ®ÔÏÈÒ»ÑùµÄÊý¾Ý¿âµÇ¼Ãû¾Í¿ÉÒÔ
--µ«ÕâЩ²Ù×÷ÊDz»Æð×÷ÓõÄ
--ÔÒò
--µ±Ó³Éä¹ÂÁ¢Óû§Ê±£¬Ö÷´ÓÊý¾Ý¿âÖеÄSID½«·ÖÅä¸ø¹ÂÁ¢Óû§£¬ËùÒÔÿ´ÎÒ»¸öÊý¾Ý¿â±¸¸½¼Ó»òÕß»¹Ôʱ£¬--SIDÔÚSQL Server µÇ¼ÃûºÍÊý¾Ý¿âÓû ......