March 27, 2009 at 11:06 pm
Hi,
Please tell me what back up should be taken once db is updated. i.e. earlier i took FULL backup and now i have added few things and deleted. I want to reflect these changes only in backup.
So, Differential Backup will do?
March 28, 2009 at 5:43 am
makjain (3/27/2009)
Hi,Please tell me what back up should be taken once db is updated. i.e. earlier i took FULL backup and now i have added few things and deleted. I want to reflect these changes only in backup.
So, Differential Backup will do?
Yes, you can either take differential or transactional backups.
Differential backups backs up all the changes that has been modified since the last Full backup and Transactional backup backs up all the changes since the last transactional backup.
Since your's is a small change even the size of a differential would be small enough.
March 28, 2009 at 7:24 am
ok thanxs alot..!!
March 29, 2009 at 9:31 am
It also depends on the database’s size. If the database is very small and there is no need to use features such as restore to a point of time, you can use a full backup again.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply