Ö±½ÓµÄÎļþ±¸·ÝºÍÓÃsqlserverµÄ±¸·ÝÓÐʲôÇø±ð
sql serverÖ±½ÓµÄÎļþ±¸·ÝºÍÓÃsqlserverµÄ±¸·ÝÓÐʲôÇø±ð?
´ó¼Ò˵Ïêϸһµã
²»Ã÷°×~~~
Ö±½Ó±¸·ÝÎļþµÄÓõķÖÀëÊý¾ÝºÍ¸½¼ÓÊý¾Ý¿â
sqlserver±¸·ÝµÄÓõı¸·ÝÊý¾Ý¿âºÍ»¹ÔÊý¾Ý¿â
Ö±½ÓÎļþ±¸·ÝÄãµÃÍ£·þÎñ»òÕßÍÑÀë
ºó׺ÃûΪ.bakµÄÐèÒª»¹Ô ºó׺ΪMDFµÄ¿ÉÒÔ¸½¼Ó
Ö±½ÓµÄÎļþ±¸·Ý£¬Ó¦¸ÃÊÇmdf ºÍlog £¬Òª¸½¼ÓÊý¾Ý¿â
´ÓsqlserverµÄÈÎÎñ£¬±¸·ÝÊÇ.bak£¬ Òª»¹ÔµÄ
£¿£¿£¿
SQL code:
¹À¼ÆÂ¥Ö÷˵µÄÖ±½Ó±¸·ÝÊÇÖ¸Ö±½Ó°ÑÊý¾Ý¿âÎļþ±¸·Ý×ß, ÆäʵÔÚÊý¾Ý¿âûÓÐÓû§Á¬½ÓµÄÇé¿öÏÂ, ÍêÈ«ÊÇ¿ÉÒÔµÄ, µ½Ê±
Ö±½Ó¸½¼ÓÉÏÈ¥¾Í¿ÉÒÔÁË, SQL SERVERµÄ±¸·ÝÊÇÔÚÓû§Á¬½ÓµÄÇé¿öÏÂ, ÓÃSQL SERVERÀïÃæ´øµÄ±¸·ÝÃüÁ·Ý³öÀ´µÄÎļþ.
´Ó°²È«ÐÔºÍÊý¾ÝÍêÕûÐÔÉÏÀ´Ëµ, »¹ÊÇÓÃSQL SERVERµÄÃüÁ·ÝºÃµã
難µÀÊÇ¿½貝mdf,ldf
ì¶
backup database dbname to disk=''
這樣?
²îÒ챸·Ý.ÈÕÖ¾±¸·Ý..»¹Ôµ½Ê±¼äµã..
ÄãÖ¸µÄÊÇÊý¾Ý¿âÎļþmdfµÄ¸´ÖÆ£¿ºÍsqlserverÖеÄÊý¾Ý¿â±¸·Ý£¿±¸·ÝÐÎʽ²»Í¬£¬»Ö¸´µÄ·½·¨²»Í¬¶øÒÑ¡£
±¸·ÝµÄÄÚÈݶ¼Ò»Ñù
Ö±½ÓÎļþ±¸·ÝÐèҪֹͣ·þÎñ ±¸·Ý³ÉBAK¿ÉÒÔÖ±½Ó±¸·Ý
SQL ServerÓÐÁ½ÖÖ±¸·Ý·½Ê½£¬Ò»ÖÖÊÇʹÓÃBACKUP DATABASE½«Êý¾Ý¿âÎļþ±¸·Ý³öÈ¥£¬ÁíÍâÒ»ÖÖ¾ÍÊÇÖ±½Ó¿½±´Êý¾Ý¿âÎļþmdfºÍÈÕÖ¾ÎļþldfµÄ·½Ê½¡£±¾ÎÄÖÐÎÒÃǽ«Ö÷Òª½éÉÜһϺóÕߵı¸·ÝÓë»Ö¸´¡£±¾ÎÄÖмٶ¨ÄúÄ¿Ç°ÒѾÄܹ»ÊìÁ·Ê¹ÓÃServerÆóÒµ¹ÜÀíÆ÷ºÍSQL Server²éѯ·ÖÎöÆ÷)
¡¡¡¡1¡¢Õý³£µÄ±¸·Ý¡¢»Ö¸´·½Ê½
¡¡¡¡Õý
Ïà¹ØÎÊ´ð£º
ÏÈÓÉÈçÏÂsqlÓï¾ä
select A,B,C from table1
union
select A,B,C from table2
order by A, C asc
µÃµ½½á¹ûÈçÏ£º
A B &nbs ......
ÇëÓùýµÄÅóÓѸæ֪ϣ¬Ð»Ð»£¡
ÃÀµÄÄã,ÄÇÍæÒâÖ»ÄÜ×°×°ULTRAEDIT
ÄãÊÔ¹ý£¿È·Êµ²»ÐУ¿
¸çÃÇ ÄãÓÃ586ÅÜÅÜ WIN vista ÊÔÊÔ
ûÄÇôÑÏÖØ£¬ÎÞ·ÇÊÇËÙ¶ÈÂýµã¶øÒÑ£¬¶ÔÓÚvs2008À´Ëµ£¬Äڴ滹ÊǸö¸üÖØÒªµÄÒòËØ¡£
......
ÈçÌâ¡£
ÎÒÏ붨ÆÚÖ´ÐгÌÐò£¬É¾³ý²»ÓõÄÊý¾Ý£¬ÊÕËõÒ»ÏÂÊý¾Ý¿â£¬Æ½Ê±Ê¹ÓõÄʱºò£¬ÈÕÖ¾×î´óÎļþ´óСΪÏÞÖÆ200MB£¬
µ«ÊÇÊÕËõµÄʱºò£¬»á²úÉú´óÁ¿ÈÕÖ¾£¬Èç¹û³¬¹ýÏÞÖÆ£¬ÔòÊÕËõÊý¾Ý¿âʱ»áʧ°Ü£¬ÎÒÏë¸ÄΪ×î´óÎļþ´óС²»Ê ......
ÔÚjspÒ³ÃæÖÐ,ÎÒÏëÏÔʾÊý¾Ý¿â±íÖÐijЩ×ֶεÄÖµ,ÔÚ·½·¨ÖÐ,ÎÒÓ¦¸ÃÓÃʲôÑùµÄ¼¯ºÏÀàÐÍ×öΪ·µ»ØÖµ±È½ÏºÃ,»¹ÓÐ,ÔÚÒ³ÃæÉÏÈçºÎÑ»·Êä³öÎÒ²éѯµÄÄÚÈÝ..¼±ÓÃ!!!!!°ÝÍÐ
ÓÃList²»ÐÐÂð£¿
ÓÃlist
Ò³ÃæÓà <c:forEach& ......
ÎÒ¿´Á˺ܶàÎÄÕ£¬Ð´µÄ̫רҵ£¬Äܲ»ÄÜÓôó°×»°½²½²£¬¾ÍÊÇÔõô¹¹½¨Ë÷ÒýµÄ£¬²éµÄʱºòÊÇÔõôÑùµÄ²½Ö裬Ϊʲô±Èlike¿ì£¬ÊDz»ÊÇÖ»ÒªÓÃcontect£¬¾ÍÒ»¶¨»áÈ¥²é£¬±ÈÈç
select * from table where contect('sdfsd',sdf) and ......