I tried doing a manual backup(logged in as I) from the server to the network path and it failed...did not work even for me...

need to get hold of the service...

I logged in with my credentials to the sqlserver and not the domain account which the engine is currently running under..

Thanks for the response @Ant-Green

share permissions - the network share folder has r/w access permissions to the sql service account ?

And how do I check NTFS permissions..is it not ....what...

• This reply was modified 2 months, 1 week ago by  mtz676.
• This reply was modified 2 months, 1 week ago by  mtz676.

Does this need to be fixed or is the message informational.

yes

there is no DB database on all the 5 servers...the database is only on ABC server....

• This reply was modified 3 months, 1 week ago by  mtz676.

I tried that...

now I receive this error....

Invoke-Sqlcmd : Cannot open database "DB" requested by the login. The login failed.

Login failed for user 'Domain\User'.

Without a tool what are the options.

We have atleast 200+ instances and I would like a report which states whether the windows box is pingable, if the sqlinstance is up...

Thank you.

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 3 months, 2 weeks 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 7 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 7 months ago by  mtz676.