How I can increase the size of the database?

kanika

How I can increase the size of the database? it's 92%
thanks.

postsaurav

Hi kinka,

which database? Native or Microsoft SQL.


Thanks & Regards,
Saurav Dhyani
http://saurav-nav.blogspot.com/

kanika

NAV 2009 Classic AP1 with SQL

kanika

sorry SP1

manikandan

Hi kinka,

To increase the size of a database :
1. In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand that instance.
2. Expand Databases, right-click the database to increase, and then click Properties.
3. In Database Properties, select the Files page.
4. To increase the size of an existing file, increase the value in the Initial Size (MB) column for the file. You must increase the size of the database by at least 1 megabyte.
:thumbsup: :thumbsup: :thumbsup:
Regards,
Muthu

akhileshek

Hi kinka
You can Increase the size of database from Nav .
File>Database>Alter database
go to database file tab Increase the size of NDF file >>Ok... \:D/

Regards
Akhilesh

kanika

There is 2 NDF, NAVISION_DATA and NAVISION_1_DATA

Do I must increase both?

manikandan

Hi kanika ,
yes,u must increase 2 NDF.ie, NAVISION_DATA and NAVISION_1_DATA
:thumbsup:
Regards,
Muthu

bbrown

manikandan wrote:

Hi kanika ,
yes,u must increase 2 NDF.ie, NAVISION_DATA and NAVISION_1_DATA
:thumbsup:
Regards,
Muthu

No. You need to increase whichever one needs it. The first one rarely needs to be increased in size depending on how large it was made in the first place. Things like addign a lot of companies will increase the demand on the first file. It's the second one that holds all the data and usually needs to be increased.

David_Singleton

kanika wrote:

There is 2 NDF, NAVISION_DATA and NAVISION_1_DATA

Do I must increase both?

Kanika,

this is a little confusing.

Best will be if you post the EXACT details of all the files you have in your NAV/SQL database include all the ldf,mdf and ndf files along with the size of each file and also look to see how much space is used in them.

The naming convention you are showing does not look normal to me. And you can't expect correct answers if you don't give correct and complete information.

kanika

Well, I increased both NDF and the database is 23%

Thanks