![]() To restore an encrypted database, you must have access to the certificate or asymmetric key used to encrypt the database! Without that certificate or asymmetric key, you can't restore the database. For more information, see Back Up a Transaction Log (SQL Server). Under the full or bulk-logged recovery model, before you can restore a database, you must back up the active transaction log. The system administrator restoring a full database backup must be the only person currently using the database to be restored.Before you begin Limitations and restrictions ![]() You can move a database to a new directory path or create a copy of a database on either the same server instance or a different server instance. This article describes how to restore a SQL Server database to a new location, and optionally rename the database in SQL Server by using SQL Server Management Studio (SSMS) or Transact-SQL.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |