Doh!

My brain "auto-translated" it to CHAR instead of ASCII, guess that is what it was expecting to see with the numerical values .e.g SELECT CHAR(65),CHAR(66)

🙂

You wouldn't need to change the schedule and if the log file started to fill up beyond 20% (or whatever threshold you set) the tlog backup job would automatically run.

You could also configure a SQL Server Agent Alert to run a transaction log backup job when more than a specified percentage of the log is used.   I have...

Using LEAD instead of LAG.....

WITH FolderCTE AS
(
SELECT
LEAD(id, 1, null) OVER (ORDER BY id) [next_folder]
, id
, folder
FROM #sampledata 
WHERE folder is not null
)
SELECT 
sd.id
    ,...

I'm using the ID column which got added to sort the data.

drop table #sampledata 
go 

create table #sampledata
(
id int identity(1,1),
folder  varchar(100) null,
folder2 varchar(100) null
)
go 

insert into...

Use the LAG function

https://docs.microsoft.com/en-us/sql/t-sql/functions/lag-transact-sql?view=sql-server-ver15

The maximum number of logs you can configure to keep is 99.   It is set to 6 by default but you can increase it in the Configure SQL Server Errors...

You need to name the column in Query1, and also add the size column name back in.

e.g.

SET @Query1 = FORMATMESSAGE(N'''SELECT SUM([master].[sys].[master_files].size)*8/1024 [Size] FROM [master].[sys].[master_files] WHERE [master].[sys].[master_files].[name] = ''''%s''''', @DatabaseName)

And also...

• This reply was modified 5 years, 3 months ago by  tripleAxe.

What is @Query2 defined as?

Management Studio on your client workstation or do you RDP on to each server?  Could it be network?  Try doing a "select * into another_table from table"  or a temp...

where are you running the select from?

but have you restored it on the slow instance? Try restoring it on the slow instance. Restore it using a different database name if you need to and try again...

Have you tried restoring the database on instance 1?

I believe it is in the DataSource table.  The ItemId column references the Catalog(ItemId) column and the Link column also references the Catalog(ItemId) column.

SELECT * FROM ReportServer.dbo.Catalog WHERE ItemID IN...

I would argue that in the UK that even the linkage between a person and an address is not private.   If you are registered to vote you will be on...