Skip to main content

Truncate Logs on SQL Server 2008


Truncation of Logs in SQL Server 2008 is different from SQL Server 2000/2005. The Truncate_only Option has been terminated (I guess this was to save the integrity of Data). Until Microsoft makes an option to right click on the Database and Select "Truncate Database". Follow the steps below for now.

Do you have a SQL Server 2008 Database with Truncating Logs that are out of control, the Event Viewer is showing Event 9002 MSSQLServer. Then you need to immediately truncate your logs for your database. This will allow you to be able to access, login and use your database. If you are unable to login to vCenter, the first thing you need to do is check your error logs for Event 9002 MSSQLServer and see if you have a message for the database being Full.

1. Verify if you have the following Error under “Application” in Event Viewer on your Windows 2008 Server:
  • Event 9002, MSSQLServer
Event 9002, MSSQLServer



2. After verification, open the SQL Server 2008 Management Studio. Login and select the database. (Need Microsoft SQL Server 2008 Management Studio? - Click Here)

3. You will need to temporarily switch the Database to “Simple” in order to manually truncate the logs. Right-click on your database and select PROPERTIES.
  • Simple DB
Simple DB


4. Select OPTIONS and then Switch the Database to “Simple” and click OK.
  • Options Change for "Simple"
Options Change for "Simple"


5. After you have changed the Database to “Simple”. You can begin your cleanup. Click on the Database and run the following commands (You can highlight the text and click F5 key to run the commands or click on EXECUTE in the toolbar:
SELECT name, size FROM sys.database_files;
GO

6. You will see two lines that tell you the actual name of your database (if it has been changed or is somehow different from a backup, etc. You never know so CHECK FIRST!)

7. After you have the correct log file database name run the following command:
DBCC SHRINKFILE (DATABASE_log, 2);
GO
  • The Truncanatorrrr!
The Truncanatorrrr!


8. After completing the maintenance. Follow Steps 1-4 to Change the Database back to “Full”.
FYI. Make certain that you have Maintenance Plans Setup for Full AND Transaction Log Backups!

9. Immediately Perform a Full Backup of the Database after you have completed all of your operations.

Popular posts from this blog

How to Configure BGInfo for Windows Server 2012 R2

FYI: It's not hypervisor specific and works fine for physical servers also.
Download BGINFO from Microsoft Downloads Only
http://technet.microsoft.com/en-us/sysinternals/bb897557

1. Create a folder named bginfo under C:\bginfo
2. Extract all of the contents of bginfo to that folder.
3. Open Bginfo and setup your configurations.


*Custom configurations can be found here thanks to Shay Levy: http://blogs.microsoft.co.il/scriptfanatic/2008/07/22/bginfo-custom-information/

4. Once you have completed your custom configurations. Click on File Save As and save your .bgi configuration to C:\bginfo (Don't bother saving to C:\Windows\System32\* SysPrep and Imaging will strip and mess up any settings so don't bother) *Do NOT just clone your VM's!!


5. After you have saved your configuration. Create a batch file named whatever and add the following to the first line (*whatever you named the .bgi file is what you put second after the bginfo.exe path):


6. In case you forgot how. Enable…

How to Configure HP ILO 4 for Active Directory Login

1. Make sure that your Windows Active Directory Domain Controller has an SSL Certificate to support port 636 (HP's authentication doesn't like 389)

2. Use Softerra LDAP Administrator (or whatever is your preferred tool to get the OU path) if you don't know how to do it by heart (which...um...sometimes its better to verify).

3. Make sure that you have a way to authenticate users by adding in the OU where your restricted accounts are located. You don't want anyone in the domain to be able to login to the server.

ILO Login > Administration > User Administration - Click New and Add the Group DN Only:



Click Add Group and then you will see your group added. (*Make sure it's a security group)


4. Add in your Windows Active Directory DC to authenticate against (Verified against 2008R2):

ILO Login > Administration > Security - Directory (*Make sure it's the OU where the security group is)


5. Sign Out (Log off) and then Log Back in (If you don't see Direct…

How to Launch Citrix .ica files Using Google Chrome

Updated: 10/19/2013

One of the problems you may face when launching a Citrix Application in Google Chrome is that .ica may not launch automatically. This is what you have to do to make it work. (Tested only on Citrix XenApp 6.0/6.5)

Option A:

1. Login to your Citrix XenApp web interface public facing website.
2. Click on a Citrix application to launch.
3. The file will "download". Click on the arrow and select "Always Open Files of this Type"


4. Click on the name of the application and it will launch. [Optionally, after selection. Launch the item again from Citrix. It should launch]

Option B:

* Usually for people that can't seem to launch anything in Citrix XenApp
* Mac User's. Just make sure that you have Citrix Receiver for Mac (11.8) Installed and after completing Option A. *You "shouldn't experience issues", it seems to be a Windows issue.
1. Click on the tool option and select options (Windows/MAC - Settings)


2. Settings => Show Advanced…