Viewing 15 posts - 211 through 225 (of 241 total)
I am sure there is however you can also use linked server to query the AD , Google ADSI you will find lots of references , here is example
February 7, 2017 at 1:52 pm
I would
Buy a 3rd party tool if I can afford it.
if not, I would
Rebuild one partition at a time.
use maxdop to make it litter...
February 7, 2017 at 2:18 am
in this case (or whenever you change recovery model) you must take full backup before you can take diff or trn
February 6, 2017 at 9:31 am
Transnational replication can be used to achieve this -- near real time sync., 2nd option is to keep both new and old tables in the same database under different schema...
February 6, 2017 at 12:27 am
I would (assuming one node can handle the workload cuz in my environment it does not)
0) point application to primary node instead of listener [if you want...
February 5, 2017 at 11:50 pm
here is a video TDE demo, that i created while ago.
February 5, 2017 at 9:22 pm
Apparently the master key does not exists in the database which you are trying to alert.
February 2, 2017 at 3:52 pm
January 18, 2017 at 4:13 pm
January 18, 2017 at 3:53 pm
This would work:[code...
January 17, 2017 at 9:53 am
I concur, its out of the frying pan in to the fire.
December 13, 2016 at 12:22 pm
enable auto shrink option for the database ,it will shrink the log file if you are willing to pay price with fragmentation in the database. WHEN DOES AUTOSHRINK OCCOUR
•Both...
December 13, 2016 at 11:20 am
fixed.. the solution was to change database recovery model to simple and back to full, my assumption is that 2nd log file was still holding some information, that is ...
November 23, 2016 at 11:00 am
the log file state is offline.. I wonder why..
November 23, 2016 at 10:52 am
Viewing 15 posts - 211 through 225 (of 241 total)