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 1 year, 4 months 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 1 year, 4 months 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 1 year, 6 months ago by mtz676.

Have in working and Thank you Jeff !

And happy retirement !! 🙂

• This reply was modified 1 year, 6 months 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 servers or...

• This reply was modified 1 year, 6 months ago by mtz676.