Recommended for: Full DB backup, moving DB data to another drive, moving DB data between different versions of SQL server (Ex: SQL Server 2008 R2 to SQL Server 2012).

Login to Microsoft SQL Server Management Studio and connect to your current SQL Server.
Right-click the DB that you want to move (Eg: adap). Select Tasks → Detach.
In the Detach DB wizard → Select both the check boxes (Drop Connections and Update Statistics) → Ok.
Go to the DB storage path (Path syntax: C:\Program Files\Microsoft SQL Server\MSSQL<SQL_Server_Version>.<Instance_Name>\MSSQL\DATA
For example, the path for 2019 SQL Server with Instance_Name or Service_Name as MSSQLSERVER: C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA) → Copy the .mdf and .LDF files (For example: adap.mdf and adap_log.LDF).
Save both of the above files in a desired location.
Login to Microsoft SQL Server Management Studio and connect to the new SQL Server to which you want to migrate the DB.
Right-click the destination database and select Attach.
In the Attach DB wizard, click Add button.
Select the .mdf file from where it has been saved --> Ok (the .LDF file will get selected automatically).
Go to <ADAudit Installation>\conf folder --> Open database_params --> Change the SQL server location and DatabaseName, so that the product is pointed to the new DB.

ad-audit-plus-db-migrations-detach-attach-method

2. MS SQL DB Migration using Import Data Method

Recommended for: Moving particular table data from one DB to another.

Login to Microsoft SQL Server Management Studio.
Right click on the DB that you want the data moved to (Ex: adap_new). Select Tasks --> Import Data.
The SQL Server Import and Export wizard opens up --> Click Next
In the Data Source wizard, that opens up, specify: (In the Data source drop down, select SQL Server Native Client if it's not selected already.)
- Server Name.
- Authentication (Used to login to SSMS).
- Database.
- Click Next.
Under the Destination wizard, enter the following: (In the Data source drop down, select SQL Server Native Client if it's not selected already. )
- Server Name (will get automatically detected, you can change the destination, if you want).
- Authentication.
- Database (will get automatically detected, you can change the destination, if you want).
- Click Next.
Under Specify Table Copy or Query --> Choose Copy Data From One or More Tables/Views --> Next.
Under Select Source Tables and Views --> Choose the tables to be copied from source, select the tables from the left column using Edit Mappings --> Select particular table operations --> Next.
Check the Run Immediately box--> Next.
Click Finish.

Quick start

Architecture

Active Directory

Active Directory auditing

ADFS auditing

Group policy object auditing

Azure AD configuration

Azure AD DS auditing

Windows Server

Windows server auditing

Removable storage auditing

File integrity monitoring

PowerShell auditing guide

User session recording

File Server

Windows file server auditing

EMC server auditing

EMC Isilon auditing

Synology auditing

Huawei OceanStor Auditing

NetApp filer auditing

NetApp cluster auditing

Hitachi NAS auditing

Amazon FSx auditing guide

Windows workstation auditing

Event collection troubleshooting

Migration

Security

Security specifications

Security hardening

Product configuation

Service account configuration

SSL configuration

Security log settings

Agent configuration

Single sign-on

Ports

2FA configuration

Virtual IP address settings

High availability configuration

Email server configuration

Automatic configuration

Migrating data between different versions of MS SQL

1. MS SQL DB Migration using Detach and Attach Method

2. MS SQL DB Migration using Import Data Method

In this article

ADAudit Plus Trusted By

Meet all auditing and IT security needs with ADAudit Plus.

A single pane of glass for complete Active Directory Auditing and Reporting