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
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/
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.
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.
Answers
which database? Native or Microsoft SQL.
Thanks & Regards,
Saurav Dhyani
http://saurav-nav.blogspot.com/
Thanks & Regards,
Saurav Dhyani
Do you Know this About NAV?
Connect - Twitter | Facebook | Google + | YouTube
Follow - Blog | Facebook Page | Google + Page
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
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
Akhilesh
http://navconsultant.com/
http://www.linkedin.com/in/akhileshek
Do I must increase both?
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.
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.
Thanks