If you want to take a backup from Microsoft SQL Server management Studio, and get this error: Operating system error 5(error not found), then the problems is that the user running SQL Server services dosen’t have access to the destanation folder of you backup.
Tag Archives: Microsoft
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:
- Start Microsoft SQL Server Management Studio
- Right click on Databases, and select restore database

Type a database “To database”, and select from device , and press the butten with the 3 dots (…)
Select file, and then click Add
Select the database file you want to restore, and click ok
Then select options, and click “Leave the database non-operational, and do not roll back uncommitted transactions. (Restore with NORECOVERY), then click OK- Start a new query, and type this (Change it to yours database and files).
- 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 NORECOVERYRESTORE LOG Farma_test
FROM DISK = ‘F:\RestoreTest\2011-09-13(11-00-00)_LOG_RestoreTest_2011.bak’
WITH NORECOVERYRESTORE LOG Farma_test
FROM DISK = ‘F:\RestoreTest\2011-09-13(12-00-00)_RestoreTest_2011.bak’
WITH NORECOVERY - When you have takende the sekund last backup file, just type this:
- 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
Microsoft C5 åbner og lukker med det samme igen
Hvis du har problemer med at C5 2010 bare lukker med det samme nå du åbner det, så skyldtes det sikkert at der i ini filen er en linie med -usupervisor
Slet denne linie
Exchange Room Mailbox automatic deletes calendar appointments
If you have created a room mailbox, and want to create appointments directly in the calendar of the room mailbox, then you need to:
- Enable the user in Active Directory
- Set the password of the user
- Log on to a workstation with that user
- Start Outlook
- On the Tools menu, click Options, and then click Calendar Options.
- Under Advanced options, click Resource Scheduling.
- Select the Automatically accept meeting requests and process cancellations check box.
- You can then select the following options:
- Automatically decline conflicting meeting requests
- Automatically decline recurring meeting requests
Then it will not automatic delete calendar appointments anymore.
howto export mailbox size to CSV file Exchange 2007/2010
Howto Export all mailbox’es and there size to a CSV file
get–mailbox | get-mailboxstatistics | select-object DisplayName,TotalItemSize,StorageLimitStatus,LastLogonTime | Export-Csv c:\exchange.csv
Test Exchange remote connectivity
Microsoft have launch a new webpage to test Exchange remote connectivity.
It can test:
ActiveSync
Activesync autodiscover
Outlook autodiscover
Microsoft Exchange Web Services Connectivity Tests
Outlook Anywhere (RPC over HTTP)
Outbound SMTP E-Mail
Howto shrink / truncate SQL transaction log file in SQL Server 2005
USE <databasename>
GO
DBCC SHRINKFILE(‘<logfilename-logical name>’, 1)
BACKUP LOG <databasename> WITH TRUNCATE_ONLY
DBCC SHRINKFILE(‘<logfilename-logical name>’, 1)
GO
Microsoft SQL (MSSQL) query for active session
Howto see active sessions in a mssql.
Its pretty easy just make a new query, and run sp_who or sp_who2.
sp_who shows whitch active sessions there are, and sp_who2 shows more information about the users.
Outlook crash on opening a shared calendar
I have a problems today with an Outlook that keeps crash sometimes when a user is opening a share calendar. I tested it on my test machine and when the user opening the shared calendar at my test machine my own outlook crash also.
I then try to give the user full permission to the mailbox and that resolve the issues.
The error code in the event viewer was:
Faulting application outlook.exe, version 12.0.6514.5000, stamp 4a89dc70, faulting module mso.dll, version 12.0.6425.1000, stamp 49d65443, debug? 0, fault address 0x000057ba.
This is not the best solution but is a workaround for now. It seams to be a bug in the way Exchange 2010 and Outlook 2007 is running.
See also: http://social.technet.microsoft.com/Forums/en-US/exchange2010/thread/43469ef9-2274-403c-9a15-44460540f9e4