3 ms·
I backup code to flash once a day in case of hardware failure. Once a week I swap flash drives into a safety deposit box. I also backup any local databases to f
by fnid2 17y ago
I backup code to flash once a day in case of hardware failure. Once a week I swap flash drives into a safety deposit box. I also backup any local databases to flash once a day. Use a scheduled task and a .cmd for that, which automatically stops SQL Server, 7z compresses and encrypts the database files and source code repository, then move them to a usb flash drive, then restarts SQL Server.
I never upload code to the internet, but I have copies of the repository in multiple locations separated by at least 3000 miles.
Nightly I backup internet databases to a cloud storage provider. Nondatabase files are stored simultaneously on local storage and cloud storage. The local storage is mirrored to local snapshots hourly and nightly in case a roll back is needed.