Tag Archives: Windows

Ahsay restore Microsoft SQL (MSSQL) server database

If you want to restore a Microsoft SQL database, from a fuld backup, and put some transaction log file into it.  (This backup has backup by ahsay)

This is the why to do it:

  1. Start Microsoft SQL Server Management Studio
  2. Right click on Databases, and select restore database

  3. Type a database “To database”, and select from device , and press the butten with the 3 dots (…)

  4. Select file, and then click Add

  5. Select the database file you want to restore, and click ok

  6. Then select options, and click “Leave the database non-operational, and do not roll back uncommitted transactions. (Restore with NORECOVERY), then click OK
  7. Start a new query, and type this (Change it to yours database and files).
  8. RESTORE LOG RestoreTest
    FROM DISK = ‘F:\RestoreTest\2011-09-13(09-00-00)_LOG_RestoreTest_2011.bak’
    WITH NORECOVERYRESTORE LOG Farma_test
    FROM DISK = ‘F:\RestoreTest\2011-09-13(10-00-00)_LOG_RestoreTest_2011.bak’
    WITH NORECOVERY

    RESTORE LOG Farma_test
    FROM DISK = ‘F:\RestoreTest\2011-09-13(11-00-00)_LOG_RestoreTest_2011.bak’
    WITH NORECOVERY

    RESTORE LOG Farma_test
    FROM DISK = ‘F:\RestoreTest\2011-09-13(12-00-00)_RestoreTest_2011.bak’
    WITH NORECOVERY

  9. When you have takende the sekund last backup file, just type this:
  10. RESTORE LOG Farma_test
    FROM DISK = ‘F:\RestoreTest\2011-09-13(13-00-00)_RestoreTest_2011.bak’
    WITH RECOVERY

Microsoft Exchange 2010 – Ahsay restore to recovery mailbox database / storage group.

Ahsay have no support for native restore to Exchange recovery group, but here is a workaround of that problems.

First create a recovery storagegroup
New-MailboxDatabase -Recovery -Name RDB1 -Server exch2010 -EdbFilePath “F:\Backup\Restore\Data\rdb1.edb” -LogFolderPath “F:\Backup\Restore\Log”
Where RDB1 is the name of the Recovery database and Exch2010 is the name of the servere where recovery database should be located.

Restore the Exchange 2010 database to a alternative location in ahsay. With both logfiles and the database files, restore it to “F:\Backup\Restore\Data\Mailbox Database.edb” or where you location is.

Then run repair of the restored database.
Eseutil /p “F:\Backup\Restore\Data\Mailbox Database.edb”

Then mount the database
Mount-Database -Identity ‘Mailbox Database’

Example restore a mailbox to a Restore mailbox in the real database.
Restore-Mailbox -Identity ‘mailbox_to_restore_content_to’ -RecoveryDatabase RDB1 -RecoveryMailbox ‘Mailbox_Restore’ -TargetFolder Recovery

This will create a folder name Recovery under mailbox_to_restore_content_to, with the content of Mailbox_Restore

[PS] C:\Recovery20110909>Restore-Mailbox -Identity jvrestore -RecoveryDatabase RDB1 -RecoveryMailbox ‘Jesper Vernegaard’
-TargetFolder Recovery

TMG and Internet Explorer 9 – file:///C:/Program%20Files/Microsoft%20Forefront%20Threat%20Management%20Gateway/UI_HTMLs/Generic.htm?guid=

Hello

If you have Internet Explorer 9 and TMG / UAG installed on the same machine you need to apply this patch, else you will get:

file:///C:/Program%20Files/Microsoft%20Forefront%20Threat%20Management%20Gateway/UI_HTMLs/Generic.htm?guid=%7B1FC3773B-C941-450C-BA39-224904EFD093%7D

  1. * Open “C:\Program Files\Microsoft Forefront Threat Management Gateway\UI_HTMLs\TabsHandler\TabsHandler.htc”
  2. Search for the 3 lines which contain “paddingTop”, and remark-out each of them by adding “//” in the begining.
    Example: Change the line:
    m_aPages [niPage].m_tdMain.style.paddingTop = ((m_nBoostUp < 0) ? -m_nBoostUp : 0) ;
    into:
    // m_aPages [niPage].m_tdMain.style.paddingTop = ((m_nBoostUp < 0) ? -m_nBoostUp : 0) ;
  3. Save the file, and re-open TMG management console.

Microsoft Excel har fundet en fejl og afsluttes. Vi beklager ulejligheden ved afslutning af Excel

Nå du lukker et Excel ned, så kan den komme den og sige: Microsoft Excel har fundet en fejl og afsluttes.

Dette kan muligvis løses ved at gå ned i start og vælg kø, skriv her: regedit og tryk kør

Gå nu til HKEY_LOCAL_MACHINE\Software\Microsoft\Office\Excel\Addins

Her er det et punkt der hedder noget med bluetooth, gå ind under denne og sæt LoadBehavior key fra 3 til 0. Således at den nu står til 0 (Nul). Genstart så Excel og prøv at lukke programmet

Exchange 2007 – Ahsay restore to a recovery group

Ahsay have no support for native restore to Exchange recovery group, but here is a workaround of that problems.

First create a recovery storagegroup
new-storagegroup -LogFolderPath F:\Backup\Restore\Logs -Name ExchangeRestore -SystemFolderPath F:\Backup\Restore\Data -Recovery

Then create a empty database
new-mailboxdatabase -mailboxdatabasetorecover “Mailbox Database” -storagegroup ExchangeRestore -edbfilepath “F:\Backup\Restore\Data\Mailbox Database.edb”

Restore the Exchange 2007 database to a alternative location in ahsay. With both logfiles and the database files, restore it to “F:\Backup\Restore\Data\Mailbox Database.edb” or where you location is.

Then run repair of the restored database.
Eseutil /p “F:\Backup\Restore\Data\Mailbox Database.edb”

Then mount the database
Mount-Database -Identity ‘ExchangeRestore\Mailbox Database’

Example restore a mailbox to a Restore mailbox in the real database.
Restore-Mailbox -RSGMailbox ‘mailbox_to_restore’ -RSGDatabase ‘ExchangeRestore\Mailbox Database’ -id ‘Restore’ -TargetFolder ‘Restore’

Dismount the database
Dismount-database -Identity ‘ExchangeRestore\Mailbox Database’

Remove the database
Remove-MailboxDatabase -Identity ‘ExchangeRestore\Mailbox Database’

Remove the recovery group
Remove-StorageGroup -Identity ‘ExchangeRestore’

A significant number of invalid certificates have been provided by remote IP address 205.188.153.55 / 64.12.162.248

AOL has change there Root Certificate.
You can download them at https://pki-info.aol.com/AOL/

These 2 need to be imported in all Office Communication Server T – rusted Root Certification Authorities

You can see a video on howto import these 2 certificates here: http://simsbury.members.winisp.net/Update-AOL-Root-CA.wmv

There errors is belov

Multiple invalid incoming certificates.

In the past 1185 minutes the server received 12 invalid incoming certificates. The last one was from host 64.12.162.248.
Cause: This can happen if a remote server presents an invalid certificate due to an incorrect configuration or an attacker.
Resolution:
No action needed unless the number of failures is large. Contact the administrator of the host sending the invalid certificate and resolve this problem.

Over the past 0 minutes Office Communications Server has experienced TLS outgoing connection failures 1 time(s). The error code of the last failure is 0x80090325 (The certificate chain was issued by an authority that is not trusted.) while trying to connect to the host “sip.oscar.aol.com”.

Cause: Wrong principal error could happen if the peer presents a certificate whose subject name does not match the peer name. Certificate root not trusted error could happen if the peer certificate was issued by remote CA that is not trusted by the local machine.

In the past 0 minutes the server received 1 invalid incoming certificates. The last one was from host 64.12.162.248.

Cause: This can happen if a remote server presents an invalid certificate due to an incorrect configuration or an attacker.

Remote principal name is not configured in trusted server list.

After buying a CA sign certificate from Geotrust i got this in my Event viewer:

Remote principal name is not configured in trusted server list.

The subject name sip.XXX.com of the certificate assigned to process AVMCUSvc(1788) was not found in the trusted server list.
Certificate serial number: OU=Equifax Secure Certificate Authority, O=Equifax, C=US
Certificate issuer name: 0DA2A3.
Cause: Incorrect setup of the pool. Should never happen.
Resolution:
Verify that the Subject Name of the certificate presented by the remote peer is configured in the trusted server list.

For more information, see Help and Support Center at

I fix this problem by typing:

c:
cd \
cd “C:\Program Files\Microsoft Office Communications Server 2007 R2\ResKit”
cscript OCSTrustEntry.vbs /action:add /FQDN:sip.XXXX.com /type:TrustedServer

Sponsor link: http://www.it-århus.dk / http://www.it-aarhus.dk