Change NAV SQL DB to another New Drive

(0) Share

Report

Posted on by Community Member

Hello,

The current NAV Drive(E) cannot be extended for more space storage due to some error and it is recommended to create a new storage drive(F) for NAV DB within the current server to resolve the problem. What would be the best solution to migrate NAV DB to new Drive location.

Thank you

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

Ashwini Tripathi 4,624 on at

Like (1)

Report
Copy link

Link copied!

Take the database offline, disconnect/detach the database. Copy the file to new drive and attach back to SQL Server. Make sure you define path correctly for each file while you attach back.

This Link can help : msdn.microsoft.com/.../ms190794.aspx

change the version to one which you are working.

Was this reply helpful? Yes No
Suggested answer

4BzSoftware 6,073 on at

Like (1)

Report
Copy link

Link copied!

Hi Eri,

Detach, copy and attach database as Ashwini mentioned is a way. Besides, you can:

1. Stop all related NAV Services.

2. Backup database.

3. Rename database (on drive E).

4. Restore the backup with original database name, to drive F.

5. Start all related NAV Services.

Was this reply helpful? Yes No
Suggested answer

Rabin 2,976 on at

Like (0)

Report
Copy link

Link copied!

Hi Eri,

Agree with other members Follow the steps shown by Ashwini [ also agree with khoa]:

Always make sure you stop the Services. Before taking the Database offline make sure all the users have saved their works and closed the session.

Also make sure your Drive is not corrupted, run the chkdsk command to ensure the disk partition is healthy....

And last but not the least always keep a backup in another media...

-----------------

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Thanks Ashwini

Was this reply helpful? Yes No