If the SQL databases are in simple recovery[pastacode lang=”sql” manual=”Backup%0A%0AALTER%20DATABASE%20dbname%0A%0ASET%20READ_ONLY%3B%0A%0AGO%0A%20%0A%0ABackup%20database%20dbname%0A%0Ato%20disk%20%3D%20’C%3A%5C…%5Cdbname.bak’%0A%0A%20%0ARestore%0A%0A%0ARestore%20database%20dbname%0A%0Afrom%20disk%20%3D%20%20’C%3A%5C…%5Cdbname.bak’%0A%0Awith%20recovery%2C%20replace%0A%0A%20%0A%0AALTER%20DATABASE%20dbname%0A%0ASET%20MULTI_USER%3B%0A%0AGO” message=”” highlight=”” provider=”manual”/]If the databases are in full recovery model[pastacode lang=”sql” manual=”Backup%0A%0ABackup%20database%20dbname%0A%0Ato%20disk%20%3D%20’C%3A%5C…%5Cdbname.bak’%0A%0ABackup%20log%20dbname%0A%0Ato%20disk%20%3D%20’C%3A%5C…%5Cdbname.trn’%0A%0Awith%20norecovery%0A%0A%20%0ARestore%0A%0A%20%0ARestore%20database%20dbname%0A%0Afrom%20disk%20%3D%20’C%3A%5C…%5Cdbname.bak’%0A%0Awith%20norecovery%2C%20replace%0A%0ARestore%20log%20test2%0A%0Afrom%20disk%20%3D%20’C%3A%5C…%5Cdbname.trn’%0A%0Awith%20recovery%0A%20″ message=”” highlight=”” provider=”manual”/]
Category: Research
Research Undertaken
iManage – Generate Email Button Greyed out Imanage
Make sure the user has “Full Access” to the folder and just not “Read\Write”
delete fortigate hardware switch
By default Fortigates come with all their LAN interfaces on a hardware switch. You might want to change this so you can use these as seperate interfacesDelete […]
How to detect Disk Data change on Vmware VM ( write rate )
Enabling vCenter Server Data Collection To enable vCenter Server data collection:1.Connect to the vCenter Server.2 In the Administration menu item, selectvCenter Server Settings The vCenter Server Settings dialog […]
Measuring Hyper V Disk Rate Change
You can collect data characteristics for the virtualmachines in a VPG in one of the following ways: By using operating system performance monitors, such as the Microsoft Performance […]
Administrator trying to access other users Onedrive – Loading Access Link – Access File nothing happening
When trying to access another user Onedrive via the Admin portal of 365 , the new gui shows“Loading Access Link” and no link is shown The old Classic […]
How to find Local Administrator Password Set in MDT
Naviate to your DeploymentShare and Open up the Task Sequence in the Control DirectoryC:\DeploymentShare\Control\TaskSequence1Open Unattend.xml Search for AdministratorPassword in this fileYou should see the password in plaintext
An NPS extension dynamic link library (DLL) that is installed on the NPS server rejected the connection request.
Trying to diagnose an issue of a reason why an NPS server would not let a user in and come back with Access-Reject produces the following Reason […]
(“pwcount= + “1”) – Expression syntax error [ount= + “1^”), Offset 15]
Recently I was trying to hide the password 2 field on a netscaler box due to Azure MFA Radius.The netscaler was brining back the error : Expression […]
Http/1.1 Internal Server Error 43531
Recently trying to setup a secondary virtual server for Citrix , on login the following prompt was displayedHttp/1.1 Internal Server Error 43531Make sure your Virtual Server has […]
