Results 1 to 11 of 11

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered User
    Join Date: Jun:2005
    Location: Plovdiv
    Posts: 19

    Êîïèðàíå íà ôàéëîâå êîéòî ñà îòâîðåíè â ìîìåíòà, êàê?

    Ïðîáëåìà å ñëåäíèÿ.
    Â Win XP êîãàòî äàäåí ôàéë å îòâîðåí, ïðåìåðíî áàçà äàííè, òÿ íå ìîæå äà ñå êîïèðà.

    Èìà ëè ïðîãðàìà ñ êîÿòî äà ìîãà äà êîïèðàì òàêúâ ôàéë áåç äà ñå ñúîáðàçÿâà ñ Windowsa?

    Ñåãà òðÿáâà äà ñïèðàì ñúðâèñà íà SQL Server-a çà äà ìîãà äà êîïèðàì, à òîâà å íåóäîáíî.

  2. #2
    Registered User CYPER's Avatar
    Join Date: May:2004
    Location: Ðóñå
    Posts: 9,357

    :)

    xcopy /c

    Êèðèëèöà
    Gigabyte X570 AORUS Ultra | 5950X | Arctic Liquid Freezer II 240 | Corsair Vengeance LPX 2x8GB 3200Mhz | Samsung 980 Pro 1TB + Samsung 970 Pro 1TB | Gigabyte AORUS GeForce RTX 3080 Ti Master 12GB | Fractal Design Meshify C Dark TG | Corsair AX860i | Samsung U32H850 32" 4K

  3. #3
    Íàøèÿò ÷åðåí êîòàðàê Private's Avatar
    Join Date: Jan:2002
    Location: Ñîôèÿ
    Posts: 32,172
    Quote Originally Posted by qsd
    Ñåãà òðÿáâà äà ñïèðàì ñúðâèñà íà SQL Server-a çà äà ìîãà äà êîïèðàì, à òîâà å íåóäîáíî.
    Ïðåäñòàâè ñè êîëêî èíòåðåñíî ùå ñòàíå, êîãàòî ïî âðåìå íà êîïèðàíåòî,
    ïðîãðàìàòà çà áàçà äàííè çàïèøå ïðîìåíè íà íÿêîëêî ðàçëè÷íè ìåñòà âúâ ôàéëà...
    Àêî èäåÿòà å àðõèâèðàíå, âåðîÿòíî àâòîðèòå íà áàçàòà èìàò ðåøåíèå íà âúïðîñà.
    -= All our life, we are beta testers =-
    -= Âíèìàíèå! Âúçìîæíî å ïîñòîâåòå ìè äà ñúäúðæàò õóìîð, [ñàìî]èðîíèÿ è ñàðêàçúì! =-
    -= Êàêâè òåìè ìå ðàäâàò è çàùî =-= Îòèäîõà ñè äîáðè õîðà: Fo , goblin =-

  4. #4
    Registered User singularity's Avatar
    Join Date: Apr:2003
    Location: Ñîôèÿ
    Posts: 3,382
    Òîâà ìíåíèå å èçòðèòî îò ïîòðåáèòåëÿ. Çà ïîâå÷å èíôîðìàöèÿ â òàçè òåìà
    Last edited by singularity; 12th April 2007 at 14:09. Reason: íåñúãëàñèå ñ óïðàâëåíèåòî íà ôîðóìà
    ignore list:Java,våelio,jaredharet,gochev.george,Nit rogenium
    Quis custodiet ipsos custodes?

  5. #5
    Íàøèÿò ÷åðåí êîòàðàê Private's Avatar
    Join Date: Jan:2002
    Location: Ñîôèÿ
    Posts: 32,172
    Quote Originally Posted by singularity
    Äúìï íà áàçàòà âúâ ôàéë...
    Êàêâî ïðåäñòàâëÿâà òîâà è ìîæå ëè äà ñòàíå â ðåàëíî âðåìå, êîãàòî ñå ïîëçâà áàçàòà?
    -= All our life, we are beta testers =-
    -= Âíèìàíèå! Âúçìîæíî å ïîñòîâåòå ìè äà ñúäúðæàò õóìîð, [ñàìî]èðîíèÿ è ñàðêàçúì! =-
    -= Êàêâè òåìè ìå ðàäâàò è çàùî =-= Îòèäîõà ñè äîáðè õîðà: Fo , goblin =-

  6. #6
    Âåãàí íà ìåñíà äèåòà XaMaB's Avatar
    Join Date: Nov:2001
    Location: Ñîôèÿ
    Posts: 20,392
    Ìîæå.
    Ïîñëåäíà ðåäàêöèÿ: èçâúðøåíà îò XaMaB; íà äíåøíà äàòà. 0.42 ñåêóíäè ñëåä ïóñêàíå íà ïîñòà

    In God we Trust (all others must submit a X.509 certificate). Àêî ñïîðèø ñ èäèîò, âåðîÿòíî è òîé ïðàâè ñúùîòî èëè ñè ïîïàäíàë íà ïàðòèåí (íåïúëåí) ÷ëåí

  7. #7
    Registered User CYPER's Avatar
    Join Date: May:2004
    Location: Ðóñå
    Posts: 9,357
    Gigabyte X570 AORUS Ultra | 5950X | Arctic Liquid Freezer II 240 | Corsair Vengeance LPX 2x8GB 3200Mhz | Samsung 980 Pro 1TB + Samsung 970 Pro 1TB | Gigabyte AORUS GeForce RTX 3080 Ti Master 12GB | Fractal Design Meshify C Dark TG | Corsair AX860i | Samsung U32H850 32" 4K

  8. #8
    Íàøèÿò ÷åðåí êîòàðàê Private's Avatar
    Join Date: Jan:2002
    Location: Ñîôèÿ
    Posts: 32,172
    Quote Originally Posted by XaMaB
    Ìîæå.
    À êàê? Ñ åäíî-äâå èçðå÷åíèÿ, êàòî çà íå-ñïåöèàëèñòè...
    -= All our life, we are beta testers =-
    -= Âíèìàíèå! Âúçìîæíî å ïîñòîâåòå ìè äà ñúäúðæàò õóìîð, [ñàìî]èðîíèÿ è ñàðêàçúì! =-
    -= Êàêâè òåìè ìå ðàäâàò è çàùî =-= Îòèäîõà ñè äîáðè õîðà: Fo , goblin =-

  9. #9
    Registered User
    Join Date: Jun:2005
    Location: Plovdiv
    Posts: 19
    Quote Originally Posted by Private
    Êàêâî ïðåäñòàâëÿâà òîâà è ìîæå ëè äà ñòàíå â ðåàëíî âðåìå, êîãàòî ñå ïîëçâà áàçàòà?
    Ðàáîòàòà å òàì, ÷å äîðè è äà äàì exit íà MSSQL Servera, îñòàâà àêòèâåí åäíè ñúðâèñ êîéòî òðàáâà äà ñïèðàì ïî ãðóáèÿ íà÷èí.

    Òîçè äåòî å ïèñàë ïðîãðàìàòà âúîáùå íå å ïðåäâèäèë äà ïðàâÿ àðõèâ, îê ãî áåøå ïðåäâèäèë ùåøå äà ñëîæè ïîíå åäíà èêîíà, èâà åäíè ôàéë ñ êîìàíäåí ðåä, îáà÷å íå ìó çíàì âñè÷êè ïàðàìåòðè.

  10. #10
    Âåãàí íà ìåñíà äèåòà XaMaB's Avatar
    Join Date: Nov:2001
    Location: Ñîôèÿ
    Posts: 20,392
    Examples

    A. Back up the entire MyNwind database

    Note The MyNwind database is shown for illustration only.

    This example creates a logical backup device in which a full backup of the MyNwind database is placed.

    -- Create a logical backup device for the full MyNwind backup.
    USE master EXEC sp_addumpdevice 'disk', 'MyNwind_1',
    DISK ='c:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\MyNwind_1.dat'
    -- Back up the full MyNwind database.

    BACKUP DATABASE MyNwind TO MyNwind_1


    B. Back up the database and log

    -- Create the backup device for the full MyNwind backup.
    USE master
    EXEC sp_addumpdevice 'disk', 'MyNwind_2',
    'c:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\MyNwind_2.dat'

    --Create the log backup device.
    USE master
    EXEC sp_addumpdevice 'disk', 'MyNwindLog1',
    'c:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\MyNwindLog1.dat'

    -- Back up the full MyNwind database.
    BACKUP DATABASE MyNwind TO MyNwind_2

    -- Update activity has occurred since the full database backup.

    -- Back up the log of the MyNwind database.
    BACKUP LOG MyNwind
    TO MyNwindLog1

    Äèðåêòíî îò õåëïà íà mssql (query analyzer -> help -> transaction sql -> backup)
    Last edited by XaMaB; 5th January 2006 at 11:15.
    Ïîñëåäíà ðåäàêöèÿ: èçâúðøåíà îò XaMaB; íà äíåøíà äàòà. 0.42 ñåêóíäè ñëåä ïóñêàíå íà ïîñòà

    In God we Trust (all others must submit a X.509 certificate). Àêî ñïîðèø ñ èäèîò, âåðîÿòíî è òîé ïðàâè ñúùîòî èëè ñè ïîïàäíàë íà ïàðòèåí (íåïúëåí) ÷ëåí

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Copyright © 1999-2011 Õàðäóåð ÁÃ. Âúçìîæíî å ñúäúðæàíèåòî íà òàçè ñòðàíèöà äà å îáåêò íà àâòîðñêè ïðàâà.
iskamPC.com | mobility.BG | Bloody's Techblog | Êðèïòîâàëóòè è ìàéíèíã | 3D Vision Blog | Ìàãàçèí çà åëåêòðîííè öèãàðè