Can you also provide the SQL Server Patch which you hav installed?
Here are the answers
1) How do you remove a file in a filegroup?
You need to run following two commands and there should be more than one file in a...
thomas I am not disagreeing that 15 min t backup will not suffice, but there are chances that these two process will clash , in my senario i am also...
In my case my db size was 400 GB and 700 transactions pers ec.(tps) were hitting the database. what is your system configuration ?...
I am agree on your point that we should take transactional backup after every 15min. , but if we increase the frquency then the chekpoint...
If the table size is big then do you suggest snapshot replication will work properly?
When I am running DBCC SqlPerf(lrustats) buffer cache hit ratio is coming more than 100.
What is the reason of this
Separate names with a comma.