Archive for July, 2009

Restore SQL Server 2005 backup file (*.bak)

Wednesday, July 29th, 2009

This tutorial is intended for restoring backup in Microsoft SQL Server 2005 by using Microsoft SQL Server Management Studio Express. Some of you might have tried tweaking around using the GUI of SQL Server Management Studio to restore the backup file. Most of junior developer will face this error:

Error 3154: The backup set holds a backup of a database other than the existing database.

Ok, let’s get into our business. First of all get the backup file (*.bak) and the tool (Microsoft SQL Server Management Studio Express) ready.

You should create the database (with the same file name *.mdf & *.ldf) which has the same name to your backup file.
The easiest way to do this, is try to open your backup file and figure out what is the database name, database file name ( ???.MDF), and log file name (???.LDF).  On your Object Explorer right click the “Databases”, choose “Restore Database”,  select “From Device”, and browse your *.bak file.

Once you get that, create new database with the same Database name and  change the Logical name accordingly.

Once the database has been setup run the following query:

RESTORE DATABASE YOUR_DATABASE_NAME
FROM DISK = ‘C:\PATH_TO_YOUR_BACKUP\YOUR_BACKUP_FILE.bak
WITH REPLACE

Dreamweaver error: while executing onLoad in RecordsetFind.htm, the following JavaScript error(s)

Thursday, July 16th, 2009

Are you getting the following errors message when using Dreamweaver CS4? (Note that it may happen to Dreamweaver Professional 8 and CS3 as well).

The following translators were not loaded due to errors:
_________.htm: has configuration information that is invalid.
….

In my case it also generate the following error message when you start and close dreamweaver.

while executing onLoad in RecordsetFind.htm, the following JavaScript error(s) occured:
In file “RecordsetFind”:
findRs is not defined

While executing onLoad in TeamAdminTempDelete.html, the following JavaScript error(s) occured:
In file “TeamAdminTempDelete”:
delTempFile is not defined

It turns out that there is something wrong with your Dreamweaver configuration files. It may be caused by file corrupt, or changes in your system.

To solve this you will have to remove the current configuration folders, so that Dreamweaver will generate new one for you. To do that, close your Dreamweaver and go to the following folder:

C:\Documents and Settings\YOUR_WINDOWS_USERNAME\Application Data\Adobe\Dreamweaver CS4\en_US

Rename the “Configuration” folder in to “Configuration-old”, and then fire up your Dreamweaver.

It should generate the new Configuration folder. Now you might loose your last configuration such as the sidebar width, last used view, etc.