SQL Admin: How to modify scheduled backup database maintenance plan

Issue:
How to modify scheduled backup database maintenance plan?

Resolution:
1. Connect to SQL 2005
2. under Management, expand Maintenance Plans
3. Right Click te Maint Plan
4. Click Modify

This will show you the Maintenance Plan Details/Properties

In the right side you will see the Maintenance Plan Tasks, where you can see the 'Maintenance Plan Tasks',
'Back up database Task' is one of the options where you can set the back up process of the database.

In the left side of the window, sub plans are listed. If you're back maintenance plan is already existing, select the Back Up database sub plan to modify it.

DotNet: How to register IIS

Issue:
How to register IIS?

Resolution:

1. Go to command prompt
   
2. Go to the framework folder location
3. Type 'aspnet_regiis –i'

Example:
c:\Windows\Microsoft.net\framework\v2.0.50727\aspnet_regiis –i

Virtual PC: Cannot install Virtual Machine Services error

Issue:
Cannot install Virtual Machine Services error

Resolution:
1. Installed VPC 2007 Sp1
2. Path to VMNetSrM.inf

Source:
http://www.relatedterms.com/ViewThread.aspx?t=133088

Windows: Cannot find 'Security tab'

Issue:
Cannot find 'Security tab'

Resolution:
If you want to see the Security tab, you need to tell Windows to show it to you. To do so, follow these steps:

1. Go to Windows Explorer
2. Click on the Tools menu and select Folder Options.
3. Click on the View tab and then scroll down to the bottom of the Advanced Settings portion of the Folder Options dialog box.
4. Clear the "Use Simple File Sharing" checkbox and click OK.

DotNet: ASP.NET v2.0.50727 missing from Web Services Extensions in IIS Manager

When you build Window 2003 R2 SP2 server – by default it has Microsoft.NET Framework 2.0 Service Pack 1 and Microsoft .NET Framework 3.0 Service Pack1 installed. You will notice ASP.NET v2.0.50727 is MIA(missing in action) in Web Services Extension in IIS manager. How you make it appear and make it as an “allowed” service?

The dumb way is to remove .NET Framework 3.0 SP1 and .NET Framework 2.0 SP1 then download the .NET Framework 2.0 and 3.0. After installing .NET Framework 2.0 the ASP.NET v2.0.40727 will show up. If needed, you can reinstall SP1 for both version which is quite boring process. Guess what, that’s what I did when I first notice the problem.

The smart way (which I am doing now!)is to start a DOS window – change to the following directory

C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727> or C:\WINDOWS\Microsoft.NET\Framework64\v2.0.50727> for 64 bit

Type aspnet_regiis.exe – i

ASP.NET will register itself and show up in Web Service Extensions!

Failed to access IIS metabase

Issue:
Failed to access IIS metabase

Resolution:

Go to the Command prompt and go to the following location: 2.0 framework folder
Exact Path: C:\Windows\Microsoft Net\Framework\v2.

1. reinstall IIS: aspnet_regiis -i
2. register windows account: aspnet_regiis -ga
   

SQL: SSIS Package Connection String Error during execution

Issue:
SSIS Package Connection String Error during execution

Other Symptoms:
When job with the package is executed, the job doesn't run successfully

Resolution:

• When you import the package, ensure to choose 'Rely on Storage Security'
• Import Package > Protection Level > 'Rely on Server Storage and access contol'

Sharepoint: Timestamp in Sharepoint (Workspace) Lists

Issue:
How to display timestamps when a list entry is edited in Sharepoint workspaces?

Resolution:
1. Select List Settings
2. Select Versioning Settings
3. Set Item Version History to Yes
4. Select the column where you would like to have the timestamp added and choose Yes to 'Append 5. Changes on Existing Text'

Source:
http://www.getsharepoint.com/blog/Lists/Posts/Post.aspx?ID=29