MS SQL Server 2014 2

[jchewsmith]

Best practices for backing up a database from one server to another.



I have a database that I want a copy of saved after each month end.

What is the best method for backing this up to another server?

Thanks

 

[simian336]

That really depends on the on use of the 2nd server. You are only doing this once a month so log transfers would only be useful if you have a really small pipe (or needed higher frequency).

So absent any other restrictions I would say a normal backup and restore. Keep it simple.

Simi

 

[johnherman]

Agree, a simple backup and restore.

Alternately, you could set up replication for the end of the month. Replication will probably be slower than a backup and restore, depending on how many transactions you do each month.

==================================
advanced cognitive capabilities and other marketing buzzwords explained with sarcastic simplicity