Showing posts with label DB Administration. Show all posts
Showing posts with label DB Administration. Show all posts
Published On: 7/01/2022
SQL DBA Interview: Master Top 30 Questions for Success
Point in Time Recovery in SQL Server:Question 1: What is point-in-time recovery in SQL Server?
Answer: Point-in-time recovery enables the restoration of a database backup at any specific time, applicable to databases under the full or bulk-logged recovery model. Point-in-time recovery is not possible if the database uses the bulk-logged recovery mo…
Read More »
Published On: 11/05/2017
Add article on existing publication without reinitialize in SQL Server
We can add an article or table on existing publication in SQL Server without dropping the publication and we can synchronize the particular article on existing subscription. This is common and frequent requirement in DBA task list to add an article or table on existing publication in SQL Server and also frequently asked questions in DBA interviews…
Read More »
Subscribe to:
Posts (Atom)