Tag Info

New answers tagged


.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 ...


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