Need to move NAV 4.0 SQL solution

(0) Share

Report

Posted on by EPi_2013

The drive on our server is filling up and we need to move the database to another drive. We work with an outside IT company and they are looking for the correct way to move the database. Does anyone know what we need to do? Thank you for your support.

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Roberto Stefanetti 12,998 on at

Like (0)

Report

hi,

many solutions about this issue.

1- backup and restore database on new device (if is on the same server, if not you need transfer users) > after rebuild indexes

2- detach\attach database datafiles on new device (or detach\attach only 1 or more files on new device, look at sql server datafiles managing help ..... sql commands like this 'MODIFY FILE ( NAME = logical_file_name, FILENAME = ' new_path/os_file_name ' )

msdn.microsoft.com/.../bb522469.aspx

3- backup from NAV, create a new DB, restore from NAV Backup > after optimize tables

Was this reply helpful? Yes No