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”/]
(No Ratings Yet)
Loading... (No Ratings Yet)Loading...iManage – Generate Email Button Greyed out Imanage
Make sure the user has “Full Access” to the folder and just not “Read\Write”
(No Ratings Yet)Loading...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 […]
(No Ratings Yet)Loading...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 […]
(No Ratings Yet)Loading...xmlrpc.php
Recently in the server logs I saw lots of attempts to /xmlrpc.php/xmlrpc.php is the file used for Pingbacks, so if someone links to my blog , they […]
(No Ratings Yet)Loading...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 […]
(1 votes, average: 1.00 out of 5)Loading...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 […]
(1 votes, average: 10.00 out of 5)Loading...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
(2 votes, average: 10.00 out of 5)Loading...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 […]
(No Ratings Yet)Loading...(“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 […]