I tried this ..... but it still sends email if there are no records...

IF @@rowcount > 0

--IF (SELECT COUNT(*) FROM #tlogtables) > 0

BEGIN

EXEC msdb.dbo.sp_send_dbmail

@profile_name = 'Default',

Also tried this...

IF (SELECT COUNT(*)...

• This reply was modified 5 months ago by  mtz676.

Thanks Brian. Any thoughts references on how to handle  autogrowth  for file stream databases.

Thank you and how do you handle  autogrowth  for file stream databases.

sqlserver service account  is running under LocalSystem Account on the destination server

On destination server XYZ SQLAgent runs under LocalSystem account.

XYZ$ has been given read/write access to the network share - \\ABCD\E$\BackupsTest\

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

We have several sql backup files on a network share and are trying to restore them onto a sqlserver

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

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 10 months, 1 week ago by  mtz676.

Have in working and Thank you Jeff !

And happy retirement !! 🙂

• This reply was modified 10 months, 1 week 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...