someone pls tell me how to solve this two problems in sql 2005?
thanks.
Simulation 1
You work as a dba at abc.com.Need to do a backup that contains all the changes since the last transaction log back up . size of back up must be minimum. Back up file name must be aw.bak and it must be placed in the D:\backup folder.
Simulation 2
You work as a dba at abc.com Need to do a backup that contains all the changes since the last full back up . Backup file name aw.bak. size of back up must be minimum. Database is in logshipping-must not be interrupted. it must be placed in the D:\backup folder.