We have an app that stores documents in the database as a varbinary(max) column. Our current average document size is about 475KB, so these are not large documents by any means, but there are a fair ...
Master database file or MDF file is a primary database file that contains fields, tables, indexes, stored procedures and other data in SQL Server. Like other data files, this file is also susceptible ...
Ok, so my boss wants me to find out about making some log files smaller. For example, one database has a data file that's about 50 MB, and the log file is about 550MB. He wants to clear up space and a ...
If you don’t have a backup of your MS SQL database, then follow the below ways to recover deleted data. Transaction log files record each change made to the ...