Automatic Backup Procedures

navimbs

Hi,
What are the various alternatives to take automatic backups of Navision SQL Server database?

Are there any documentation available?

Thanks,
Best regards,

garak

Use SQL Backup from SQL Server.
Read the manuals or online help

kriki

[Topic moved from Navision forum to SQL General forum]

Best way is SQLServer backup (or some external application that makes a backup of the SQLserver DB).

Another is the client-backup, but it is manual. You can use the Windows scheduler to make a backup.

stryk

Hi!
As "garak" said, you should create your backups from SQL Server site only, never use the NAV Client site feature except for very specific purposes.

Check out the "Maintenance Plan" features from SQL Server, here you could setup everything fairly easy ...

Regards,
Jörg

Ola_Hallengren

I have a set of maintenance stored procedures that you are welcome to use. The backup stored procedure supports full, differential and transaction log backups. It also does verify of the backups as well as deletion of old backup files.
http://ola.hallengren.com/sql-server-backup.html

Ola Hallengren
http://ola.hallengren.com

hawwa

SQL Server has the built-in capability to do scheduling backup.