Monthly Archives: October 2009

Attach Database in SQL Server 2005 with MDF file only

Dear All

Today there was a issue of attaching a database in SQL server 2005
because there was only MDF file was available and no LDF file was there
so if we try to attach the database from GUI interface ( Management Studio )
it won’t allow to add the database and gives errors, so I have executed the system stored procedure to do the task

sp_attach_single_file_db @dbname= ‘databasename’, @physname= ‘C:\Databases\databasefile.mdf’

after executing this command it will show following message

” File activation failure. The physical file name “C:\Program Files\Microsoft SQL Server\MSSQL\Data\databasefile_log.ldf” may be incorrect.

New log file ‘C:\Databases\databasefile_log.LDF’ was created.”

And the Database is successfully attached

 

Thanks

Prashant Deshpande

Advertisements

Leave a comment

Filed under Database Server, SQL Server, Uncategorized

IIS 7.0

Dear All

please download and read the information about IIS 7.0

download the document

Thanks

Prashant Deshpande

Leave a comment

Filed under IIS, Web/Application Server

Create a new Domain Controller with the same domain

Dear All

Please downlaod and read the attached document whcih shows how to create a new Domain Controller with the same domain in existing forest.

I have used this technique when my Domain controller is crashed with all FSMO roles.

Download the document

Thanks
Prashant Deshpande

Leave a comment

Filed under Active Directory, Operating System, Uncategorized

IIS performance tuning

Dear All

Please check the following tutorial which shows the IIS performance tuning

Take IIS backup before Implementing these technologies

View the tutorial

Thanks

Prashant Deshpande

Leave a comment

Filed under IIS, Uncategorized, Web/Application Server

IIS monitoring Scripts

Dear All

please download teh scripts and follow the steps to configure IIS monitoring, application pool monitoring

Steps

1) Install 7-zip on Web server
2) Add in path variable c:\program files\7-zip
3) upload :- IIS_config.rar file on server and extract it on e:\server_mon
4) create a folder on c:\apppoollog
5) schedule task for apppoolmon.vbs after each 3 mins
6) do the email_to filed changes in pingvirtualdirectory.vbs and pingsite.vbs
7) schedule task for pingvirtualdirectory.vbs after each 3 mins
8) schedule task for pingsite.vbs after each 3 mins
9) to configure GZIP and other settings of IIS by looking the videos
10)Web garden ( if required) by looking the videos
11) upload diskspace.vbs file and schedule task after each 1 hour.

Dowload scripts

Thanks

Prashant Deshpande

Leave a comment

Filed under IIS, Uncategorized, Web/Application Server

Performance tuning on Application pool in IIS

Dear All

Please check the tutorial which shows about performance tuning on Application pool in IIS

View the Tutorial

Thanks

Prashant Deshpande

Leave a comment

Filed under IIS, Uncategorized, Web/Application Server

Configure WDS

Dear All

Please see the attached document which gives procedure how to configure WDS and deploy Windows XP image

Downlaod Document

Thanks

Prashant Deshpande

Leave a comment

Filed under Operating System, Uncategorized