Jeff Moden wrote: Jonathan AC Roberts wrote:
If you are only moving the application databases (not the system databases). You can just detach the databases, move the database files to a different location then just Attach to the files in the new location.
Make sure you backup the database before performing this type of operation.
Perhaps and perhaps not. If you've done it (encryption) correctly, you probably won't be able to access anything that's been encrypted by doing that. You also have to cover system logins, etc.
Yes, you'll have to give SQL Server permissions to the new file locations. But you can usually work that out as you go along.
I assumed that the database was not encrypted (it probably isn't). But if it is encrypted and just needs it to be moved to a different drive on the same server then it still should be a case of just detaching the database, moving the files then attaching them. If it is moving the database to a different server then obviously the certificate and private key would need to be backed up and restored on the new server.