Thursday, March 8, 2012

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

Saturday, November 19, 2011

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 Settings => Content Settings => Plugins Select the option underneath "Disable individual plug-ins... (**Optionally, just type in "Content" in the Search Bar under settings)


3. Disable Citrix Receiver. Close the settings browser and then log back into Citrix. Launch an application. It will now work flawlessly. 


(FYI. Make sure you complete Option A if you have not before launching an application after completing Option B.)

4. Download the latest version of Citrix Receiver from the Google Chrome Web Store:
http://www.citrix.com/downloads/citrix-receiver/other-platforms/receiver-for-chromebook-111.html

***Disclamier: Citrix requires Storefront server to be setup and enabled by your IT Engineer/Citrix Administrator in addition to XenApp or XenDesktop. This "work around" by Citrix is a limitation that the company hasn't addressed on the actual receiver client technology itself. The other alternative is for Citrix to work with Google's Chrome team directly to have them fully integrate the .ica file technology into Chrome like Adobe's technology. Outside of this...you have to setup a Storefront server. Yes, it is a PITA workaround.*** 

Option C:

VMware fully supports Google Chromebooks and Google Chrome with VMware Horizon Suite 5.3 (Horizon Mirage 4.3 has been merged with VMware Horizon View) Formerly, VMware View.

VMware Horizon Suite 4.3 fully supports Google Chromebooks via a real HTML5 Application.

http://www.vmware.com/company/news/releases/vmw-euc-portfolio-10-15-13.html
http://www.vmware.com/products/horizon-suite/



1. Buy a Chromebook: http://www.google.com/intl/en/chrome/devices/chromebooks.html

2. Buy a Chromebox: http://www.google.com/intl/en/chrome/devices/chromebox.html

Share:

Friday, October 21, 2011

How to Launch Java using Google Chrome

Dell and many other vendors take forever to support modern browser technologies. They really need to keep up. Also, browser vendors have to pick up the slack for these slackers sometimes also.

When navigating to Dell DRAC or any other website that runs off of Java. You may run into a .jnlp error where you can't launch the file. This Java drop download and launch option doesn't work for Dell DRAC (But it does work for KVM's).

Here you go.

1. Log into Dell DRAC and click on launch:

2. Go to your downloads folder and change the extension at the end of the file. (Just click on it and at the end of the file type .jnlp and hit enter) This will make the file a JNLP file.

3. Double-click the filename and launch:


Yes. It's a pain in the neck workaround, but until Dell test's it or Google fixes launching Java files. This is what will work.


Share:

Tuesday, July 12, 2011

How to Add a LDAP Server Symantec Endpoint Protection

One of the things that many customer's run into or IT professionals is locating how to actually add an LDAP server to Symantec Endpoint Protection. It is a little bit of a really clunky process which is a testimony to lack of Symantec Research and Development Budgeting. Here you go!

1. Install your Windows 2008 Server for SEP and make sure server is joined to your domain.
2. Install Symantec EndPoint Protection (Latest Release) v.11 is used for this tutorial.
3. Admin > Servers > Local Site > {Your Server for SEP} > Edit Properties > Directory Servers




















4. Add your Active Directory LDAP Server. (Replication Tab is for other DC's, etc).

Share:

Monday, June 20, 2011

How to Create GPO Mapped Drives in Windows 2008 R2

Do you need to create a GPO Mapped Drive for Windows 2008 R2?


NOTE: If you are still using Windows XP (SP3 is the Only Supported version from Microsoft) Desktops. You must install this patch via WSUS (Windows Update) in order for GPO Drive Mapping on a Windows 2008 R2 Domain to work: KB943729


http://support.microsoft.com/kb/943729


Quick a dirty:

1. Create your AD
2. Create your GPO Groups in AD and make them simple and human readable please people...
3. Now the fun stuff...






5. Tweak to your needs!

Have fun...
~MigrationKing


Share:

Saturday, June 18, 2011

Active Directory Bulk User Import - Using DSAdd User

Need to get a lab live? If you are tired of waisting money and hours on Google searching for Active Directory User Import Tools and commands, just use this Excel File to run a bulk of users in a batch file from PowerShell or Command Prompt.

Here is the dsadd user command that will be created by the excel file by just adding your users and department OU sections:

dsadd user "cn=Migration King,ou=Users,ou=IT,ou=Departments,dc=us,dc=migrationking,dc=com" -fn Migration -ln Migration -samid MKing -upn MKing@migrationking.com -display "Migration King" -pwd P@ssw0rd -mustchpwd yes -disabled no

(For people that submit tweaks and fixes, please email support @ migrationking.com and we will add your edits and your name showing who submitted the correction/edits).
1. Option A: Sign into Google Docs and Copy the template. http://goo.gl/Lpsl7
1a. Option B. Download a local copy if you are still absolutely addicted to Microsoft Excel.
1b. Option C. Fill out the data, check it and then just export the Text File to Create the Batch file for AD.

2. Add Your Users and OU Information for your Department and Users (KISS as a rule for AD Departments)

3. Modify =CONCATENATE if you are overly complex and super corporate, if not drop in your data under "AddActiveDirectoryBulkUsers" sheet.

4. Check the "BulkUsersSourceFile" to see that data is populated correctly.

5. Review the "ExportTextFile" script lines for accuracy (saves a headache later). Then export.

6. Option A: Create a .bat file from Notepad File you exported and then run this from Command Prompt.

7. Option B: Spartan Style! Copy and Paste right into PowerShell Window

8. Verify accounts on your Domain Controller (onsite or via RackspaceCloud Servers if your in the cloud)

Booyaaahhhh!!! Your done. Wasn't that fast and easy? And you didn't have to crack out your credit card or beg your manager to buy you some complicated program for Active Directory Imports.

Now, start setting up Google Apps Directory Sync for Google Apps for Work Implementation.

* There are multiple options to use for Production environments at scale. Group policy has a lot of flexibility also. Here are some good programs for AD Import and Export:

Level I (I can rock this out during lunch!)
Levels II (I can get through this in a day or two...or three)
Levels III (OMG It's Complicated! WHAT were they thinking when they released this??!)

Level I. ActiveDirectory Import - http://www.activedirectoryexport.com/ScreenShots.aspx
Level II. ManageEngine - AD Bulk Users (Their URL is too long, here's a link)
Level III. ScriptLogic - http://www.scriptlogic.com/products/activeadmin/

PluralSight Training: http://goo.gl/roo8Y

* Everything here is best advice and at your own risk so if you break something, please don't blame us. Have fun! ~MigrationKing
Share:

Wednesday, May 4, 2011

How to Install VMware Tools in Ubuntu 12.04LTS

This is a quick down and dirty on installing VMware tools in Ubuntu 12.04LTS on VMware ESX 5.1 Installation was conducted on a Virtual Machine to create a Ubuntu 12.04LTS Server template.

1. Download Ubuntu 12.04 LTS - http://www.ubuntu.com/download/server/download - 64-bit
2. Knowledge of mounting .ISO inside of Datastore on VMware vCenter 4.0+ is assumed.
3. Install Ubuntu 12.04LTS Server to your specifications for your template. I am using LVM + 512MB
4. sudo apt-get update && sudo apt-get upgrade
5. sudo mkdir /media/vmware
6. sudo mount /dev/cdrom /media/vmware
7. cp /media/vmware/VMware*tar.gz /tmp | cd /tmp
8. tar xzvf VMware*.gz
9. cd vmware-tools-distrib
10. sudo ./vmware-install.pl
11. Accept all defaults
12. sudo reboot and Enjoy....
Share: