How to repair Microsoft SQL database

Hi!!

Today we will show how to repair corrupted MS SQL database.

In MS SQL Studio run new query:

1. dbcc checkdb(‘DB-NAME’) with no_infomsgs

DB-NAME is a name of your corrupted database. If this is completed without any errors then the database does not need to be repaired.

2. Alter database DB-NAME set SINGLE_USER

Before we begin repairing the database, the database must be set in single user mode.

3. dbcc checkdb(‘DB-NAME’,REPAIR_REBUILD)

There are number of repair model usually we use first REPAIR_REBUILD. When everything is ok go to step 5.e (multi user mode) If not, go to next step.

4. dbcc checkdb(‘DB-NAME’,REPAIR_ALLOW_DATA_LOSS)

This command may cause data loss. When everything is ok go to step 5.e (multi user mode) If not, go to next step.

5.

a. ALTER DATABASE DB-NAME SET EMERGENCY
b. ALTER DATABASE DB-NAME SET SINGLE_USER
c. DBCC CHECKDB (DB-NAME, REPAIR_ALLOW_DATA_LOSS) WITH NO_INFOMSGS, ALL_ERRORMSGS
d. ALTER DATABASE DB-NAME SET ONLINE
e. ALTER database DB-NAME set MULTI_USER

Description:
a. Set database to emergency mode
b. Set database to single user mode
c. Check database and repair with allow data loss
d. Back database to online mode from emergency mode
e. Set database to multi user mode for normal use

Best regards

Miroslav Hlavaty

Restore Windows 2008 Server from network share on VMware virtual machine

Hello

Today we show how to make windows 2008 restore in recovery mode from a network share on the virtual machine runs on VMware. Assuming that we use E1000 network card windows does not set the IP address. Run the command line:

1. C:\Users\Administrator>wpeinit   (This command load network driver for our E1000)

2. C:\Users\Administrator> netsh interface ipv4 show interfaces (This command show interfaces)

Example:

Idx  Met   MTU   State        Name
—  —  —–  ———–  ——————-
1   50 4294967295  connected    Loopback Pseudo-Interface 1
10   20   1500  connected    Local Area Connection

3. C:\Users\Administrator>netsh interface ipv4 set address name=”Local Area Connection” source=static address=192.168.1.11 mask=255.255.255.0 gateway=192.168.1.1  (This command add IP address to interface Local Area Connecion)

After that procedure now we can access to network share.

Best regards

Miro

Configure Receive Connectors to drop messages where the “FROM” address is from your own authoritative domain

Hello

Today we show you how to change the transport rules for internet facing Hub Transport server in Exchange 2007/2010.
The problem arises that the attacker can fake address “from” and to use your authoritative domain.
We use MS Exchnage powershell:

Remove-ADPermission <ReceiveConnector Name> –user “NT AUTHORITY\Anonymous Logon” –ExtendedRights ms-Exch-SMTP-Accept-Authoritative-Domain-Sender

<ReceiveConnector Name> is name of receive connector interfacing to internet.

When you use internal devices such as scanners, printers etc… create new connector with annonymous permissions on other port then internet facing receive connector.

Information from website www.exchangepedia.com

Best Regards

Miroslav Hlavatý

Cannot connect to Exchange 2010 sp1 powershell console

Hi

Today I wanted through the exchange powershell console to adjust some exchange attributes. Powershell  displays a message that I have ever seen:

The systemload quota of 1000 requests per 2 seconds has been exceeded. Send future request at a slower rate or raise the systemquota. The next request from this user will not be for at least approve 1522693632 milliseconds.

What exchange need from me? What is this?

I read some forums but everyone write restart IIS server (iisreset /noforce) and that is not my style.

Finest solution is recycle this app poll (“MSExchangePowerShellAppPool”) from IIS Manager.

Miroslav Hlavatý

Replacing a faulty disk in LINUX SW RAID 5

Hi

Today we will see how to replace the failed drive in Linux software RAID 5.

1. Set fail state of faulty disk witch is in my demostration sdb1 (If is disk in other array’s set fail state in this array’s)
#mdadm –manage /dev/md0 –fail /dev/sdb1

2. Remove faulty disk from array (If is disk in other array’s remove it  in this array’s).
#mdadm –manage /dev/md0 -r /dev/sdb

3. Shutdown machine and remove faulty harddisk. This disk you find by serial number.
#lshw

4. Copy file system from production disk to new harddisk.
#sfdisk -d /dev/sda | sfdisk /dev/sdb
If this command doesn’t work use switch –force at the end of command (sfdisk -d /dev/sda | sfdisk /dev/sdb –force).

5. Add new disk to array or array’s
#mdadm –manage /dev/md0 -a /dev/sdb1

6. Then mdadm rebuild array device. You can see rebuild process when you type:
#cat /proc/mdadm

Have a nice day

Miroslav Hlavatý

How to reconfigure VMware HA cluster after first node fail.

Today we will show how to restore the HA cluster in VMware vCenter.
HA cluster works great and recovers cluster after the collapse of any cluster node, but if the first node in the cluster fails there is a problem.

After you restor the first node and try to start HA Cluster reconfiguration of cluster services gives an error that it can not be added to an existing cluster. Because it is the first node in the cluster you cannot do anything other than:

a. Right click on the cluster where all teh other nodes are
b. Edit Settings
c. Turn off HA, clear Turn On VMware checkbox option
d. Wait till HA is deconfigured from all ESX(i) hosts
e. Right click on the cluster
f. Edit Settings
g. Turn on VMware HA

After the reconfiguration the cluster is again in full deployment

Miroslav Hlavatý

How to change recipient quota policy on Exchange 2010 Hosted Mode

Hellou

Today we take a look on problem with Exchnage 2010 in Hosted Mode.

Today I tried to change the service plan in Tenant organizations and increase the number of allowed mailboxes. The first attempt was Serviceplan update and increase the mailbox quota count.
But it did not work in this direction.

Example:

# Update service plan (config only)
Update-ServicePlan –Identity orgname –ConfigOnly
# Upgrade service plan for tenant org
start-organizationupgrade orgname
# Complete upgrade
complete-organizationupgrade orgname

Following a detailed study of technet I found a wonderful command:

Example:

# Display quotas
Get-RecipientEnforcementProvisioningPolicy -Organization OrganizationName | fl

# The increase in a quota mailboxes (6 mailboxes in org)
Set-RecipientEnforcementProvisioningPolicy -Identity “OrganizationName\Recipient Quota Policy” -MailboxCountQuota 6

!!!! Dont forget there is another policy !!!!!!

#Increase user quota
Set-RecipientEnforcementProvisioningPolicy -Identity “OrganizationName\Recipient Quota Policy” -MailUserCountQuota 6

I hope this blog will help you solve some configuration changes.

Best regards

Miroslav Hlavatý