SQL query to take DB back up

• Manikandan Subramani

  SSC Journeyman

  Points: 78

  More actions

  March 8, 2010 at 6:49 am

  #212144

  Hi All,

  I need a SQL query to take the DB backup of Transactional Log type. Any idea bout this.

  Regards,

  Mani.

• SQL Dev-938873

  Ten Centuries

  Points: 1280

  More actions

  March 8, 2010 at 7:03 am

  #1129983

  BACKUP LOG DBNAME TO DISK = FILEPATH

  GaNeSH

• Bhuvnesh

  SSC Guru

  Points: 59351

  More actions

  March 8, 2010 at 7:47 am

  #1130017

  Read below post

  http://technet.microsoft.com/en-us/library/ms191284.aspx

  And why we require to do it

  http://support.microsoft.com/kb/873235

  -------Bhuvnesh----------
  I work only to learn Sql Server...though my company pays me for getting their stuff done;-)