Thanks Scott

• This reply was modified 5 days, 9 hours ago by  mtz676.
• This reply was modified 5 days, 8 hours ago by  mtz676.
• This reply was modified 5 days, 8 hours ago by  mtz676.

Thank you Jeff. Looks like my google search was not good enough. Thanks again.That helped.

How can I continously import extended events files into a sql server table as and when they are created and once imported remove them from the directory. Thanks

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

How can I continously import extended events files into a sql table as and when they are created ? And once imported get rid of them from the folder.

SQL Server VSS Writer service is enabled. msdb captured backup data until a couple of weeks back when it stopped.

Thank you. But I already know that way. Trying to see if I can avoid centralizing the data into 1 server. No good reason for this.

But wanted to know if...

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 3 months, 4 weeks ago by  mtz676.
• This reply was modified 3 months, 4 weeks 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 4 months, 4 weeks 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.