Month: June 2016

SQL Server backup

SQL Server backup Using Management Studio and Transact-SQL

SQL2008

How to create a full database backup in SQL Server 2008 R2 by using SQL Server Management Studio and Transact-SQL,  As a database increases in size full database backups take more time to finish and require more storage space. Therefore, for a large database, you might want to supplement a full database backup with a series of differential database backups.

more …