Results 1 to 11 of 11

Thread: , ?

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,velio,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 |