Computer database software such as Microsoft's SQL Server benefits all types of businesses, as it makes recordkeeping fast, flexible and secure. SQL Server lets you disconnect a database from the main ...

1.first we will check what is current data file utiization and how much free space in the file. ,[FILESIZE_MB] = CONVERT(DECIMAL(10,2),A.SIZE/128.0) ,[USEDSPACE_MB ...

- = .ldf === [ còn file .ldf để ghi lại những thay đổi của databse , roll back lại version trước đó nếu có gì đó sai xót ] - hay còn gọi là file nhật ký - = .bak === [ file bak nén hai file .ldf và ...

So I've had a case open with Microsoft since October concerning SQL databases that I cannot restore from DPM unless I run a consistency check on them first. Today, it seems they assigned to me yet ...