Its back online and in sync. Took the backup, paused the data movement, restore the DB, join the DB and that's it.

Run this query and tell me what you get?

SELECT 
SPID,
DB_NAME(SP.DBID) AS DBNAME, 
HOSTNAME,LOGIN_TIME,LOGINAME,
CAST(((DATEDIFF(s,start_time,GetDate()))/3600) as varchar) + ' hour(s), ' 
       ...

I am restoring a DB with no recovery. I will then just join the DB.

I have this query I run when I am trying to capture long running queries. You can modify it and capture all the select statement.

Create procedure [dbo].[spSelectQueries] 
as

INSERT...

Ag has been configured the same across all servers.

ON Prem:

SQL1 Primary              synch

SQL2 Secondary         synch

SQL3 Secondary         Asynch

SQL4 Secondary         synch

DR site

SQL15 Primary              synch

SQL16 Secondary         synch

SQL17 Secondary         Asynch

SQL18 Secondary         synch

log backup runs every 15 minutes

I have been monitoring the redo_queue_length on 18 for past hour and the size is not decreasing. Its staying around '3341.....'. I am really not sure what to look for...

I think it really doesn't matter where you are running your tlog backups (either Primary or Secondary).

Have you checked the error log? Did you try to run the log backup...

This issue has been resolved. I was trying to create a client access point from cluster level and that's why it was just giving me all sorts of issues. I...

sys.availability_group_listeners only gave me 1 record (details of an existing listener).

Tried running an alter AG statement with modify listener with port.

ALTER AVAILABILITY GROUP [AG]

modify LISTENER N'Test' (PORT=1433);

Got this error: "The...

Attaching files

This one is helpful as well

DECLARE @serverID  INT

,       @Memory    INT

,       @Edition   VARCHAR (200)

,       @Version   VARCHAR (200)

,       @CoreCount INT;

DECLARE @MemoryOutput TABLE ( MemoryGB INT )

select @serverID = server_id from sys.servers

SELECT @CoreCount...

• This reply was modified 5 years, 6 months ago by  LearningDBA.

Something like this?

DROP TABLE [dbo].INVENTORY

CREATE TABLE [dbo].INVENTORY(

[ID] [int] NULL,

[ServerName] [varchar](200) NULL,

[Database_Name] [varchar](200) NULL,

[Recovery_Model] [varchar](30) NULL,

[Creation_Date] [datetime] NULL,

[Owner] [varchar](50) NULL,

[IS_Mirrored] [int] NULL,

[VLFcount] int

)

--variables to hold each 'iteration'

declare @query varchar(100)

declare @dbname sysname

declare...

• This reply was modified 5 years, 6 months ago by  LearningDBA.

Yep, I was missing an END. That fixed the issue. Thanks!

Not trying to be lazy but one of the server has 128 jobs and some of the jobs have multiple steps, some have SSIS packages. Am I to go through...

Tried string, Unicode string but nothing. Still see NULL value