backup in SQL and restore the backup in another database

Dynamics 365 Business Central/NAV Technical Forum
#1

i want to make a backup for a client using Nav 5.0 with sql server and then restore the backup. is it possible and also what are the precautions i musk take and how can it be done?

Do we have table locking problems with sql as database as a client wants to close the income statement for a particular year and since the client has loads of transactions, she want to know if she must ask all users to log off from navision and secondly how much time it can take(about 1000 lines per batch)?

#2

What you want to do is take a full backup of the database. You can then use the resulting backup file to restore to a separate database.

You might do this when the workload is relatively light on the primary database.