There are 5 files. I think SQL will write on the last file, I am trying open the first file.

We find the issue. The secondary replica is not read intend. So The default DB is user database in Primary but default DB is Master in Secondary replica. When we...

I am sorry. The post is too lengthy, I want rephrase my question simply

1) How can we add the service account (Networkservice\MSSqLOLAPservice) that run on machine 1 to sql server...

If you have SSAS also installed with Database services on the server, do you need to apply cumulative updates separately or it will give you the option to select both...

We have 3rd party monitoring & backup tool. In other servers not seeing this problem

From web application it is executing the SP. The inserts/updates are not working. No error messages to the SQL error log or on app side. It is not related to...

I am thinking about the negative consequences of provisioning free space drastically high.

1. How much difference it will be in backup size and backup time

2. Restoring to the test server....

Thank you. What will happen if the backup verify fail in one of the database? It will start again taking the backup or just tell us the verify option failed

I am not sure what is the issue. Magically it is working fine now, which didn't work yesterday. Thank you for you help.

Thanks,

Sirisha

Hi,

I created the ticket. They add the users to my computer. I can able to run the SSMS as Domain1/Domain1ADM. When I tried to run the SSMS as Domain2/Domain2ADM it...

Thank you.

Thanks,

Ramana

Thank you.  I tried it. I am getting the msg The computer you are signing into is protected by an authentication firewall. The specified account is not allowed to authenticate...

The accounts are in different domains. SSMS is domain/local user & I am trying to run the SSMS domain2/adminuser. I tried using run as command & manually holding the shift...

We are using the database in simple recovery. I believe simple recovery model is also minimally logged.

Thanks for the help.

We figured it out that the alert is coming from different server. They build the new server using the clone of the production server.