Backing up from within client or from SQL Server Management?

(0) Share

Report

Posted on by addision1

323

Which is a preferred method for routine backup of NAV companies? In addition, can you set an automatic backup of the companies within the NAV client? I know we can script or use a utility for the SQL database.

We would prefer to backup nightly.

Thank you.

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (4)

Verified answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (2)

Report

You can use Powershell or Create SQL Maintenance Plan to do regular backups of the database

www.waldo.be/.../nav-2013-r2-backup-and-restore

YOu cannot automate backup using NAV Client you need to use Powershell or SQL.

msdn.microsoft.com/.../ms187658(v=sql.110).aspx

Was this reply helpful? Yes No
Verified answer

Ashwini Tripathi 4,624 on at

Like (2)

Report

You can use this scrip if you prefer to use PowerShell:

Backup-NAVSqlDatabase `

-DatabaseServer $NAV_DatabaseServer `

-DatabaseInstance $NAV_DatabaseInstance `

-DatabaseName $NAV_DatabaseName `

-DatabaseBackupFilePath $NAV_DatabaseBakFile

replace all variables with suitable actual values.

another way is you can schedule a job to take backup of the database in SQL Server.

Under Management -> SQL Server Agent -> Jobs and configure the backup script / parameters.

Was this reply helpful? Yes No
Verified answer

Alexander Ermakov 28,096 on at

Like (0)

Report

To me the best option is to schedule SQL Maintenance Plan and setup the period for the backup: msdn.microsoft.com/.../ms187658.aspx

Now it is very easy in SQL Management Studio with Maintenance Plan Wizard (you basically do not need to write any SQL queries for that!):

msdn.microsoft.com/.../ms191002.aspx

(compare to this: msdn.microsoft.com/.../ms189953.aspx)

Was this reply helpful? Yes No
Suggested answer

Ashwini Tripathi 4,624 on at

Like (0)

Report

Here i have published two blog posts specially for you with both option you can have a look:

SQL Server Database Backup using PowerShell : msdynamicsnavashwinitripathi.wordpress.com/.../sql-server-database-backup-using-powershell

Schedule SQL Job for SQL Database Backup :

msdynamicsnavashwinitripathi.wordpress.com/.../schedule-sql-job-for-sql-database-backup

Mark the solution as Suggested answer if you find this helpful and resolves your query.

Was this reply helpful? Yes No
Suggested answer

RockwithNav 8,600 Super User 2025 Season 2 on at

Like (0)

Report

Hey addidion1,

I belief SQL Job queue will be the best approach for doing so. From SQL Server Agent you can go and assign it and can give a designated timing to take the backup. it will keep taking the backup everyday and let it get saved to a desired location.

Was this reply helpful? Yes No
Verified answer

Tharanga Chandrasekara 23,118 on at

Like (0)

Report

For me SQL Agent is the most easiest way to take backup, however as suresh mentioned you can use Powershell to do regular backups of the database.

Was this reply helpful? Yes No
Suggested answer

Roberto Stefanetti 12,998 on at

Like (0)

Report

hi,

use SQL Maintenance Plans (for Backup, Tables optimizations etc., best solution i think) or use SQL scheduled jobs instead of maintenance plans.

...but... if you want to use NAV Client to achieve this gol... you can run powersehll from NAV (a nice Waldo production!") www.waldo.be/.../running-powershell-from-nav

Was this reply helpful? Yes No
Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report

Backup is an important component of a sound disaster recovery strategy. Presence of a valid and restorable backup is the last thing you should worry about when the moment comes to execute a real disaster recovery scenario during an emergency downtime. Here are some best practices you can follow to ensure you have a good backup in place:

1) Make sure you are not storing your backups in the same physical location as the database files. When your physical drive goes bad, you should be able to use the other drive or remote location that stored the backups in order to perform a restore.

2) Make sure you have a proper backup schedule established according to the needs of the application and business requirements. As the backups get old, the risk of data loss is higher unless you have a way to regenerate all the data till the point of failure.

3) Make sure to actually restore the backups on a test server and verify that you can restore with all the options and conditions you need to use during a planned or un-planned downtime.

4) Use the verification options provided by the backup utilities [BACKUP TSQL command, SQL Server Maintenance Plans, your backup software or solution, etc].

Was this reply helpful? Yes No