Following code always shrinks the Truncated Log File to minimum size possible. Use one of the following two procedures. PROCEDURE 1 USE DatabaseName GODBCC SHRINKFILE(<TransactionLogName>, 1)BACKUP LO...
The default instance of the Database Engine listens on port 1433; therefore, you do not have to configure a fixed port. However, named instances including SQL Server 2005 Express Edition listen on dyn...
Before this make sure there are free entries by setting the recovery model to simple or backing up the log. Enterprise Manager: Right click on the database, All tasks, Shrink database, Files, Select l...
If you have a Dedicated or Virtual Server with DNN4Less, Login to your server using (RDP) Remote Desktop Protocol. Click on Start Click Run. Type Services.msc, press Enter. Look for SQL Full-text Fil...
If the log file has grown do to being in full recovery mode then set it to simple before going any further. This should immediately stop the log from growing. Enterprise manager: Right click on the da...
SYMPTOMS: When you trry to connect to database servers where you are not in full control over all databases, or where some of your databases are ever offline (or auto-closed), the new version of Manag...
Often, when restoring a database from a remote machine on my local development machine, my user logins no longer work for that database. The problem lies with the fact that while the user name is the ...
To back up a transaction log 1. After connecting to the appropriate instance of the Microsoft SQL Server Database Engine, in Object Explorer, click the server name to expand the server tree. 2. Expa...
If the log file has grown do to being in full recovery mode then set it to simple before going any further. This should immediately stop the log from growing. Enterprise manager: Right click on the da...
Add dynamic to your site using MySQL, learn how to install PHPMyAdmin, create and administer new users and back up your database content with this quick start guide....