I have tries using couple of different methods.

1. DBCC SHRINKFILE
2. DBCC FREEPROCCACHE
3. There are 8 files in total.

Try this

 IF (OBJECT_ID('tempdb..#DatabaseSize')) IS NOT NULL DROP TABLE #DatabaseSize

 CREATE TABLE #DatabaseSize ( 
DatabaseName VARCHAR(255),
FileLogicalName VARCHAR(255),
FilePhysicalName VARCHAR(1000),
AllocatedGB NUMERIC(12,2),
UsedGB NUMERIC(12,2))

   
  DECLARE @ServerName VARCHAR(255)
DECLARE...

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

I see what you are saying but the problem is not about removing the database. Environment details to help you better understand.

We have AG1 (DAG) which acts as a Primary

We...

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

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 6 years, 2 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 6 years, 2 months ago by LearningDBA.