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 ...

This means that something as trivial as a sick day can result in a system or data ... file via FTP, the next step is to automatically import that file into SQL Server. To do this, we’ll use ...

c:\data files\my_data.mdfClick the "OK" button. SQL Server Management Studio loads the database from the .MDF file. Click "New Query" in the Management Studio's main toolbar. This opens a large ...

If your database is small (100 MB or less), you do not need to worry too much about files and filegroups. But if you have a large database (in several GBs or TBs), separating the data into ... you can ...

and the other server is running SQL 2000. What is the T-SQL I need to use in order to delete files older than 'x' days? Since I'm not backing up the SQL 2000 dbs to the same directory, I can't use ...

but we don't always know the name of the instance (Always only 1 SQL Server running on a single server). If this was easy, we'd just run: ...