Describe when someone would need this information. For example "when connecting to wi-fi for the first time".
Set up TDE
Install TDE client
Create a smartpoint to the database location on disk
The SQL Smartpoint must allow these apps encrypt/decrypt permission. Other applications may be necessary depending on the environment.
To move a SQL server database, the database must be detached, then the files must be moved to a new location and then the database can be attached again.
Change the file locations with an ALTER DATABASE command:
Note: Changes to the path do take effect immediately, but will be applied the next time the database starts.
Take the database offline
Using WITH ROLLBACK IMMEDIATE will disconnect all users and roll back all currently open transactions:
Copy the files to the new location
Copy the files to the new location using your
Note: Do not use any “Move” functions to copy the database files to their new location or transparent disk encryption will not be applied.
Bring the database online
Related articles appear here based on the labels you select. Click to edit the macro and add or change labels.