Quick note on Microsoft SQL transaction log file

Every MS SQL Server database consists of at least two physical operating system files and these files are specified when a database is created or altered. One and possibly more (secondary files) are used for the data (as well as indexes and allocation pages) and one for the transaction log.

Tags:      

Posted in: Databases, MSSQL | December 14, 2009
| No Comments

What to do when you need to import a large MSSQL database dump inside a virtual machine and you have no sufficient space?

It is a good idea to hold your database server inside a virtual machine and run it only if needed. This will save the memory space from being loaded with running services when you don’t need them. But what if you need to import a large database dump file and there is no sufficient space [...]

Tags:      

Posted in: MSSQL | December 4, 2009
| One Comment