Tip

SQL Server .VHD trial editions that impress

Most SQL Server administrators are familiar with the trial editions of SQL Server. These are fully-functional editions of SQL Server that are time-limited — they'll run for a certain amount of time (usually 120 days) before expiring. You can then, in turn, upgrade to the full version of SQL Server with a proper license key or by remounting the databases in a full edition of SQL Server.

The introduction of virtualization in Windows, through products like Virtual PC and Virtual Server, has made it possible to create trial versions of products. These trial versions don't require actual installation on a given computer in order to try them out. Instead, they are standalone virtual machines — a whole operating system installation with the trial product installed on them. They're distributed in Microsoft's

    Requires Free Membership to View

Virtual Hard Drive or .VHD format; the user downloads a self-extracting file that unpacks the .VHD. Then a user can run it in Virtual PC or Virtual Server. When the trial period expires, or the user no longer needs the program, the .VHD file can simply be deleted; nothing needs to be uninstalled.

The SQL Server 2005 Enterprise Edition VHD is a trial edition of SQL Server in a VHD format. It contains a

More on installations:

 full operating system and a fully-functional copy of SQL Server 2005 Enterprise Edition. You can attach it to a network and it will run exactly like SQL Server itself and can host real-world databases as well. The only limitation placed on the virtual machine is a time constraint; the product expires after 30 days. However, any databases created or modified with the virtual machine can be re-hosted in a full copy of SQL Server.

In order to run the VHD, you'll need Virtual Server 2005 R2 (which is itself free) running on Windows Server 2003. The virtual machine will need at least 10 GB of disk space and 512 MB of memory to run well. Also note that since this is a trial edition of a product, there is no technical support offered by Microsoft.

ABOUT THE AUTHOR
Serdar Yegulalp is editor of the Windows Power Users Newsletter. Check it out for the latest advice and musings on the world of Windows network administrators -- and please share your thoughts as well!
Copyright 2007 TechTarget

This was first published in February 2007

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

Disclaimer: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.