Example SQL query to backup a database to disk
This sample SQL query can be executed to backup a site collection database to a file, where WSS_Content_Intranet is the name of the database used by the Site Collection. Use WSS_Content_Intranet DBCC Shrinnkfile (‘WSS_Content_Intranet’) DBCC Shrinnkfile (‘WSS_Content_Intranet_log’) Go Backup Database WSS_Content_Intranet To Disk…