Viewing 15 posts - 31 through 45 (of 711 total)
I believe contained database has the stored credentials and validation done on DB end. So you don't need system databases or users to be created.
MS brought in contained Db's to...
December 14, 2022 at 5:12 am
Mirroring is still available in 2019.
Log backup has to be done in sequence , if you want the log backup files for primary server recovery too, take the folder to...
November 22, 2022 at 9:05 pm
Kindly post the screenshot. The windows should have the Login name/User found below on the error.
November 21, 2022 at 1:38 pm
IF it is for a DR activity, why don't you user Log shipping or Mirroring?- Just for clarification.
The same code changes will apply here too.
November 21, 2022 at 1:34 pm
We cant reset the default use accounts, these are individual to each server.
You cannot change post install also.
November 21, 2022 at 12:31 pm
Post full backup restored as "No restore" option , it will accept only the next LSN differential backup, hope you are doing the same.
If in between some one restores a...
November 20, 2022 at 2:59 pm
Though any of the logins in the cloud provider, else finding the server will be difficult.
Verify the logins for your team if any one of them/all are exposed.
November 20, 2022 at 2:50 pm
Go though the link and try configure using performance conditions.
https://learn.microsoft.com/en-us/sql/ssms/agent/alerts?view=sql-server-ver16
November 1, 2022 at 4:48 pm
What is the OS version and have you checked the below link for OS support.
https://learn.microsoft.com/en-us/troubleshoot/sql/general/use-sql-server-in-windows
October 28, 2022 at 5:51 am
I think you are expecting multiple availability groups yes possible for different Db's.
October 1, 2022 at 3:19 pm
I recommend the same what Jeff suggested.
More over during recovery if you have only logs, you need all logs after full backup and in sequence to be restored.
but if you...
September 29, 2022 at 11:19 am
I dont know about AV working structure.
IS AV excluded to scan mdf, ndf, ldf , bak and trn files or respective backup files along with program file\ Microsoft SQL server...
September 29, 2022 at 10:46 am
September 12, 2022 at 2:22 pm
Readable secondary is set to read intent only which means allows on each node only when read intent is mentioned.
set each node parameter of readable secondary to yes and check.
September 12, 2022 at 2:14 pm
IS availability group fluctuating?
if not is the permission level is same on both instances?
Kindly attach screenshot with AG configuration and error.
September 12, 2022 at 10:32 am
Viewing 15 posts - 31 through 45 (of 711 total)