Tag Info

New answers tagged

2

.mdf and .ldf files do not show the last modification date in the way you think it does. The file-system date reflects the last time the instance started the database. Modifications to data continue while the instance has the database open, without the instance actually updating the file-system dates for the files in use by the database. Can you add the ...


2

The client connection role for secondary replicas determines whether your database is always available, or only available to read-only connections, or not available at all. If you set the database to read-only connections, then your connection string has to include the parameter ApplicationIntent=ReadOnly as defined in that Books Online page. When you try ...



Top 50 recent answers are included