From management studio

Navigate to Integration Services Catalog

Right-click SSISDB

Properties

In the section of Operations Log: Retention Period

In the section of Project Versions: Maximum number of versions per Project

Thanks for posting your solution

Can you query ACC from PRD through linked server?

Perhaps a firewall issue

I guess its Azure now.

Thanks for your input Brandie, got a possible workaround.

To the experts of DBCC TIMEWARP

Why can't system databases be restored "with move" like the others?

Example: RESTORE database model with move -> The system database cannot be moved by RESTORE

I would start them in this order

1.SSRS Server

2.SharePoint SQL (no connection errors to reports)

3.SharePoint Web (no connection errors to SharePoint sql)

Great story

You need a rendering extrension for SSRS, 3th party or write it yourself

Contact support?

I once tricked HP dataprotector by modifying the host-file of the HP backup server so dns calls would render the IP of target server instead of the Original server.

Target...

Install the oracle client

I recommend you start applying them after some testing.

Haven't tried it yet, but why would you want to access Oracle as sysdba through linked server?

Isn't it possible to grant the user the specific rights for their needs?

Start reading the oracle concepts

and DBA 2 day course

As above, talk to your manager about priorities and stop taking work to home.

If possible get some training time so you won't have to do training in personal time, so...

SQL Server days (2 days) just passed and was great. How do you prepare for pass summit with 5 days of awesomeness?