Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2010
    Posts
    2

    Unanswered: backup database from server pc to client pc

    hi

    i m using ms sql 2008. i want to backup database from server pc to my (client) pc.

    i have used the following sql command:

    Backup Database model To Disk = 'D:\\BackUp\\MySQLSamples.bak'

    but this does not work.
    it will save backup to the server pc but not my pc. what should i do.

    agile

  2. #2
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    XCOPY (deprecated) with the /D switch
    ROBOCOPY (if you have the courage to work your way through the documentation)
    RichCopy free utility from MS (the link is to an old version - a new version was "coming soon" at the start of 2010 but I can't find it).

    izy

  3. #3
    Join Date
    Sep 2010
    Posts
    2

    backup db

    XCOPY (deprecated) with the /D switch


    what does it mean.

  4. #4
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    sorry it is in French but here's what i get on Vista:
    Code:
    C:\Users\izyrider>xcopy /?
    Copie des fichiers et des arborescences de répertoires.
    
    NOTE: Xcopy est désormais deprécié, utilisez Robocopy.
    
    XCOPY source [destination] [/A | /M] [/D[:date]] [/P] [/S [/E]] [/V] [/W]
                               [/C] [/I] [/Q] [/F] [/L] [/G] [/H] [/R] [/T] [/U]
                               [/K] [/N] [/O] [/X] [/Y] [/-Y] [/Z] [/B]
                               [/EXCLUDE:fich1[+fich2][+fich3]...]
    
     source       Spécifie le ou les fichiers à copier.
     destination  Spécifie l'emplacement et/ou le nom de nouveaux fichiers.
     /A           Copie uniquement les fichiers ayant l'attribut archive, ne
                  modifie pas l'attribut.
     /M           Copie uniquement les fichiers ayant l'attribut archive,
                  désactive l'attribut archive.
     /D:j-m-a   Copie les fichiers modifiés à partir de la date spécifiée.
                  Si aucune date n'est donnée, copie uniquement les fichiers dont
                  l'heure source est plus récente que l'heure de destination.
    so DOS command XCOPY is replaced by Robocopy.

    Robocopy has the very neat /MON and /MOT switches -- either google for how to use Robocopy with these switches to get your backup files down to your pc when the file changes on the server, or, if Robocopy causes too much brain-strain, use the GUI tool I linked to above.

    izy
    currently using SS 2008R2

Tags for this Thread

Posting Permissions

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