Restoration Part-7

What is RESTORE LABELONLY option?

It returns a result set containing information about the backup media identified by the given backup device.

T-SQL script for RESTORE LABELONLY.

RESTORE LABELONLY FROM DISK='D:\MyDrive\Adv_Full.bak'

What is a RESTORE HEADERONLY OPTION?

It is used to check the content of a backup file.

T-SQL Script for RESTORE HEADERONLY.

RESTORE HEADERONLY FROM DISK = N'C:\AdventureWorks2012.bak'

What kind of common issues with Log Restores?

·         an incomplete series of log backup files.

·         a missing full backup database file.

·         minimally logged transactions in a log file, when database is operating in the BULK_LOGGED recovery model.

How to make your database into single user mode?

ALTER DATABASE Database_Name SET SINGLE_USER

How to make your database into multi user mode?

ALTER DATABASE Database_Name SET MULTI_USER;

How to make your database into emergency mode?

ALTER DATABASE Database_Name SET EMERGENCY;

Have you ever failed to get exclusive access for MSDB?

Yes, If SQL Server Agent service is running, exclusive access cannot be achieved. To get an exclusive access, you should stop the SQL Agent service.

Can you encrypt data while creating a backup?

Starting in SQL Server 2014, SQL Server has the ability to encrypt the data while creating a backup. By specifying the encryption algorithm and the encryptor (a Certificate or Asymmetric Key) when creating a backup, you can create an encrypted backup file.

Which versions of SQL Server support TDE?

TDE requires SQL Server 2012 Enterprise edition. It’s not available in SQL Server 2012 Standard or Business Intelligence editions. TDE is also available in SQL Server 2008 and SQL Server 2008 R2 Datacenter and Enterprise editions.

 

Is there a performance impact for using TDE?

Yes, some performance overhead is involved in using TDE. The encryption and decryption process do require additional CPU cycles. The overhead for using TDE ranges from about 3 percent to 30 percent, depending on the type of workload.

 

SQL Server instances with low I/O and low CPU usage will have the least performance impact. Servers with high CPU usage will have the most performance impact.

Please visit other related articles...

https://sqldbaiq.blogspot.com/p/restoration.html
https://sqldbaiq.blogspot.com/p/restoration-part-2.html
https://sqldbaiq.blogspot.com/p/restoration-part-3.html
https://sqldbaiq.blogspot.com/p/restoration-part-4.html
https://sqldbaiq.blogspot.com/p/restoration-part-5_16.html
https://sqldbaiq.blogspot.com/p/restoration-part-6_16.html

https://sqldbaiq.blogspot.com/p/restoration-part-7.html

References: Thanks to the all the SQL Server bloggers who wrote and shared the valuable information on their blogs which helped me a lot to prepare this series of Questions. Also big thanks to Microsoft Documentation which contains each and everything about their product.