Database backup and restore

Question

Hi I have a retail software that uses the sql server 2005 database in the stores. I have 5 stores where this software and sql server 2005 is installed. I ma taking the backup of the database everyday before start the sale. Now this database size is increasing everyday. This creates a problem to send this backup to the server through mail or ftp. Is there any mechanism into the sql server to take only that part of data which is new or updated i.e. only the transaction of previous day or any updated thing. Please help me.

Anupam Singh · Answer

Hi ashutosh there are 3 types of backup in sql server. read this for details : http://www.todo-backup.com/backup-resource/sql-backup-software/sql-backup-types.htm y ou can go for differential backup .

Lakshmanan Sethu · Answer

Hi Pls try incremental back ups http://technet.microsoft.com/en-us/library/ms174582.aspx

Khan Abrar Ahmed · Answer

Hi you can use the compression of db backup or differential backup. refer this links http://www.sqlteam.com/article/introduction-to-sql-server-database-backups