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.
Loading
Anupam SinghPosted Jun 2, 2014, 5:03 AM
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
you can go for differential backup .
Lakshmanan Sethu SankaranarayanPosted Jun 2, 2014, 5:00 AM
Pls try incremental back ups
http://technet.microsoft.com/en-us/library/ms174582.aspx
Khan Abrar AhmedPosted Jun 2, 2014, 4:55 AM
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