NAV 2013 RTC Backup option

gandhi_nkl

Dear All,

Suppose after implementing NAV 2013 RTC for a customer, how the user can take the Navision backup in RTC?

As of my knowledge we can take Navision backup from the Development environment.

ben5000

In NAV 2013 the native database engine is discontinued so it's impossible (out-of-the box) to process backups within the RTC or Classic client.
You need to perform backups & restores through SQL Server (you can use SQL Server Management Studio for a more user friendly interface).
You can always use .Net interop or other customized code to launch SQL backups from RTC..
But be aware that this kind of task should be reserved for technical people who are supposed to be able to create backups with SSMS..

mohana_cse06

yes, it is not possible to take backup from RTC..

you can create job in SQl to take automatic backup.. :thumbsup:

ben5000

Indeed and it is by far the best way to implement backups

gandhi_nkl

mohana_cse06 wrote:

yes, it is not possible to take backup from RTC..

you can create job in SQl to take automatic backup.. :thumbsup:

Hi,

Yes we can take SQL automatic backup. But problem is that Customer done some mistake in posted entries. He wants to take a Navision backup then creating test database in same SQL then restoring and he can play around. Our NAV 2013 doesn’t have that feature. Suppose migrated customer NAV 2009 to NAV 2013 but they are asking this feature.

But NAV Tech guy can do anything, but not customer.
I feel our NAV 2013 Not user friendly. Am I right?

mohana_cse06

No need to have option for customer to take backup.

The system admin or partner has to take backup and create a new test environment for user..

gandhi_nkl

mohana_cse06 wrote:

No need to have option for customer to take backup.

The system admin or partner has to take backup and create a new test environment for user..

Absolutely you are correct. But newly migrated customer will comment us like Microsoft reducing features from older version.

mohana_cse06

Its not like reducing..you have the development client for doing all these things..

Belias

it's just another (better) way to do things:
nav backup takes forever, sql backup is lightning fast (it's just ONE of the pros of the sql backups). They've not reduced features, they just implemented them in another way.
That said:
- if the end user is able to backup/restore his own database, well...it's scary.
- If the end user has an internal IT guy to do this kind of things, he usually knows better sql than NAV
- if the end user is a power user who sometimes do these kind of "corrections", i think he's skilled enough to learn how to backup/restore a SQL database in a pair of hours (recommended), or just give him some scripts (faster but a bit risky -you know, misclick is behind the corner -)

gandhi_nkl

Belias wrote:

it's just another (better) way to do things:
nav backup takes forever, sql backup is lightning fast (it's just ONE of the pros of the sql backups). They've not reduced features, they just implemented them in another way.
That said:
- if the end user is able to backup/restore his own database, well...it's scary.
- If the end user has an internal IT guy to do this kind of things, he usually knows better sql than NAV
- if the end user is a power user who sometimes do these kind of "corrections", i think he's skilled enough to learn how to backup/restore a SQL database in a pair of hours (recommended), or just give him some scripts (faster but a bit risky -you know, misclick is behind the corner -)

Many thanks to you all to giving inputs.