Click here to monitor SSC

backup problem in SQL 2005

Last post 06-29-2009, 11:40 PM by bangla. 0 replies.
Sort Posts: Previous Next
  •  06-29-2009, 11:40 PM Post number 73909

    backup problem in SQL 2005

    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.

     

View as RSS news feed in XML