Sunday, April 12, 2009

How to set Write/Read permissions on the folder of a website


To set Write/read permissions on the folder of a website right click on the folder on which you want to set the permissions , click properties , select the security tab , select the users to which you need to set write/read modify permissions , check the check box read and execute , write , modify and click ok .

Regards,

Prashant. J.

Saturday, April 11, 2009

How to restore a MSSQL 2005 database.

To restore MSSQL 2005 Database from a backup file say data.bak which you have backed up from a database , first place the backup file in the following location
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup .

Then login to the MSSQL management studio using windows authentication or SQL server authentication , Expand databases in the left pane , Right click on the database which you want to restore ==> tasks ==>Restore ==>database

Then select the "from device" option and browse the path where you have copied the database backup file data.bak which is C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\data.bak

Check the restore check box and click options . From the restore options select overwrite the existing database option and provide the correct path for the .mdf and .ldf files say C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\data.mdf and C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\data_log.ldf .

Click ok to restore the database and you will get a message that the restore of the database was completed successfully .


Regards,

Prashant .J.