Добро пожаловать в форум, Guest  >>   Войти | Регистрация | Поиск | Правила | В избранное | Подписаться
Все форумы / Microsoft SQL Server Новый топик    Ответить
 Log Shipping ,Standby - error , а NORECOVERY - работает  [new]
Rodion
Member

Откуда:
Сообщений: 32
Пытаюсь настроить Log Shipping (standby)

select @@VERSION

Microsoft SQL Server 2012 - 11.0.2218.0 (X64)
Jun 12 2012 13:05:25
Copyright (c) Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 6.0 <X64> (Build 6002: Service Pack 2) (Hypervisor)

Microsoft SQL Server 2012 (SP1) - 11.0.3000.0 (X64)
Oct 19 2012 13:38:57
Copyright (c) Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)


При ресторе второго или третьего транзакт-лога выдает ошибку.
Однако , Если NORECOVERY - все проходит нормально. Транзакт-логи в обоих случаях одинаковые.
Но мне нужно настроить STANDBY !!!

------

-- На первичном:

BACKUP DATABASE TEST_LS
TO DISK='E:\BCK_OLD\BACKUP\MSSQL\TEST_LS_1.bak'
With INIT;

BACKUP LOG TEST_LS
TO DISK='E:\BCK_OLD\BACKUP\MSSQL\TEST_LS_log1.trn'
WITH FORMAT;

BACKUP LOG TEST_LS
TO DISK='E:\BCK_OLD\BACKUP\MSSQL\TEST_LS_log2.trn'
WITH FORMAT;

-- На вторичном:


RESTORE DATABASE TEST_LS FROM DISK = 'D:\LogSH\TEST_LS\135\TEST_LS_1.bak' WITH REPLACE ,STANDBY='\\Admin-pc\TEST_LS\UNDO.DAT'
, MOVE 'TEST_LS' TO 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER_2012\MSSQL\DATA\TEST_LS.mdf',
MOVE 'TEST_LS_Log' TO 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER_2012\MSSQL\DATA\TEST_LS_log.ldf';

Processed 272 pages for database 'TEST_LS', file 'TEST_LS' on file 1.
Processed 2 pages for database 'TEST_LS', file 'TEST_LS_log' on file 1.
System objects could not be updated in database 'TEST_LS' because it is read-only.
System objects could not be updated in database 'TEST_LS' because it is read-only.
RESTORE DATABASE successfully processed 274 pages in 0.291 seconds (7.349 MB/sec).


RESTORE LOG TEST_LS FROM DISK='D:\LogSH\TEST_LS\135\TEST_LS_log1.trn' WITH STANDBY='\\Admin-pc\TEST_LS\UNDO_1.DAT';

Processed 0 pages for database 'TEST_LS', file 'TEST_LS' on file 1.
Processed 3 pages for database 'TEST_LS', file 'TEST_LS_log' on file 1.
System objects could not be updated in database 'TEST_LS' because it is read-only.
System objects could not be updated in database 'TEST_LS' because it is read-only.
RESTORE LOG successfully processed 3 pages in 0.054 seconds (0.325 MB/sec).

RESTORE LOG TEST_LS FROM DISK='D:\LogSH\TEST_LS\135\TEST_LS_log2.trn' WITH STANDBY='\\Admin-pc\TEST_LS\UNDO_1.DAT';


Processed 0 pages for database 'TEST_LS', file 'TEST_LS' on file 1.
Processed 1 pages for database 'TEST_LS', file 'TEST_LS_log' on file 1.
Msg 9004, Level 16, State 6, Line 1
An error occurred while processing the log for database 'TEST_LS'. If possible, restore from backup. If a backup is not available, it might be necessary to rebuild the log.
Msg 3013, Level 16, State 1, Line 1
RESTORE LOG is terminating abnormally.
Msg 3414, Level 21, State 1, Line 1
An error occurred during recovery, preventing the database 'TEST_LS' (7:0) from restarting. Diagnose the recovery errors and fix them, or restore from a known good backup. If errors are not corrected or expected, contact Technical Support.
23 апр 14, 12:24    [15921597]     Ответить | Цитировать Сообщить модератору
Все форумы / Microsoft SQL Server Ответить