Monthly Archives: August 2009

Add Shutdown Button in Windows Vista

Dear All

Please go through the video tutorial which shows how to add Shutdown button in Windows Vista

Show the Demo

Thanks

Prashant Deshpande

Advertisements

Leave a comment

Filed under IT Support, Operating System

Taking backup of Database on Remote System for hourly basis

Dear All

Default SQL server will not allow to take backup on remote system but now We can schedule SQL Server database backup on Hourly Basis by following SQL scripts

Follwoing script can be used to schedule Full database backup on remote system on daily basis

‘******************************************************************

Need to change Ip of remote system and Database name

‘*****************************************************************

declare @day_week int,@directory char(80)
set @day_week = datepart(dw,getdate())
if @day_week = 1
begin
set @directory = ‘\\10.24.230.182\Full\day1\db_Full.bak’
end
else if @day_week = 2
begin
set @directory = ‘\\10.24.230.182\Full\day2\db_Full.bak’
end
else if @day_week = 3
begin
set @directory = ‘\\10.24.230.182\Full\day3\db_Full.bak’
end
else if @day_week = 4
begin
set @directory = ‘\\10.24.230.182\Full\day4\db_Full.bak’
end
else if @day_week = 5
begin
set @directory = ‘\\10.24.230.182\Full\day5\db_Full.bak’
end
else if @day_week = 6
begin
set @directory = ‘\\10.24.230.182\Full\day6\db_Full.bak’
end
else if @day_week = 7
begin
set @directory = ‘\\10.24.230.182\Full\day7\db_Full.bak’
end
BACKUP DATABASE [JRADM] TO DISK = @directory WITH INIT , NOUNLOAD , NAME = N’db_Full’, SKIP , STATS = 10,  NOFORMAT

‘*****************************************************************

Follwoing SQL script can be used to schedule teh hourly Differencial backup of database in sepated folders.

‘*******************************************************************

Need to change Ip of remote system and Database name

‘*******************************************************************

declare @day_week int,@directory char(80),@tt int
set @day_week = datepart(dw,getdate())
set @tt = datepart(hh,getdate())
if @day_week = 1
begin
set @directory = ‘\\10.24.230.182\Diff\day1\’+convert(varchar(2),@tt) +’\db_1stdiff.bak’
end
else if @day_week = 2
begin
set @directory = ‘\\10.24.230.182\Diff\day2\’+convert(varchar(2),@tt) +’\db_1stdiff.bak’
end
else if @day_week = 3
begin
set @directory = ‘\\10.24.230.182\Diff\day3\’+convert(varchar(2),@tt) +’\db_1stdiff.bak’
end
else if @day_week = 4
begin
set @directory = ‘\\10.24.230.182\Diff\day4\’+convert(varchar(2),@tt) +’\db_1stdiff.bak’
end
else if @day_week = 5
begin
set @directory = ‘\\10.24.230.182\Diff\day5\’+convert(varchar(2),@tt) +’\db_1stdiff.bak’
end
else if @day_week = 6
begin
set @directory = ‘\\10.24.230.182\Diff\day6\’+convert(varchar(2),@tt) +’\db_1stdiff.bak’
end
else if @day_week = 7
begin
set @directory = ‘\\10.24.230.182\Diff\day7\’+convert(varchar(2),@tt) +’\db_1stdiff.bak’
end
BACKUP DATABASE [JRADM] TO DISK = @directory WITH INIT , NOUNLOAD , DIFFERENTIAL , NAME = N’db_diff’, SKIP , STATS = 10, DESCRIPTION = N’db differential backup’, NOFORMAT

‘***************************************************************

and please download follwoing Folder structure and pate on the remote system and share it

Then Schedule the SQl job in Enterprise Manager of SQL Server 2000 on hourly basis and daily as per the Scripts.


You can see the Video Tutorial for Practical Demonstration

Feel free to ask any kind of doubt

Thanks

Prashant Deshpande

Leave a comment

Filed under SQL Server

How to Uninstall Corrupted WSUS

Dear All

This Document explains how to Uninstall WSUS server if currupted.

1. Download the SDK to obtain MSIZAP

 From windows 2003 server SUPPORT TOOLS

2. From a command prompt, type:
C:\Program Files\Support Tools> MSIZAP T {2C0D7E35-EE6E-4DC7-BA13-2C68AEDEB59D}

3. From a command prompt, type: sc delete wsusservice

4. Again, From a command prompt, type:

    MSIZAP T {2C0D7E35-EE6E-4DC7-BA13-2C68AEDEB59D}

5. From a command prompt, type: iisreset

6.  Run regedit, delete this key:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Update Services\Server\Setup

7 Delete the installation directory:
C:\Program Files\Update Services

8 Open IIS manager?delete all WSUS related virtual directory:

ApiRemoting30
ClientWebService
Content
DssAuthWebService
Inventory
ReportingWebService
Selfupdate
ServerSyncWebService
SimpleAuthWebService

9.Using the following command to delete windows internal database

msiexec /x {CEB5780F-1A70-44A9-850F-DE6C4F6AA8FB} callerid=ocsetup.exe

10 Now Install WSUS

 

Thanks

Prashant  Deshpande

Leave a comment

Filed under WSUS

Disable Restart Popup and Auto Restart on Servers

The Windows Automatic Updates feature is great, however those nagging reboot reminders can drive you crazy. I can only recommend to turn this off.

Usually, this restart now/restart later pop up appears when I am doing something important or when I have some remote connections open. In my view this feature doesn

Leave a comment

Filed under General

Defragmenting Your Pagefile

Dear All

Please find the Detailed Procedure for Decrementing PageFile

 Procedure 1

Defragmenting your hard drive regularly is an important part of general system maintenance for Windows  2003 Server  machines, and the Disk Defragmenter tool in Computer Management lets you do this easily. (You can also get to the Disk Defragmenter tool by choosing Control Panel–>Performance and Maintenance–>Rearrange items on your hard disk to make programs run faster.) But what about defragmenting your pagefile? Windows dynamically resizes your pagefile as needed to ensure there is sufficient virtual memory to meet the needs of running applications, and as a result of this resizing, it is possible that your pagefile can become fragmented over time, which can slow performance of your machine. Unfortunately, the Disk Defragmenter tool doesn’t defragment the pagefile, and you might be tempted to buy a third-party disk defragmenter to do this. However, you can save your bucks by following this simple procedure to defragment your pagefile. First, here’s a look at the fragmentation of the C: drive on my Windows 2003 Server machine just before I defragmented it:

After running Disk Defragmenter, the fragmentation of this drive is much reduced:

 


Let’s look at the report generated by Disk Defragmenter to see the condition of the pagefile:
 

 Because of the way Windows 2003 Server  manages the pagefile swapping large blocks of data, the pagefile usually doesn’t become very fragmented, even on heavily used machines. It can become defragmented enough, though, to affect system performance. To defragment the pagefile, we first have to remove the pagefile, then defragment the machine, and finally recreate the pagefile. To do this, start by opening the System utility in Control Panel. (You may have to get there by clicking Performance and Maintenance from the Control Panel and then clicking System.) Then select the Advanced tab, click the Settings button under Performance, select the Advanced tab of Performance Options, and click Change to view your Virtual

Memory settings:
Now select the No Paging File option and click Set. This will disable paging entirely and should also remove the pagefile (pagefile.sys) from the hard drive the next time you reboot your system. (If it doesn’t do this, you can delete this file manually after rebooting. It’s normally found in C:\.)
Reboot your machine, and when Windows comes up, use Disk Defragmenter to defragment the volume where your pagefile was previously (C: drive in my example). Once your system is defragmented, open the Virtual Memory box again, and change the pagefile back to System Managed Size. Then, reboot your machine again. This time, when you run Disk Defragmenter, it should say your pagefile has only one fragment. When I ran Disk Defragmenter on my machine after performing these steps, the result was this:
Note that the pagefile (green area) has been moved to the end of the volume (an added bonus to reduce future file fragmentation). Also, as expected, the report generated by Disk Defragmenter indicates there is now no fragmentation of the pagefile:

 

Leave a comment

Filed under Operating System

SSL Certificate Signing Request

Dear All

Please go through the follwoing Video whcih shows the creation of CSR file and Check the contents of CSR file, It is SSL Certificate Signing Request

Click to Download

Thanks

Prashant Deshpande

Leave a comment

Filed under IIS