Posts Tagged ‘ Move ’

Add a FILESTREAM feature to an existing SQL D/B

2017/05/07
By
Modified: 2017/04/30
SQL 2008 SP2 FILESTREAM Problem

SQL Server 2008 allows to store binary data, if Database has a FILESTREAM feature

Read more »


Windows 7 – How to Copy and Delete Massive System Directories

2017/04/17
By
Modified: 2017/03/03
2007-07-07

Problem: You have an old discarded instances of failed Windows 7 installs.  You can rename the directories, but they still clutter your hard drive, and they are very hard to get rid of. I simply can’t take this painful and slow process of deleting huge system directories under Windows 7.  Remember this endless stream of errors, and warnings, and skips.  The same task in Win XP only takes a few seconds.  But under Windows 7, it  is a project of its own.  Pain! Finally, my patience ran out.  I decided to write a script.  And it it worked!   Delete Windows System Directories Here is a fantastic way to delete huge Windows 7…

Read more »

Moving Old ASP Sites to 2008 Server, IIS 7, and SQL 2008

2017/04/13
By
Modified: 2017/03/03
Moving Old ASP Sites to 2008 Server, IIS 7, and SQL 2008

It was time to move many sites from W2K3 Server (Windows 2003 Server) and SQL 2000 Server to a new W2K8 Server (Windows 2008 Server) and SQL 2008 Server.  And if I ever have to do it again, I will check with these notes. The greatest secret in technical life (and may be wider) is to change before you have to.  Anticipate and change before circumstances force you.  For a long time I was planning this migration, but I didn’t expect to go through so many hurdles and error messages.  Luckily, I found solutions that seem logical and clean.  So, let’s go into step-by-step details. COPY DATABASE AND SITES – Backup…

Read more »

Move IIS inetpub Directory

2017/04/11
By
Modified: 2017/03/03
Move IIS inetpub Directory

To keep your operating system completely separate from all the web stuff, it is advisable to move inetpub directory off the root of a %SystemDrive% to a completly different drive. In these sample I am moving IIS from C:\inetpub to x:\inetpub.   Adjust this to your needs. Steps described here were tested on Windows 7 IIS 7.5 and Windows 2008 Server R2 IIS 7.5. Check if your http://localhost/ is working before proceeding.   -01- Stop all IIS-related services Stop services related to IIS: – FTP (if installed) – IIS Admin – SMTP (if installed) – Windows Process Activation (will stop all other IIS services) – WWW (will be stopped by stopping previous…

Read more »

How to Work with MySQL – Basic Tasks

2017/03/16
By
Modified: 2017/03/03
How to Work with MySQL – Basic Tasks

This material is tested with MySQL 5.1 and 5.5 on various Windows versions. This article covers these topics: -010- MySQL Data Location -020- Shortcut to MySQL Command Shell -030- Create a New Database -035- Delete an Existing Database -040- Display a List of All DB Users -050- Display a List of All Tables -060- List All Fields in a Table -070- Free ODBC Connector is Available -080- Create a New User -085- Change User Password -090- Delete a User -100- Grant User Rights to a D/B and Show It -110- Save Database into a Dump File -120- Restore Database From a Dump File -130- Rename Database -140- Backup Database -150- Automate…

Read more »

How to Install WordPress 4.X on Windows 10 and IIS 7.5

2017/03/10
By
Modified: 2017/03/03
Pick-IIS-FastCGI-Option

This article is written for those who need to test/evaluate features of new WordPress release on a local machine before rolling it out to all the serves. This article describes running PHP on IIS 7.5 through FastCGI. For best results, reader is required to be able to start and stop services, understand registry manipulations, be comfortable with copy and paste inside a command prompt (Alt+Space, E, P). To achieve better portability, try to match your test machine directory structure as close as possible with your server. Other IIS Features to Pick If you are planning to test old ASP sites on the same machine, you also need to pick: - ASP…

Read more »