Posts Tagged ‘ Backup ’

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

2017/11/13
By
Modified: 2017/11/12
IIS75-ASP-is-not-Installed

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 »


Automate Database Backup with SQL Express

2017/10/02
By
Modified: 2017/09/16
Automate Database Backup with SQL Express

This article describes, how to automate database backup in SQL Express with mixed Windows and SQL Authentication running on Windows 2008 Server.   This material was tested with Microsoft SQL Server 2008 R2 Express. SQL Server 2008 Enterprise comes with Maintenance Plan feature.  That feature allows amazing flexibility and auditing.  SQL Express edition lacks this feature.  But you still need a backup. Backup automation with SQL Express consist of 3 steps: (1) Write the script to backup all your databases. (2) Test the script by initiating it from a command prompt. (3) Schedule the script using Task Scheduler. Here is each step in detail. ` (1) Write the Script This script overwrites…

Read more »

How to Work with MySQL – Basic Tasks

2017/09/16
By
Modified: 2017/09/10
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 »

Error 2155348315 in Windows 7 Backup – Resolved

2017/09/10
By
Modified: 2017/07/22
Windows 7 Backup Error 2155348315

I started getting this error 2155348315 in Windows 7 Backup, when I switched from wired to a Wi-Fi connection on my desktop PC. Here is what happened...

Read more »

Restore iPhone from an Old Backup (PC)

2010/07/03
By
Modified: 2010/08/09

If you have iPhone backup on an old PC, or old prallel install of other (or even non-functioning) operating system, you still can restore your iPhone through iTunes. Copy a long number directories from old installation to a new one.  For example copy a directory   from …Old User Directory\AppData\Roaming\Apple Computer\MobileSync\Backup to %UserProfile%\AppData\Roaming\Apple Computer\MobileSync\Backup It appears that your applictions are not part of the backup.  Also, I don see any music files to be restored.  However, even your last search in Google maps is restored and saved.

Read more »