Backup with transaction log??

• jbalbo

  SSCertifiable

  Points: 7580

  More actions

  June 8, 2013 at 5:33 pm

  #278307

  Hi,

  I want to do a backup of a db and restore to another for testing purposes.

  The db is 100G with appx 70 being transactions log files

  can I do a backup/restore with the log files?

  Thanks

• Orlando Colamatteo

  SSC Guru

  Points: 182276

  More actions

  June 8, 2013 at 9:09 pm

  #1622264

  Yes. Lookup BACKUP DATABASE and RESTORE DATABASE statements in Books Online.

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato