Restore a Differential Database Backup (SQL Server)

First restore full closest backup with default options.

Then restore defferential backup with “RESTORE WITH NORECOVERY” option.

Then click on database name and choose “Tasks“, “Restore” and then “Transaction Log“.
Place needed transaction log to the folder that SQL tells you it look for backup.

 

https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/restore-a-differential-database-backup-sql-server?view=sql-server-2017

https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/restore-a-transaction-log-backup-sql-server?view=sql-server-2017

 

SQLServer Error: 229, The EXECUTE permission was denied on the object ‘sp_sqlagent_update_agent_xps’

Если такая блевота в логе SQLAGENT.OUT:

2018-04-08 19:39:48 – ? [100] Microsoft SQLServerAgent version 12.0.2000.8 (X64 unicode retail build) : Process ID 4440
2018-04-08 19:39:48 – ? [495] The SQL Server Agent startup service account is XXX.
2018-04-08 19:39:48 – ? [393] Waiting for SQL Server to recover database ‘msdb’…
2018-04-08 19:39:48 – ! [298] SQLServer Error: 229, The EXECUTE permission was denied on the object ‘sp_sqlagent_update_agent_xps’, database ‘msdb’, schema ‘dbo’. [SQLSTATE 42000] (DisableAgentXPs)
2018-04-08 19:39:48 – ! [000] The EXECUTE permission was denied on the object ‘sp_sqlagent_update_agent_xps’, database ‘msdb’, schema ‘dbo’. [SQLSTATE 42000] (Error 229)
2018-04-08 19:39:48 – ! [298] SQLServer Error: 229, The EXECUTE permission was denied on the object ‘sp_sqlagent_update_agent_xps’, database ‘msdb’, schema ‘dbo’. [SQLSTATE 42000] (DisableAgentXPs)
2018-04-08 19:39:48 – ! [000] The EXECUTE permission was denied on the object ‘sp_sqlagent_update_agent_xps’, database ‘msdb’, schema ‘dbo’. [SQLSTATE 42000] (Error 229)
2018-04-08 19:39:48 – ? [098] SQLServerAgent terminated (normally)

То в первую очередь надо проверить, запустится ли сервис от админа, во вторую – права на базы как в самом SQL, так и на физическом носителе.

SQL Backups troubleshoot

Trouble #1:
https://support.microsoft.com/ru-ru/help/955763/the-sql-server-agent-service-does-not-start-after-you-upgrade-from-sql-server-2008-express-or-from-sql-server-2008-express-with-advanced-services-to-sql-server-2008-developer,-to-sql-server-2008-enterprise,-or-to-sql-server-2008-standard

Trouble #2:
https://msdn.microsoft.com/ru-ru/library/ms178127.aspx

Trouble#3:
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/124bbce8-fed9-49ad-9703-7e4cace1e81d/databases-with-simple-recovery-will-be-excluded-sql-server-2008?forum=sqltools

Настройка 1С SQL

http://www.portal-yug.ru/blog/corp/34.phphttp://interface31.ru/tech_it/2014/01/ustanovka-i-nastroyka-ms-sql-server-dlya-1spredpriyatie.html