Post reply

temporary back file

  • July 20, 2006 at 3:47 am

    #118791

    Hi

    I'm new to SQL Server.

    Could anyone tell me why you would want to create a temporary back up file (instead of a permanent one)?

  • July 21, 2006 at 12:35 pm

    #650824

    If you are meaniing a backup file other than the normal full backup (I call them 'special' or 'one-time' backups'), there are a few reasons. DB upgrades, software upgrades and application upgrades just to name a few.

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • July 21, 2006 at 1:21 pm

    #650848

    shipping a database to another site without breaking the backup chain locally. SQL Server 2005 supports the "one off" kind of backup but 2000 doesn't.

    Wes

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply