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.
Category 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:
- 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
Disable password complexity password policy
Logon to you Domain Controller, and start Group Policy Manager.
Right click on you “Default Domain Policy” and press edit
Go to Computer Configuration -Policies -> Windows Settings -> Security Settings -> Account Policy -> Password Policy
And set all settings to 0 (zero) or disable.
Do not set it to Not defined, that will set is as default behavior = Password complexity enabled.
XenDesktop 5 Provisioning firewall ports
The following ports need to be open from the VDI to the Provision servers.
UDP 69
UDP 6905-6930
UDP 4011
TCP 54321-54322
TCP 10802-10803
Citrix VDI Xendesktop Ekspert
Jeg er blevet certificeret i Citrix XenDesktop, samtidig med at jeg har sat et komplet redudant Citrix Xendesktop miljø op.
Citrix Xendesktop tilbyder dig en hosted desktop løsning, der hvor Citrix Xendesktop virkelig kommer til udtryk er hvis i f.eks. i jeres virksomhed er 50 ansatte, istedet for at skulle købe 50 computer, vedligeholde image til disse, hvilket i tilfælde af 50 nye maskiner ikke er så svært men med tiden, vil man efterhånden for mange foreskellige computere man skal have image til.
Her kan man istedet for med Citrix Xendesktop, have et image, som ligger på en hypervisor, enten fra Vmware eller Citrix, og så bare have tynde klienter ude istedet for en fysisk computer.
Så begynder man at spare meget tid i forbindelse med vedligeholdelse, og er der så et problem med en klienter, så for brugeren bare et nyt image.
Derudover har man også 100% kontrol over ens maskiner, for “computeren” forlader aldrig serverrummet.
Der er mulighed for at arbejde med shared grund image, således at image er låst af administratoren og alle arbejde i samme image, nå så man logger af, genstarter ens VDI og den bliver så automatisk nulstillet til “fabriksindstillinger”.
Der er også mulighed for at nogle bruger for deres egen VDI, som de selv kan administrere. Gå den i stykker ruller man bare en ny klient ud til brugeren, som de kan rode i.
Citrix Xendesktop virker på den måde at nå den tynde klienter starter op, starter den op med at kalde Citrix Xendesktop og for præsenteret en virtuel maskine hosted på en fælles server.
Citrix har også noget de kalder XenApp. I Citrix Xenapp arbejderalle brugere på en terminalserver eller flere i en farm, men med Xendesktop for hver medarbjeder sin egen virtuelle computer, og derved kan man ikke belaste systemet så meget at det gør det umuligt for de andre medarbejde at arbejde i deres setup.
Med f.eks. så Microsoft APP-V, kan man streame applikationer ud til ens VDI, og derved nøjes med et grundimage, hvor der er installeret basic tingende som alle brugere, og så have resten af sine applikationer liggende på sin APP-V server.
Der hvor APP-V adskiller sig fra Xenapp, er at programmerne kører på den maskine de bliver streamet til og ikke køres fra en central server. Igen en fordel da en bruger ikke kan belastede systemet så meget at det ødelægger de andres performence.
Jeg glæder mig til arbjede rigtigt meget med Citrix Xendesktop. Kontakt mig endelig for spørgsmål angående dette produkt.
Citrix Xendesktop enable logging on VDI machines
1. Create a new directory called e:\vdilogging\.
The Network and Local service accounts need to have write access to this folder. If you using vdisk in standard mode, remember to save it on locally harddrive.
2. Go to c:\Program Files\Citrix\Virtual Desktop Agent\
3. Open WorkstationAgent.exe.config with notepad
4. Goto <appSettings>.
5. Within the <appSettings> tag, insert the following lines:
<add key="LogToCDF" value ="1"/> <add key="LogFileName" value ="C:\ctxlogging\vda.log"/>
6. Then you need to restart you desktop machine
Limit SQL Server maximum memory SQL instance
- Start SQL Server Management Studio
- Connect to you SQL server instance
- Start a “New Query”
- And then put this into you SQLQuery1.sql window
sp_configure ‘show advanced options’,1
reconfigure with override
go
sp_configure ‘max server memory’, 4096
reconfigure with override
go
- Then push the execute buttom, this will limit you SQL instance to 4096MB or 4GB. Please beware of, if you have multiple instance each instance you wan’t to limit
Limit SQL Server maximum memory SQL of WSUS
- Start SQL Server Management Studio
- Connect to \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query
- Start a “New Query”
- And then put this into you SQLQuery1.sql window
sp_configure ‘show advanced options’,1
reconfigure with override
go
sp_configure ‘max server memory’, 256
reconfigure with override
go
- Then push the execute buttom, this will limit you SQL of WSUS to 256MB, whitch should be enough.
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
- * Open “C:\Program Files\Microsoft Forefront Threat Management Gateway\UI_HTMLs\TabsHandler\TabsHandler.htc”
- 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) ; - Save the file, and re-open TMG management console.
Windows cannot print due to a problem with the current printer setup
I have this error on my Citrix servers, where one user cannot print to one printers, while others user could.
“Windows cannot print due to a problem with the current printer setup”
The Danish error:
windows kan ikke udskrive pga. problemer med den nuværende printerindstilling
The fix was:
- Log on as the user have the problems
- Delete all printers in: devices and printers.
- Start regedit
- Navigate to: HKEY_CURRENT_USER\Software\Microsoft\Windows NT\CurrentVersion\Devices
- And delete all entry here, beware of not delete any entry that there still exist in devices and printers
The problems was that some printers are created with:
“\\\\server.domain\printname”=”winspool,Ne-01:”
will others are created with:
“\\\server.domain\printname”=”winspool,Ne35:” without the hyphen, and that seam to be the problems.