SQL Server .VHD trial editions that impress

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 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: Guide: Installing a SQL Server instance Migrate to SQL Server 2005 with the Copy Database Wizard

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

Rate this Tip To rate tips, you must be a member of SearchSQLServer.com. Register now to start rating these tips. Log in if you are already a member. Digg This!     StumbleUpon     Del.icio.us    RELATED CONTENT Microsoft SQL Server Installation SQL Server Mailbag: CALs, witnesses and unwanted changes SQL Server Mailbag: Migrating down to Standard Edition What's new for installation with SQL Server 2008? Creating fault-tolerant SQL Server installations SQL Server consolidation: Why it's an optimization technique SSIS error message due to installation problem on SQL Server 2005 Get SQL Server log shipping functionality without Enterprise Edition Tutorial: Migrating to SANs from local SQL Server disk storage SQL Server tools don't appear in menu after SQL Server 2005 install Troubleshoot SQL Server 2005 SP2 installation error Microsoft SQL Server Installation Research Database Management and Administration Password cracking tools for SQL Server Using traces in SQL Server Profiler Meet compliance requirements with improved database security practices Hardening the network and OS for SQL Server security Securing the server and database in SQL Server How SQL Server 2008 components impact SharePoint implementations Troubleshooting Distributed Transaction Coordinator errors in SQL Server Achieving high availability and disaster recovery with SharePoint databases Clearing the Windows page file and its effect on server performance Deploying a SQL Server virtual appliance for Microsoft Hyper-V RELATED RESOURCES 2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems Search Bitpipe.com for the latest white papers and business webcasts Whatis.com, the online computer dictionary 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.