If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Microsoft SQL Server > backup database from server pc to client pc

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 09-01-10, 04:54
agile agile is offline
Registered User
 
Join Date: Sep 2010
Posts: 2
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
Reply With Quote
  #2 (permalink)  
Old 09-01-10, 08:30
izyrider izyrider is offline
Cavalier King Charles
 
Join Date: Dec 2002
Location: Préverenges, Switzerland
Posts: 3,727
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
Reply With Quote
  #3 (permalink)  
Old 09-02-10, 01:16
agile agile is offline
Registered User
 
Join Date: Sep 2010
Posts: 2
backup db

XCOPY (deprecated) with the /D switch


what does it mean.
Reply With Quote
  #4 (permalink)  
Old 09-02-10, 05:04
izyrider izyrider is offline
Cavalier King Charles
 
Join Date: Dec 2002
Location: Préverenges, Switzerland
Posts: 3,727
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
__________________
environment: W7 / .NET / MSSQL2K5 (prior to mid 2009: WXP/A2K3(DAO)/MySQL(innodb)/SQL-Server2K)
Reply With Quote
Reply

Tags
backup database

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On