• ps (7/20/2009)


    2. backup database using a shared path pointing to your client(of course, you need a shared folder on client's machine)

    backup database mydb to disk='\\myMachine\myBackupFolder\myDB.bak'

    That will only work if the service account that SQL is running under has full read and write permissions on that share and folder.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass