it is possible to take sql server2000 database backup on another machine''s disc.

  • Hello friends

    Can anybody knows,it is possible to take sql server2000 database backup on another machine's disc.

     

    I normally take backup on the disc of same machine where my database server is but if i want to take backup to another machine disc then that will possible???

    T.I.A

    Shashank


    Regards,

    Papillon

  • You can perform a backup to a UNC name, you just need to make sure that the account used for SQL has access to the remote machine.

  • Hello thanx

    what my problem is we have 5 to 6 machine which are shared this server which is on my machin

    but i want to take back up not on my machin but directly on machine number say like 3 normally what i m doing now is take backup on my machin and then transfer it to machine number 3 ...so i want solution for this

    T.I.A

    shashank


    Regards,

    Papillon

  • You can either create a Network Drive (mapped drive of some other machine on your machine) or a UNC path to that machine.

    For example :

    \\machinename\sharename

    OR

    Driveofnetworkmachine(F:\)\foldername

    You need to make sure that you have administrative priviliges on the mapped network drive or the UNC path.

    I have been using mapped network drive for my Full and Transaction Log backups for 5 years now. It has been working perfectly fine with me.

    Do let me know of your progress.

    --Kishore

     

  • You can also make the backups using SQL-devices.

    So from within you sql-backup-job you can see zip , but your backup-device will point to an UNC-destination.

    copied from BOL
    USE master

    EXEC sp_addumpdevice 'disk', 'MyDbFullbackup', '\\myserver.mydomain.domsuffix\sharename\path\filename.BAK'

    go

    BACKUP DATABASE [MyDb] TO [MyDbFullbackup] WITH  INIT ,

           NOUNLOAD ,  NAME = 'MyDb_Full',

           SKIP ,  STATS = 10,  DESCRIPTION = 'Full Database Backup' ,  NOFORMAT

    go

    This will need your sqlserver-serviceaccount to have permissions to write to \\myserver.mydomain.domsuffix\sharename\path\. (This can be no problem if you are allready copying in your current situation.)

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

  • Beware of networks when backing up\restoring from remote devices  network connections can drop for any number of reasons and this can make these processes unstable

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply