Thanks for your reply..

By mistakenly posted commends like  5 hours earlier. it seems  5 hours back time from server current time.

I think, database audit logs stored in audit file date...

Hi.

I understood your commends.

Database audit logs captured but I can see that event_time does not show the correct time. Actually it shows 5 hours earlier than time. is it logs...

Thank you..

CREATE DATABASE AUDIT SPECIFICATION [Audit1]

FOR SERVER AUDIT [audit_Logs]

ADD (DELETE ON DATABASE::[DBNAME] BY [public]),

ADD (EXECUTE ON DATABASE::[DBNAME] BY [public]),

ADD (INSERT ON DATABASE::[DBNAME] BY [public]),

ADD (DATABASE_OBJECT_CHANGE_GROUP),

ADD (SCHEMA_OBJECT_CHANGE_GROUP),

ADD (UPDATE ON DATABASE::[DBNAME] BY...

Thank you for you reply.

Reason behind is every night whole VM backup taken and backup completion time 2.5 Hours ,

during backup time AG got failover automatically to node2 due to...

Modified and mentioned my SQL Instance name where target database get inserted from values as below line,, but

Import-DbaCsv -path $targetFile -SqlInstance "DB_servername" -Database DB_Name -Table InventorySQLVersion -AutoCreateTable

below line not working.

$ActiveSQLInstances...

Hi Johan,

Thank you for sharing

I am new to PowerShell scripting , just copied executed in PowerShell ISE but nothing display the results. Please suggest me if something mention (input parameter...

Hi.

Thanks for posting PS script for fetching SQL version.

Invoke-Sqlcmd -ServerInstance "Servername" -Query "Select @@version as SQLVERSION"

I want to store output in sql server table like servername, version...

• This reply was modified 1 year, 5 months ago by  SQL Galaxy.

Thanks for sharing.

In Existing ALWAYSON AG setup, will it possible to configure Publisher role and Distributor role on same existing ALWAYSON AG ? or Does it require distributor role another separate ...

Fixed that issues after removed that subscriber hostname in publisher and maintained only AOAG listener only. tested failover AG setup and standalone publisher connected to subscriber through listener.

Thanks

Hi.

My requirement is don't want use SQL native replication method instead of using application s/w tool and GUI based for SQL server to SQL server data replication from different sites....

hi.

TB002 is Publisher and distributor role.

TB003 is subscriber role. and TBSQLT02 is AOAG listener name.

so AOAG in primary role in TB003 then replication publisher successfully connected to subscriber, if failover...

Hi.

Successfully configured Publisher as a standalone server and Published database too.

Server1 - publisher database has been synchronized to AO availability group  setup as a subscriber Server1 and Server2.

As below commands...

• This reply was modified 2 years, 2 months ago by  SQL Galaxy.

Hi Ant-Green, Thanks for mentioned URL for how replication configured in AOAG setup and send transactional records to another server. but my requirements is receiving records in AOAG from another...

Error:

ConStatus Error [DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security error.

In Application server does not connected to database server due to SQLOLDB driver, how to resolve this error?

Please suggest.

Thanks

Thanks.

Quarantined state cleared now after 5 hours.

what could be reason why node status changed to Quarantined state?

Does it need to change parameter WFC instance side?

Thanks