would you mind to elaborate more on this.  i'm new and...

thanks, brian for the response and info.

i'm not looking for DB level permissions.  as you said when you do a restore, all the database level users, roles, permissions, other objects...

thanks steve

• This reply was modified 11 months, 3 weeks ago by  lan2022nguyen.

how would i backup my master from primary to secondary? and continue to backup new changes (logins, server roles, securables)?

how about new agent jobs on msdb from primaruy to secondary? ...

thank you both @jeff and @johan, i'm still new to db administration and learning about the project/app as well.  as such, some questions you asked i'm unable to...

these are read-only dbs.  there's no...

the permission needed to execute the sp is view server state.  it worked once i added

Thank you @Brian and @ken.

using smalldatetime worked for excel.

set nocount on worked.

@ken, thanks for the suggestion in putting this as a stored proc.  i didn't use yours, but i did create a sp with my t-sql.  seems to be...

I can only think of 2 reasons for this. First is permissions - are you using the same account to run the bat/ps1 file or are you changing accounts...

• This reply was modified 11 months, 4 weeks ago by  lan2022nguyen.

We have another instance where the user does...

got it, thanks @Ant-Green.

@Ant-Green, so the permission should be granted to a domain service account and not to the 2 virtual service accounts?  thanks

hello andreas - the sysadmin was the one that was helping the setup and he couldn't find the account to grant the share permission.

and yes, both accounts are on every...

thanks for your clarification/assistance.  i still have alot to learn about performance/indexing.