Back-up SQL 2005 with NTBACKUP and Volume Shadow Copy

[Former Member]

Hi everybody,

I want to make a snapshot backup of a SQL 2005 database with SAP ECC6.

I want to use NTBACKUP to make the snapshot.

Does the database freeze at the moment of the snapshot?

Does anybody use this method?

Thanks in advanche.

Kind regards,

Klaas van Deelen

[Former Member · Accepted solution]

NTbackup uses VSS to create the copy of FILES.

VSS is not designed to replace your current backup strategy,

VSS will copy a data file, then another, then another etc - heres the problem sapdata1 and sapdata2 will be backed up at DIFFERENT times. if you tried to restore the DB, it would NOT be consistent.If VSS backed up the files OFFLINE - np, it will work.

VSS cache is also on the system (default) as the original data - not really a smart idea for a backup solution.

Use either the SQL tools to backup online to tape/external storage or get the symantec backupexec with the SQL agent to allow for online backups again to tape or nearline storage.