SQL: Truncating a SQL Database Log

Posted June 9, 2009 by ablogontech
Categories: Uncategorized

Tags: , , ,

Thanks to John McBride for helping me with this.

1. In SQL Management Studio, make sure you are connected to ‘master’ in the available databases drop-down box.

2. Click ‘New Query’ to open a query window.

3. Get the logfile name by:

     a. Right-click the database

     b. Select Properties

     c. Click Files

     d. Note the name of the log file.

4. Type the following in the query window:

          Use <YOUR_DB_NAME>
          Go
          backup log <YOUR_DB_NAME> with truncate_only
          go
          dbcc shrinkfile(<YOUR_DB_LOGFILE_NAME,1)
          go

5. Click the Execute button.

Advertisements

Citrix XenCenter Install and Configuration

Posted May 26, 2009 by ablogontech
Categories: Uncategorized

Tags: , , ,

The screen captures in this post outline the installation and basic configuration of Citrix XenCenter on Windows Vista. XenCenter is the GUI management utility for XenServer. XenCenter can be downloaded from Citrix’s website.

Launch the installation file you downloaded from Citrix’s website.

image

Click Next and select whether you need XenServer 4.0 Support. We did not need XenServer 4.0 support for this installation.

 image

Click Next and accept the default installation folder.

image

Click Install to begin the installation.

image

image

It is as simple as that! Click Finish to complete the installation.

image

Double-click the Desktop icon to start XenCenter.

image The splash screen will appear.

image

Tell XenCenter whether you’d like it to check for updates (We clicked Yes).

image

The XenCenter GUI will now display.

image

Click the ‘Add your XenServer’ icon to add your server to the list.

image

On the Add New Server window add the hostname, username and password.

image

Click Connect to connect and synchronize with your server.

image

Now you must activate your XenServer. Click the checkbox next to the server and click Activate.

image

Activating the XenServer will send you to the activation website where you must fill out the form in order to receive a new license.

You will receive a license file (license.xslic). From the XenCenter console, go to Server | Install License Key and navigate to the license.xslic file. Once the license is applied, it is displayed in the General tab of the server.

image

Citrix XenServer 5.0.0 Free Version: A Basic Install

Posted May 26, 2009 by ablogontech
Categories: Uncategorized

Tags: ,

Well, I’m a little late to the game but I guess better late than never. This post covers the basic installation of Citrix’s XenServer 5.0.0 Free Version. I apologize for the less than stellar screen captures. I had an old CRT connected to the server I used for the install. L I promise the next post covering the XenCenter Installation and Configuration will be MUCH nicer!

Prerequistes

If you don’t like reading the documentation before installing a product, the best piece of advice I can give is to ensure your server is capable of virtualization technology and it is enabled in the BIOS. I used an HP\Compaq Proliant DL365 with and AMD processor for this installation and as you can see in the picture below the virtualization option is buried under the Processor options.

image

If your server is not compatible with virtualization technology or the option is disabled, you will get the following message when attempting to install XenServer:

image

Once virtualization is enabled pop in the XenServer CD-ROM and let’s get started! The CD will boot to the Citrix XenServer installation splash screen and automatically boot to the installation program.

image

At this time you will have the option to install\upgrade XenServer Host, load a driver or convert the existing OS to a VM.

image

For this post we are installing XenServer from scratch so we’ll select the first option and then select the correct keymap.

image

WARNING!!! If you continue the install from this point, all data will be lost.

image

What would an installation be without an End User Licensing Agreement (EULA)?

image

Next, we’ll select the installation source and whether or not we are going to install the Linux Pack.

image image

Now, we will verify the installation source.

image image image

Let’s set a root password we can remember. 🙂

image

We must now configure the NIC, Hostname, DNS and Time settings.

image image

Time Zone

image image 

NTP

image image

Confirm and start the installation!

image image

Installation Complete!

image

Citrix XenServer Splash Screen: image

Citrix XenServer Console:

image

Checkout the Citrix website to learn more about Citrix XenServer. Come back soon for the next post covering the XenCenter installation and configuration plus better screen captures. 🙂

New Citrix Receiver for iPhone

Posted May 5, 2009 by ablogontech
Categories: Uncategorized

Tags: ,

The new Citrix Receiver for iPhone is now available via Apple’s App Store. Version 1.0 features Citrix Access Gateway compatiblity and some changes to the settings as shown below. One caveat: There is no upgrade path from version 0.9 to 1.0. It is a separate download from the App Store. However, it isn’t really a big deal. Just down load the new one, delete the old one and login!

New Account Settings 1.0New Citrix Setting Screen

 

 

 

 

 

 

 

 

 

 

If you opt to turn off the Sign In Automatically setting, the Account Settings (Login) screen will appear each time you open the Citrix Receiver for iPhone app.

Thanks to Brian Madden for his tweet that alerted me of the new download!

Part 2: Citrix Receiver for iPhone

Posted May 5, 2009 by ablogontech
Categories: Uncategorized

Tags: , , ,

Here’s some screen captures of the administration piece for the Citrix Receiver for iPhone.

iPhone SettingsCitrix Settings

 

 

 

 

 

 

 

 

 

 

Account Settings:

Account Settings

 

 

 

 

 

 

 

 

 

 

Keyboard Settings (4 Screen Captures):

Keyboard Settings 1Keyboard Settings 2

 

 

 

 

 

 

 

 

 

 

Keyboard Settings 3Keyboard Settings 4

 

 

 

 

 

 

 

 

 

 

What would an app be without an About screen?

About

Citrix Receiver for iPhone

Posted April 29, 2009 by ablogontech
Categories: Uncategorized

Tags: , , , , , ,

I downloaded and installed the Citrix Reciver for iPhone (aka Project Braeburn) the day after it was released and just now found the time to blog about it. I put together the following to give you an idea of what the Receiver looks like on the iPhone. It is pretty simple to download from Apple’s App Store and simple to configure. You will need to create a XenApp Services site in the Access Management Console.

citrix-access-console2

After the short download and installation, the Citrix icon will appear on your iPhone.

citrixicon1

When you start the application you will be prompted to enter your server address, username, password and domain name. There’s also an option for whether you want the app to remember your password. Once this is set the app will connect to your XenApp Services site and provide your XenApp client application folder structure.

pleasewaitfolders

 

 

 

 

 

 

 

 

 

 

For this test, we’ll select Adobe Reader.

applist1preparing1

 

 

 

 

 

 

 

 

 

 

 

adobe-running2

Pretty simple, huh? 

The following pciture shows how to use iPhone gestures with the Citrix Receiver for iPhone.

gestures

It is definately worth downloading and using. For more information, checkout the Citrix Comminity Blog.

vcbMounter Error: Backup snapshot already exists.

Posted March 6, 2009 by ablogontech
Categories: Uncategorized

Tags: , , , ,

Received this error [2009-03-06 09:34:26.750 ‘vcbMounter’ 7956 error] Error: Backup snapshot already exists when running a script to backup a VMware ESX virtual machine on the vcbProxy server. I following the post at NetworkAdminKB to delete the ‘_VCB-BACKUP_’ snapshot from the Snapshot Manager within the VMware Infrastructure Client. I had to restart the ‘VMware Virtual Mount Manager Extended’ service on the vcbProxy server as well.