Check the memory usage in perfmon, check target and available memory just adjust the memory once again and observe again.

We can set min and max as below.

EXEC sp_configure 'show advanced...

Check this http://support.microsoft.com/kb/2543687

Seems issue with connectivity of SQL Agent on Secondary, Can you explain little more or if you paste any errors will be more helpfull:)

"Reinstalling .Net Framework X.X solved the problem" found at:

"http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/75e2f725-338f-41a7-b66b-5fb4be2d339c"

Please uninstall previous version completly, from control panel.

Then reboot. Start fresh instalations.

If still error paste the log from boot startup folder 🙂

Is there any NEW DB created after maintennace plan? Which plan directly wants to take DIff?

Or Do you receving specific error when ever job runs in the intervals.

Please paste error.

To take differential backup, we need the Full backup in the place, else it will fail.

So make your schedule in such a way, First let it happen full backup for...

Check this , It will help you

http://www.sqlservercentral.com/scripts/T-SQL/69348/

USE Reportserver

go

MS ******/

SELECT TOP 1000 [HistoryID]

,[ReportID]

,[SnapshotDataID]

,[SnapshotDate]

FROM [ReportServer].[dbo].[History]

...

Welcome 🙂

Is that helped?

Please share the error!

Please set the sys subsytem values to proper values.

Example :-

use msdb

go

select * from msdb.dbo.syssubsystems

update syssubsystems set subsystem_dll ='E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\binn\SQLCMDSS.DLL'

where subsystem='CmdExec'

Restart SQL Agent once Done.

Table with values...

Set the size while restore

MAXTRANSFERSIZE

Specifies the maximum size of each block of memory to be used when SQL Backup stores backup data. You may want to specify this argument if...

can you share the error 🙂