title: SQL Server 2017 - copy entire DB to another server on an ongoing basis via a script
body: <p>I need to copy an entire DB from 1 server to another on a daily/scheduled basis.
  Can't use replication - can't add GUIDs to the DB (Source DB - is based on a going  restore).</p>
  
  <p>How can I write a script to copy the entire DB + logins etc to another server.
  I can drop the destination DB if needed each time.</p>
  
  <p>Any ideas on a script?</p>
  
  <p>thanks in advance!</p>