Forum Replies Created

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

  • RE: Backup Database to different server?

    Jerry Hung (10/10/2008)


    BACKUP DATABASE dbname

    TO DISK = '\\ServerName\ShareFolderName'

    should work most of the time, IF SQL Server Service account has permission to the \\ServerName and \Folder

    Otherwise, quickest way may be

    1....

  • RE: Backup Database to different server?

    Kishore.P (10/10/2008)


    You can see the BACKUP DATABASE command on SQL BOL.

    i've seen this before like

    BACKUP DATABASE dbname

    TO DISK = '\\ServerName\ShareFolderName'

    but ServerName can be 88.125.xx.xx ? because it doesn't work:(

  • RE: Backup Database to different server?

    SQL ORACLE (10/9/2008)


    It is possible.

    Create a database device, then backup your database to this device.

    ok but how ?:)

  • RE: Backup Database on remote server

    DavidB (10/7/2008)


    If you are able to browse to that path from windows then that will work.

    Just a note, but I wouldn't leave that IP posted here if it is...

  • RE: Backup Database on remote server

    DavidB (10/7/2008)


    cemmeke (10/7/2008)

    give you any sample for 'remote folder address' ?

    thanks

    \\YourServerName\YourShareName\ should work.

    like \\78.82.156.89\MyShareName\FolderName

    ?

    thanks again

  • RE: Backup Database on remote server

    Wildcat (10/6/2008)


    1. Make the remote folder shared, and make sure the SQL Server Agent has write-permission on that folder. (Maint plan can't see the remote shared folder. You have to...

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