Move user databases [!INCLUDE SQL Server] In [!INCLUDE ssNoVersion], you can move the data, log, and full-text catalog files of a user database to a new location by specifying the new file location in ...

When moving a TDE protected database, you must also move the certificate or asymmetric key that is used to open the DEK. The certificate or asymmetric key must be installed in the master database of ...

Overgrown transactional log files can turn into real problems if they are not handled properly. Today SQL Server consultant Tim Chapman discusses the perils of not handling SQL Server log growth ...

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

So I have a specific database that won't release and shrink its log files. The DB backups are happening successfully, but I still have 4GB of logfiles (and no, this DB does not generate 4GB of log ...

I have a SQL 2000 SP4 server and MOM 2005 is reporting that the tempdb database log file is getting to large. Sure enough, it the templog.ldf file is a little over 9GB in size.I honestly don't ...