Yes, it does

My first select :

A          E:\1.mdf      D

A_1      E:\2_1.ndf  D

A_log  F:\3.ldf        L

My second select:

SrvA      Db1

This is what the result...

I created the function Restore-DbaDatabase , loaded it and tried executing. Was not aware that the DBAtools module had to be installed.

Restore-DbaDatabase -SqlInstance server1\instance1 -Path Z:\Backup -DestinationDataDirectory Z:\Restore -DestinationLogDirectory Z:\Restore

Restore-DbaDatabase : The term 'Restore-DbaDatabase' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the

spelling...

DECLARE @backup_path nvarchar(300);
DECLARE @restore_path nvarchar(300);
DECLARE @cmd nvarchar(1000);
DECLARE @file_list TABLE (backup_file nvarchar(400));
DECLARE @backup_file nvarchar(300);
DECLARE @Table TABLE (LogicalName nvarchar(128),[PhysicalName] nvarchar(128), [Type] varchar, [FileGroupName] nvarchar(128), [Size] nvarchar(128),
[MaxSize] nvarchar(128), [FileId]nvarchar(128), [CreateLSN]nvarchar(128),...

• This reply was modified 8 months, 3 weeks ago by  mtz676.

Have in working and Thank you Jeff !

And happy retirement !! 🙂

• This reply was modified 8 months, 3 weeks ago by  mtz676.

Hello Grant/All,

I have a some databases I would like to dbcc checkdb and sent an email alert if any errors occurs in any of the databases.

I am running DBCC as...

Will try that.Thanks

As part of a SQL jobs which dbcc's all user dbs and if any the dbs report an error then I need an email stating the same...that this db has...

Trying to list down the 10 largest files across all drives from all servers.

Hello Phil, Did as advised. Not working.same error

Thanks for the response..

how do we check what you recommended ?

https://www.sqlservercentral.com/blogs/quick-tip-wmi-alerts-and-sql-server-agent-permissions..

Let me check and get back...

But the query captures data from 100+servers...so how does this work...check on all...

• This reply was modified 9 months, 2 weeks ago by  mtz676.

SELECT
  GETDATE() as now,
  DATEDIFF(SECOND, transaction_begin_time, GETDATE()) as tran_elapsed_time_seconds,
  st.session_id,
  txt.text, 
at.transaction_id as [Transacton ID],
at.[name]      as [Transaction Name],
at.transaction_begin_time...

Thanks for the feedback....

But the failed logins report from the extended events session is giving logins which have not been able to login. How will creating this extended events session...

This is what I see

168138065917 3261686  443399 sleeping                  ...

• This reply was modified 9 months, 3 weeks ago by  mtz676.