-
You can find out how to adjust your transaction log in SQL Books Online. Basically the steps are: 1) Full DB backup (optional as a precaution) 2) backup log <databasename> with truncate only - where databasename is the name of your database 3) dbcc shrinkfile(<filename>) - where filename...
-
Is that including the transaction log or just the data files? If the transaction log files are included, then those need to be truncated. Also, just because the data file size is 48GB does not mean that it is all in use. Large database size for NAV databases is usually because the database is massively...
-
hi friends i am converting a native DB to SQL . Native DB size is 8 GB . when i am converting this to SQL the size is 48 GB . why is that. can i reduce the size. is there is any methord to reduce the size of the SQLDB . please help me guys regards satheesh
-
Hi David, But it seems NAVISION 4.0 with SP1 cannot be run in 3 tier way. Then how do I implement 3 tier architechture using the same. I want to have a seperate SQL Database Server, an NAV Client Server to which the users wud connect to access the SQL Database Server. Its not possible to migrate to NAV...
-
Don’t compress Log files to minimum since it will grow. Shrink only to reasonable size. Or better don’t Shrink it.
-
Check some posts in this forum. http://dynamicsuser.net/forums/71.aspx There are a few posts about performance and reducing DB size.