Sql management studio 2008 r2 scheduled backup
To my surprise, there is still difference of Size in data and files, please see screen shots below.
= BACKUP OF DATA USING SQL SERVER 2008 R2 on Local Disk and on Network Share = I really wonder what has been done, the backup files in both cases have extension. To create split backup files with SQL Server Management Studio, perform the following steps: Open the Object Explorer, expand the Databases node, and right click on the database that needs to be backed up. The number of files that were backup were 28 items/files Creating split backup files with SQL Server Management Studio: Creating split backup files with SQL Server Management Studio.
#Sql management studio 2008 r2 scheduled backup software
= BACKUP OF DATA USING SQLDATABACKUPANDFTP SOFTWARE = When i took the backup of the data using the SQL Server 2008 R2 scheduler The number of files that were backup were 30 items/files = BACKUP OF DATA USING SQL SERVER 2008 R2 SCHEDULER = When i took the backup of the data using the SQL Server 2008 R2 scheduler = PROBLEM AND DIFFERENCE OF DATA BACKUP USING SQL SERVER TASK SCHEDULER AND SQL SERVER DATABASE BACKUP USING SQLDATABACKUPANDFTP SOFTWARE = Using both above methods for the backup on network drive, there is hell alot of difference of the size of data as compared to backup on local disk. Using SQLDATABACKUPANDFTP Software Using SQL Server 2008 R2 maintenance Job I wanted to take backup of all SQL SERVER 2008 R2 databases backup on network share, i already have a backup schedule for backup on local disk.
Difference in Size of SQL Server 2008 R2 backup on Local disk and on Remote Network Share