Skip to content

Commit d81a501

Browse files
authored
Wrong extension on the log files
Changed the extension of log files from .bak to .trn
1 parent f8ad5af commit d81a501

1 file changed

Lines changed: 5 additions & 5 deletions

File tree

docs/database-engine/availability-groups/windows/manually-prepare-a-secondary-database-for-an-availability-group-sql-server.md

Lines changed: 5 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -188,7 +188,7 @@ This topic describes how to prepare a database for an Always On availability gro
188188
GO
189189
```
190190
191-
5. After you restore the full backup, you must create a log backup on the primary database. For example, the following [!INCLUDE[tsql](../../../includes/tsql-md.md)] statement backs up the log to the a backup file named *E:\MyDB1_log.bak*:
191+
5. After you restore the full backup, you must create a log backup on the primary database. For example, the following [!INCLUDE[tsql](../../../includes/tsql-md.md)] statement backs up the log to the a backup file named *E:\MyDB1_log.trn*:
192192
193193
```
194194
BACKUP LOG MyDB1
@@ -198,7 +198,7 @@ This topic describes how to prepare a database for an Always On availability gro
198198
199199
6. Before you can join the database to the secondary replica, you must apply the required log backup (and any subsequent log backups).
200200
201-
For example, the following [!INCLUDE[tsql](../../../includes/tsql-md.md)] statement restores the first log from *C:\MyDB1.bak*:
201+
For example, the following [!INCLUDE[tsql](../../../includes/tsql-md.md)] statement restores the first log from *C:\MyDB1.trn*:
202202
203203
```
204204
RESTORE LOG MyDB1
@@ -209,15 +209,15 @@ This topic describes how to prepare a database for an Always On availability gro
209209
210210
7. If any additional log backups occur before the database joins the secondary replica, you must also restore all of those log backups, in sequence, to the server instance that hosts the secondary replica using RESTORE WITH NORECOVERY.
211211
212-
For example, the following [!INCLUDE[tsql](../../../includes/tsql-md.md)] statement restores two additional logs from *E:\MyDB1_log.bak*:
212+
For example, the following [!INCLUDE[tsql](../../../includes/tsql-md.md)] statement restores two additional logs from *E:\MyDB1_log.trn*:
213213
214214
```
215215
RESTORE LOG MyDB1
216-
FROM DISK = 'E:\MyDB1_log.bak'
216+
FROM DISK = 'E:\MyDB1_log.trn'
217217
WITH FILE=2, NORECOVERY
218218
GO
219219
RESTORE LOG MyDB1
220-
FROM DISK = 'E:\MyDB1_log.bak'
220+
FROM DISK = 'E:\MyDB1_log.trn'
221221
WITH FILE=3, NORECOVERY
222222
GO
223223
```

0 commit comments

Comments
 (0)