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”/]
Tag: SQL
Worksite\iManage – SQL to change the owner of Workspace/Folder
Here are the steps to change the owner of Workspace/Folder in Worksite 10–To change the owner of a Workspace/Folder, first we need to find the prj_id of […]
How to open .DSTX Files from SQL Server
So you’ve found an issue in a Package in a Project for a DataSynchronization in a Integration Services Catalogs ( .dtsx file ) that you want to edit?Install […]
N-able Report Manager Maintenance – Reduce Database Size
Login to the Nable Administrator Report Manager ( http://%reportmanagerserver%/Interface/Pages/menu.aspx ) You will need to use the username : [email protected] ( You can reset this password ) Navigate to the followingSelect System Setup and […]
Interactive Training for SQL and RegEx
https://sqlbolt.com/https://regexone.com/
Veeam Writer’s state: [VSS_WS_FAILED_AT_PREPARE_SNAPSHOT]. Error code: [0x800423f4].]
A Server 2012 R2 started getting VSS Writer Errors randomly in Veeam backup job. The server is running AADconnect which is set to autoupdateA restart of the […]
Cannot delete Credentials in Veeam due to Shared Folder
For some reason I couldn’t delete credentials from Veeam due to them being used on a Shared Folder that did not existing in a backup repository or […]
Email Filing Service Gui not showing Failed Folders
As there is no notification with the iManage Email Filing Server when folder status turns from Succeeded to reset the folder , we use the following SQL […]
Search for folder in iManage
It seems the iManage Inbox has difficulties filing items in a folder with a Custom24 Attribute attached to it. Here’s how to search imanage folders and list […]
Worksite iManage History SQL Search Query
Worksite/Imanage Monitor can export a document list based on History using the History search but it’s limited in the way it can display comments as well as […]