question

Harris 1 avatar image
Harris 1 asked

backup transfer on ftp

Hi, We have a project whose backups are taken at a different location and passed on to us on a bi weekly basis. However we wish to take the backups at our location and so as to restore in case of any downtime and not be dependent on the offshore team .There exists a maintenance plan in sql 2008 which needs to be amended to achieve this. what is a better option,using the current ftp service which exists in the database machine or on a different machine? any suggestions on encrypting the backup files?thanks

sql-server-2008log-shippingstandby-server
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Kristen avatar image
Kristen answered

Does answer your direct question, but for a stand-by server I would look at log shipping (i.e. shipping all transaction logs, and restoring them as they arrive) rather than just transferring FULL backups, or similar, daily / weekly.

When we have done this before we have used ZIP to compress and then PGP to encrypt and put the resulting files in a folder which is then polled and pulled from the remote machine, but I expect that nowadays SQL has inbuilt FTP that can do the whole job for you.

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.