-5

I have 2 databases: A and B.

I want to replace B with a copy of A. To do that I followed following steps:

  1. Backup A
  2. Delete B (optional)
  3. Restore backup with destination name as B

Step 3 fails because the source db (A) is not in single user mode.

What is the purpose that the restore operation tries to take tail log backup of source database? I know that this activity can be bypassed is options->tail-log backup. But my question is - what purpose does a tail log backup of source db serve to this restore operation?

Step 3 fails because db A (source db) is not in single user mode due to which tail log backup cannot be taken. My question is why does it even bother to take a tail log backup?

Assuming I have a backup file from last month that I want to restore as a new database, then why does it try to take a tail log backup of the source db?

variable
  • 3,590
  • 4
  • 37
  • 100

1 Answers1

2

The purpose of a tail log backup is to ensure that no transactions are written to the database after the backup is taken.

David Browne - Microsoft
  • 49,000
  • 3
  • 53
  • 102