O'Reilly logo

Microsoft SharePoint 2013 Disaster Recovery Guide by Joel Plaut, Jeff Gellman, Pat Esposito, Peter Abreu, Pavlo Andrushkiw, Peter Ward

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

System database backup and restore

Backing up SQL Server system databases (everything) will restore and recover the SQL Server system in the event of a system failure, such as the loss of a hard disk. The system databases backup include msdb, master, and model. If replication is being used, the distribution database is required.

Note

The backup frequency and retention are usually based on the company's policy. As a general rule of thumb, take a daily full backup, followed by before and after backups when adding a new database or making structural changes to the SQL Server instance.

Backing up DB using SQL Server Management Studio

  1. Connect to your instance in the SQL Server database engine; on the left hand side, click on the server name to expand the ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required