The transaction log file contains the SQL Server transactions of the database. It basically records the database transactions and the changes made by the transactions to the database. The logs are ...

I have a SQL Server database that's 145GB, about 80% of that space is occupied by "files". Staff have the ability to upload files from the web front end application into the database, this is used to ...

I would like to know is there a way to take a dat file and log file from one sql server and import that file to anther server. For example a customer has a dat file and log file on a cd rom and I want ...

In SQL Server Management Studio (SSMS), you can see the SQL Server database state. Alternatively, you can use T-SQL commands to verify your database status. You can use the DATABASEPROPERTYEX function ...