Posts Tagged ‘SQL’

Posted by IsaacBlum at 17 February 2010

Category: Business, For The Greater Good, Microsoft

Tags: , ,

This has been out for a while now. I really hadn’t needed to use this, however I used it a handful of times this week, and i do love it!!

http://blogs.msdn.com/webplatform/

http://www.microsoft.com/Web/

This walk through can be used when creating a windows AMI.

  

Installed Software:

  • SQL 2005 Express
  • Indexer Service
  • .net 2.0 SP1
  • .net 3.5 SP1

Server Purpose:

  • .net 2.0 web application w/ database

Instance Configuration:

  • One attached volume 22gb in size. I recommend using drive letter Z: if you can. So that if you attach the volume later to another windows image you don’t accidently take a required drive letter. (normal system admin advice)

 

Step 1: Detach your web application’s databases

 

Step 2: Turn off SQL Services.

 

Step 3: Turn off the Indexing Service.

 

Step 4: Turn Off IIS

 

Step 5: Turn off anything else that may be accessing the hard drive and all programs Ex: antivirus software or internet explorer.

 

Step 6: Download and Install http://download.sysinternals.com/Files/SDelete.zip , *(delete anything that you do not want to be part of the instance now. Then empty the recycle bin.)  Then run this command : delete -c %%Your Hard Drive letter%%, repeat this for all hard drives attached to your instance.

 

Step 7: Bundle the image…. You can use this link http://docs.amazonwebservices.com/AWSEC2/latest/DeveloperGuide/index.html?bundling-an-ami-windows.html which caused me more trouble than it was worth or use http://developer.amazonwebservices.com/connect/entry.jspa?externalID=609 (preferred) I used this software to make the process go a lot faster. You can just right click the instance and start bundling the instance.

 

****BE Patient*****  BE Patient ******* BE Patient***** this process can take up to an hour or more to complete. **** BE Patient******* you can check the output window for more information.

 

Once complete, Register your instance. And your off. Don’t forget that your instance will need its database reattached and etc…

 

*note not following these guidelines can/will cause corruption to database and or files on these hard drives.

 

Please throw me a comment if you need help. Thanks

  • Archives

  • Tags

  • Subscribe
  • Pages

  • More

  • Disclaimer…

    This is my personal weblog. The opinions expressed herein are my own and are not representative of any 3rd party influence. The owner of this blog reserves the right to edit or delete any comments submitted to this blog without notice if they are deemed to be spam, offensive or otherwise inappropriate. The owner of this blog makes no representations as to the accuracy or completeness of any information on this site or found by following any link on this site. The owner will not be liable for any errors or omissions in this information nor for the availability of this information. The owner will not be liable for any losses, injuries, or damages from the display or use of this information.


    Lastly, I do my best to document my sources if the article is not of my own creation. If I have missed or forgotten to source your work. I would love feedback via the comments section. Thank you.

DreamHost promos
SiteLock