my bad.

and i was under the impression that this is SQL 2014 forum..

not sure, wrote this script long time ago -- modify it as you like 

SET QUOTED_IDENTIFIER OFF
SET ANSI_NULLS ON
set nocount on
declare @t as...

will this help

SELECT SCHEMA_NAME(so.schema_id) AS schema_name ,
   OBJECT_NAME(p.object_id) AS object_name ,
   p.partition_number ,
   p.data_compression_desc ,
   dbps.row_count ,
  ...

yes, https://docs.microsoft.com/en-us/sql/relational-databases/replication/administration/distributor-and-publisher-information-script

here is how I will troubleshoot. 

download handle.exe https://docs.microsoft.com/en-us/sysinternals/downloads/handle
add another step in job to run handle.exe x:\.......errorlog.log' when the 1st step fails

in theory this should...

right click database --> task -- Generate Scripts
choose objects --> script entier database
set scripting options --> advanced

select 'schema only' for 'types of data to script'

I agree with Jeff,  I use this to shrink and/or fix VLF -- modify it as you like 

declare @org_size table (file_id int, database_id int,db_name varchar(400), type_desc varchar(5),pn nvarchar(2000),size_in_mb...

also check os level backup might be locking the file and/or change time for your sql job to avoid collision

I may be wrong, but as far as i remember SQL_Latin1_General_CP1_CI_AS and Latin1_General_CS_AS are the same, only difference is Latin1_General_CS_AS is used in analysis services ...

is this what you are looking for ?

-- create table for fist run
IF object_id('msdb..my_sysjobs') is null
begin
select * into msdb..my_sysjobs from msdb..sysjobs
end
-- send...

I believe so

I suppose server is reachable from sql server box. try ping or telnet to check if port is open, if it is then play with "Server Options" in "New Linked Server"...

use icACLs command to copy the permission, google it dont ask me 🙂 

easy way: give permission to 'everyone' on the root of the drive..  (not recommend)

lucky you .. 

set nocount on
use test
select 'backup database ' + cast(db_name() as varchar) + ' filegroup = ''' + name + ''' to disk =...