Viewing 12 posts - 1 through 12 (of 12 total)
I restored it to standby mode which shrink the data file successfully.
(no...
June 25, 2018 at 2:19 am
fizzleme - Friday, June 22, 2018 2:20 PMThank you.
《Pro SQL Server Always on Availability Groups》 is an excellent book about always on.you...
June 24, 2018 at 11:52 pm
i am trying to disable the all the sql jobs and stop the SQL Agent...
June 24, 2018 at 11:45 pm
Was trying to setup DB mirroring w asynchronous mode (sql server 2014 std edition sp2)...
June 21, 2018 at 11:30 pm
We have recently set up an asynchronous AlwaysOn AGs in our production environment (our...
June 21, 2018 at 11:19 pm
Log reader agent and distribution agent is runing.The permissions at the distributor is ok.
because it runs normally before ther restarted. Yes,It is transactional replication.
August 26, 2015 at 7:21 pm
You can't shrink log on mirrored db directly without removing mirror.
I think You should do log backup on the principle server regularly so that the log space can be...
August 13, 2015 at 7:43 pm
The DBCC SHRINKFILE command will be mirrored from the principal to the mirrored database. I think you can just shrink the principal database!
August 13, 2015 at 2:47 am
Thanks a lot.I will read the post first.
August 3, 2015 at 8:20 pm
Thanks a lot!I also prefer the second one .
when should i use the first one?
August 3, 2015 at 8:17 pm
hi.first ,i think u should find out what ther server in doing when the server is slow.
1.is there waits or blocking?
2.check sql server error log. check whether...
July 24, 2015 at 1:10 am
you have more than one data file .you should add "move to " for them.
July 23, 2015 at 3:21 am
Viewing 12 posts - 1 through 12 (of 12 total)