Microsoft SQL Server
How to Enable Remote Connections to SQL
This guide will walk you through enabling remote connections to SQL Server, allowing other devices on your network to connect to the database. Open SQL Server Configuration Manager Go to Start and search for SQL Server 2022 Configuration Manager ...
Installing Microsoft SQL Server
This article will walk you through installing and configuring SQL Server for a migration workstation. Visit https://www.microsoft.com/en-us/sql-server/sql-server-downloads and scroll down just a bit until you see Developer and click the Download now ...
Restore a MSSQL BACPAC Backup
BACPAC files are a specialized set of SQL Scripts that can be restored into Microsoft SQL Server using Management Studio. To restore a BACPAC database, do the following steps. Open Management Studio and connect to the database server. Right-click on ...
Create a MSSQL BACPAC Backup
To create a BACPAC backup, do the following steps: Open Management Studio and connect to the database server. Right click on the database you wish to backup and select Tasks > Export Data-tier Application... In the dialog that appears click "Next >" ...
Restore a MSSQL BAK Backup
To restore a MSSQL BAK database backup, do the following steps: Open Management Studio and connect to the database server. 1. Right-Click on Databases 2. Select Restore Database... In the dialog that appears: 1. Select Device 2. Click the ... button: ...
Create a MSSQL BAK Backup
To create a BAK backup, do the following steps: 1. Shrink the Database (Optional) Open Management Studio and connect to the database server. Change the Recovery Model to Simple: 1. Right click on the database you wish to backup and select Properties. ...
Create a Secondary SA (Admin) Account for MSSQL
In the event that you have lost or forgotten your SQL administrator password, the following script can create an additional administrator SA user account that you can use to log in. This is preferable over resetting the SA password because changing ...
Repair a corrupt MSSQL database
For law firms with premises based systems like Time Matters you may run into situations where the database has not been maintained and has become inconsistent. This can prevent your ability to create a backup from which you can migrate the customer ...