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…
Backing up a site collection from the command line
In addition to backing up my SharePoint site collection with Symantec BackupExec, I will occasionally use the command line tools to backup to file. This is quite easy to do in just a few steps: Logon to the SharePoint server…
Using Symantec Backup Exec to backup SharePoint
As I use Symantec BackupExec on my network I have purchased the agent for SharePoint. This will allow me to backup the entire server or farm with the ability to perform a granluar restore. To backup the SharePoint server efficiently…