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

In the following command I try to shrink my log file down to 1GB. DBCC SHRINKFILE (‘SalesHistory_Log’, 1000) Also, make sure that your databases are NOT set to auto-shrink.

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

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.

Above, we have discussed how to rebuild the SQL database with corrupted or deleted log file. To rebuild the database, you need to first detach the database or take it offline.