For as long as I can remember, I have always configured the computers within my own organization to store data on network servers as opposed to the data being stored on workstations. That way, if one ...
To back up a database, you can use the BACKUP DATABASE command in SQL Server. This command will create a full backup of the database to a specified location.