DB Backup

• prakash414

  SSC Journeyman

  Points: 85

  More actions

  March 10, 2009 at 6:01 am

  #135482

  Hi,

  Please let me know the query for

  1. DB backup when the database is in standby/readonly mode

  2. and how to take a backup of transaction log files.

  Thanks in anticipation.

• Adiga

  One Orange Chip

  Points: 27284

  More actions

  March 10, 2009 at 6:12 am

  #956701

  These links might help you

  http://msdn.microsoft.com/en-us/library/ms190374.aspx

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

  Pradeep Adiga
  Blog: sqldbadiaries.com
  Twitter: @pradeepadiga

• Brandie Tarvin

  SSC Guru

  Points: 173068

  More actions

  March 10, 2009 at 6:22 am

  #956713

  BOL (Books Online) is also a good resource.

  I'm pretty sure that backing up a standby database is not really any different from backing up a regular database.

  Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.