Best way to backup a SQL Server database nightly?
- by Urda
What is the best way to backup a SQL Server 2005 database nightly?
I'm looking for a solution/strategy that would make the database backup file, and place it in an "outgoing" directory. We're wanting our FTP software to move it out to an offsite server.
Any suggestions on how to make this work as desired?