Home Forums SQL Server 2008 SQL Server 2008 Administration Transaction Log Backup RE: Transaction Log Backup

  • February 11, 2013 at 7:57 am

    #1586584

    midnight251 (2/10/2013)

    Thanks for the reply, that's great info. I'll be on it first thing tomorrow. I take it that I can do this while the DB is in use? We are running MS Dynamics NAV ERP using the DB. I'm going to get this going tomorrow.

    Thanks again for the response.

    There won't be any issue taking either Full, Differential, or Transaction Log backups while your server is in use. There will be some contention (disk IO) as a result of the backup process but ordinarily, with a decent disk subsystem this won't be an issue. Are you going to be backing this data up locally or to a remote storage device (preferred)?

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience