70
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
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
Share
Report
All responses (
Answers (
