Post reply

Backup issue

  • November 3, 2008 at 11:56 pm

    #214814

    Hi Team,

    currently i am taking backup to my remote servers using ftp but now that backup size to long how can i take my backup could you please some good soultion

    Thanks

  • November 4, 2008 at 6:21 am

    #893567

    Try compression.

  • November 5, 2008 at 4:44 am

    #894140

    kumar99ms (11/3/2008)

    Hi Team,

    currently i am taking backup to my remote servers using ftp but now that backup size to long how can i take my backup could you please some good soultion

    Thanks

    u can use backup compression feature of SQL 2008. for other versions, compress the backup file and then FTP it.

  • November 5, 2008 at 5:03 am

    #894148

    One more option is to use a third party tool that knows how to backup and compress that backup file. There are few tools that can do that and they have around for few years so they are also very reliable.

    Adi

    --------------------------------------------------------------
    To know how to ask questions and increase the chances of getting asnwers:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • November 5, 2008 at 5:03 am

    #894149

    kumar99ms (11/3/2008)

    Hi Team,

    currently i am taking backup to my remote servers using ftp but now that backup size to long how can i take my backup could you please some good soultion

    Thanks

    Try to take direct backup from the SQL server.

    Or take backup on the same location and then compress it and then transfer it to the destination

    kshitij kumar
    kshitij@krayknot.com
    www.krayknot.com

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

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