Thanks guys for your input , lets not get confused by why I need it

Yes I am manually running in SSMS, I am in windows group which has sysadmin, yet the query shows null in 'IsSysadmin' column, I plan to create a notification if...

([server_principal_name] in (select name from sys.syslogins where sysadmin=1))

1) check always-on is enabled in SQL configuration manager or run SELECT SERVERPROPERTY ('IsHadrEnabled');
2) check you are local admin on all nodes 
3) check cluster permission by right...

run the below script to find out if you need more temp files.
ummm.. do you need enable  traceflag 1118 ?

USE Master
GO
SET NOCOUNT...

you can probably avoid additional resources used by power-shell by simply mapping the drive on the destination server through tsql and restore the backup, you do not even need to...

well I hope it works for you, I personally like to keep the audit data in separate files, the reason being is (1) I can manage audit myself, what ever...

I doubt you can do anything about it, there is a reason it is called 'Managed' backup

not sure where to look, but may be you can create a startup procedure to ensure audit is enabled when sql comes up, I am not sure if it will...

Well I have a database where owner of db_datareaer and db_datawriter is dbo, not sure why is that (some genius DBA I suppose), I want to fix it however I...

back to original question as to whats going on ..  good luck

http://searchsqlserver.techtarget.com/tip/Determining-the-source-of-full-transaction-logs-in-SQL-Server

thanks, it works

select a.*,b.* from errors a, errors b where a.logentry like 'Error:%' and b.rowid=(a.rowid + 1) order by a.entrytime desc